Free Oracle 1Z1-083 Exam Dumps Questions & Answers

A container database called CDB1is OMF-enabled.
PDB_FILE_NAME_CONVERTis not configured in CDB1.
PDB1was unplugged from CDB1earlier in the week.
Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

• A.DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
• B.PDB1 data files already exist in the correct location.
• C.PDB_FILE_NAME_CONVERT must be set before executing the command.
• D.PDB1 must be dropped from CDB1.
• E./u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

Examine this configuration:

While CDB1is open,
'/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is
accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

• A.It will re-create `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
• B.It will create `/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
• C.It will create `$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
• D.It will fail because there is no autobackup of the controlfiles.
• E.It will create `/u01/app/oracle/product/12.2.0.1/db_1/dbs/ snapcf_cdb1control02.ctl'.

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
(Choose three.)

• A.ADDM performs its analysis only when a DBA requests it.
• B.By default, AWR snapshots are automatically purged after eight days.
• C.By default, MMON creates an AWR snapshot every 30 minutes.
• D.ADDM can recommend shrinking the buffer cache.
• E.AWR snapshots must be deleted when no longer required by ADDM.
• F.ADDM can recommend extending the buffer cache.

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

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

Which three statements are true about the keystore storage framework for transparent data encryption?

• A.It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.
• B.It enables separation of duties between the database administrator and the security administrator.
• C.It transparently decrypts data for the database users and applications that access this data.
• D.It handles encrypted data without modifying applications.
• E.It facilitates and helps to enforce keystore backup requirements.
• F.It enables a keystore to be stored only in a file on a file system.