Oracle Database 12c: Advanced Administration Free Sample Questions

Which three statements are true about compression of backup sets? (Choose three.)

Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:SQL)STARTUPWhich two statements are true about the successful execution of the command? (Choose two.)

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

Users report this error message when inserting rows into the orders table:ERROR at line1:
ORA-O1654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1.Make the tablespace read-only at the source database.
2.Export metadata from the source database.
3.Import metadata into the target database.
4.Transferthe dump file and data files to the target machine.
5.Convert data files by using Recovery Manager (RMAN).
6.Make the tablespace read-write at the target database.

Identify the required steps in the correct order.

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.

Which two statements are true? (Choose two.)

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.

You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.

NAME TYPE VALUE
audit_file_dest string /u01/app/oracle/admin/eml2rep/adump
background_dump_dest string
core_dump_dest stringdb_create_file_dest string
db_recovery_file_dest string
/u01/app/oracle/fast_recovery_area diagnostic_dest string

What is the location of the ADR base?

Which two statements are true about unified auditing? (Choose two.)

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:.
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.

Which alter TABLE option would you recommend?

Examine the
RMAN commands executed in your database:
RMAN) CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN) CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;
RKAN) CONFIGURE CONTROLFILE AUTOBACKUP ON;

You issue the command:RMAN) BACKUP DATABASE;Which two statements are true about the command? (Choose two.)