最新的Oracle 1z0-497免費考試真題

問題1

There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:
lsnrctl start listener2
What would be the outcome?

A. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

B. It starts the second listener and terminates all current sessions.

C. It starts the second listener without affecting current sessions.

D. It gives an error because multiple listeners cannot run simultaneously.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題2

Which two statements describe data dictionary views?

A. They are owned by the SYS user.

B. They are based on virtual tables.

C. The VSFIXED_TABLEview can be queried to list the names of these views.

D. They are stored in the SYSTEM tablespace.

E. They speed up query and data manipulation language (DML) operations.

正確答案: A,D

問題3

Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B.
which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.
Which two solutions would you recommend to your customer?

A. Oracle Streams

B. Oracle Active Data Guard

C. Oracle GoldenGate

D. Oracle Advanced Replication

正確答案: B,C

問題4

Which three options correctly match environment variables with their specific functionality?

A. ORACLE_SID specifies the global database name.

B. ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.

C. ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.

D. ORACLE_SID specifies the instance name.

E. ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.

F. ORACLE_HOME specifies the directory containing the Oracle software executables and network files.

正確答案: D,E,F

問題5

Which statement is true about loading data by using the conventional path of SQL*Loader?

A. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,

B. No exclusive locks are acquired when the conventional path loads are performed.

C. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.

D. Redo is not generated while performing conventional path loads.

E. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題6

Which three statements are true about a database instance that has mounted a database but has not opened it?

A. Instance recovery is performed for the database.

B. An alert log and trace files are open.

C. Data files are open in read-only mode.

D. System Global Area (SGA) is allocated and background processes are started.

E. System administrators and users with the CREATE SESSION system privilege may connect to the instance.

F. A control file is open.

正確答案: B,D,F

問題7

A. Option D

B. Option B

C. Option C

D. Option E

E. Option A

正確答案: C,D,E

問題8

Which three tasks can you perform in Database Express?

A. Create database structures.

B. Start up the database.

C. Shut down the database.

D. Manage users and security.

E. View performance and status information about the database instance.

正確答案: A,D,E

最新的Oracle Database 12c Essentials - 1z0-497免費考試真題

聯系我們

站內鏈接

最新更新