최신Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074무료샘플문제

A. It is not audited because audit records are stored only when unified auditing is enabled in the database.

B. It is audited because unified auditing is disabled be default.

C. It is audited because, by default, the database is in mixed auditing mode with default policies enabled.

D. It is audited because, by default, all user activities in the database are audited.

E. It is not audited because the table belongs to another schema.

A. sys-owned objects stored in sysaux-defined tablespaces

B. clustered tables with dependent materialized views

C. index-organized tables stored in system-defined tablespaces

D. heap tables with composite primary key constraints

E. heap tables with dependent materialized views

A. It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

B. It creates a backupset of the source database in the /home/oracle/backup directory

C. It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.

D. It successfully completes.

E. The backup fails because the UNPLUG operation for cross-endian platforms is not supported.

A. when an equality operator is used

B. when a non-equijoin is used and the join column in at least one of the tables is a primary key

C. when a non-equijoin is used between a table and a sorted hash cluster

D. when any self-join is done

E. when a non-equijoin is used and the join column for both tables is a primary key

A. range

B. list

C. virtual column-based

D. interval

E. hash

A. RMAN can recover the table only from a backupset.

B. There must be sufficient space to start the auxiliary instance.

C. The COMPATIBLE parameter must be set to 12.0 or greater.

D. RMAN must use a recovery catalog.

E. The database must be in the READ WRITE state.

F. The database must be in ARCHIVELOG mode.

G. FLASHBACK DATABASE must be enabled.

H. An export dump file of the table must be available.

A. The tfact1 command fails because it can be set only by the Oracle software owner.

B. TFA collects new diagnostic data but logs a warning message.

C. TFA does not collect new diagnostic data when the maximum repository size is reached.

D. TFA collects new diagnostic data while the repository directory's file system has free space.

E. TFA collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 G

A. sessions that are blocking other sessions

B. UNDO quota for a consumer group

C. number of parallel queries issued by a consumer group

D. sessions that are not blocking other sessions

E. maximum number of DML operations performed by a consumer group