Which three are true about Automatic Workload Repository (AWR)?

• A.By default, AWR snapshots are retained for 7 days.
• B.AWR data is stored in the system tablespace.
• C.Its collection level is determined by the value of the statistics_level database parameter.
• D.The taking of AWR snapshots can be disabled.
• E.By default, AWR snapshots are taken every 60 minutes.

Comment: *

Name: *

Email: *

Verification: *

You issued this command: RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)

• A.All Oracle recovery files in the current FRA that have not been backed up already, are backed up. D)All Oracle recovery files in the current fast recovery area (FRA) are backed up.
• B.These backups can be written to disk or SBT.
• C.All non-Oracle files in the current FRA that have not been backed up already, are backed up.
• D.All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

• A.A PDB snapshot is always a full copy of the source PDB.
• B.A PDB snapshot is always a sparse copy of the source PDB.
• C.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• D.A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• E.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• F.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• G.A snapshot copy PDB can be created from a stand-alone clone PDB.

Comment: *

Name: *

Email: *

Verification: *

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

• A.PDB2 will be MOUNTED.
• B.PDB1 will be opened READ WRITE.
• C.PDB$SEED will be opened READ ONLY.
• D.PDB2 will be opened READ WRITE.
• E.PDB$SEED will be MOUNTED
• F.PDB1 will be MOUNTED.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three actions will add a resource to an Oracle Restart configuration?

• A.creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
• B.creating a database using the CREATE DATABASE SQL statement
• C.creating a database service using Oracle Database Configuration Assistant (DBCA)
• D.creating an Oracle Database service by modifying the SERVICE_NAMES parameter
• E.creating a disk group using the CREATE DISKGROUP SQL statement
• F.creating a database service using DBMS_SERVICE.CREATE_SERVICE

Comment: *

Name: *

Email: *

Verification: *