최신 1z0-497 무료덤프 - Oracle Database 12c Essentials

A. The bitmap index is rebuilt automatically after a DML operation.

B. The smallest amount of a bitmap that can be locked is a bitmap segment.

C. The DML operations re-create the bitmap index blocks.

D. Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

A. The redo log buffer becomes full.

B. The database advances a checkpoint.

C. A client process commits a transaction.

D. A tablespace is changed to read-only status.

E. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

F. The database is shut down in immediate mode.

A. Mike and Tim do not need to worry, because recovery of individual PDBs is possible.

B. Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.

C. Recovery of individual PDBs is not possible at all.

D. Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.

A. Undo records contain copies of data as it appears after a change is made.

B. Undo records contain copies of data as it appears before a change is made.

C. They are required to support Flashback features.

D. They are not required if Flashback features are enabled.

E. They are retained until the session making the changes ends.

A. FILESYSTEMIO_OPTIONS

B. CLONEDB

C. DB_CREATE_FILE_DEST

D. RECYCLEBIN

E. TAPE_ASYNCH_IO

A. Multiple transactions can use the same undo segment.

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

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

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

A. After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

B. These administrative privileges enable you to connect to the database only if the database is open.

C. Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

D. These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

A. Automatic Storage Management (ASM)

B. OS file system

C. clustered file system

D. logical volume (LVM)

E. RAW

A. Rows with a NULL value in key columns also have entries in the Index.

B. The leaf blocks in the index are doubly linked.

C. The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.

D. The leaf node stores a bitmap for each key value.

A. mapping table

B. materialized view

C. cluster

D. database link