Examine the following parameters for a database instance:MEMORY_MAX_TARGET=0 -MEMORY_TARGET=0 -SGA_TARGET=0 -PGA_AGGREGATE_TARGET=500m -Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)
Examine the contents of SQL loader control file:Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # #A_ADMIN in root and all PDBs. You execute the following command from the root container:SQL > REVOKE create table FROM C # # A_ADMIN;What is the result?
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database(CDB)? (Choose two.)
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true? (Choose two.)
Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?
