최신Oracle Database 12c Essentials - 1z0-497무료샘플문제

A. Multiple transactions can use the same undo segment.

B. If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.

C. A transaction is assigned an undo segment when it is started.

D. Multiple transactions cannot share the same extent in an undo tablespace.

A. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

B. Oracle recommends that you back up the root. sh script after you complete the installation.

C. You should not install the Oracle Database software into an existing Oracle home from a different release.

D. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

E. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

A. A buffer cache contains exactly three pools: default, keep, and recycle pool.

B. A buffer cache stores copies of data blocks from all files of the database.

C. A buffer cache always resides completely in System Global Area (SGA).

D. When a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.

E. Buffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.

A. DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

B. It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

C. It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

D. It is used to retrieve installed patch information from a SQL prompt.

A. Multiple listener processes can run simultaneously on a host.

B. Multiple database instances can be registered with a single listener,

C. Listener-related errors can be traced only at the administrative level.

D. Listeners use only the TCP/IP protocol.

E. Only one database instance can be registered with a single listener at any time.

A. Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.

B. You can perform incomplete recovery by using the command:
RESTORE DATABASE;
FROM TAG "consistent_whole_backup";
RECOVER DATABASE NOREDO;

C. You can perform complete recovery by using the command:
RESTORE DATABASE
FROM TAG"consistent_whole_backup";
RECOVER DATABASE;

D. Media recovery is possible in most cases.

A. recompile it

B. rewrite its SQL queries

C. relink

D. nothing; it is transparent

E. rework the applications schema

A. 2, 3, 5, and 6

B. 2, 3, 4, 5, and 6

C. 3, 4, and 5

D. 1, 2, 5, and 6

E. 1, 2, 3, and 4

F. 1, 2, 3, 4, 5, and 6

A. Active Data Guard

B. Oracle Real Application Clusters

C. Oracle Transportable Tablespaces

D. Oracle Cloud Platform as a Service

E. Oracle GoldenGate