1Z0-083 Online Practice Questions and Answers

A container database called CDB1 is OMF-enabled.

PDB_FILE_NAME_CONVERT is not configured in CDB1.

PDB1 was unplugged from CDB1 earlier 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. PDB1 data files already exist in the correct location.

B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

C. PDB_FILE_NAME_CONVERT must be set before executing the command.

D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

E. PDB1 must be dropped from CDB1.

Which two are true about gathering optimizer statistics? (Choose two.)

A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.

C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

D. System statistics can be gathered only while connected to CDB$ROOT.

E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Which three are true? (Choose three.)

A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

B. Application-common TSDP policies are always container specific.

C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.

G. Unified auditing can be automatically synchronized to all application PDBs in an application container.

Which two are true about RMAN encryption? (Choose two.)

A. RMAN encryption keys are stored in a database keystore.

B. RMAN can encrypt the Oracle Database password file.

C. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

D. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

E. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

C. SPFILE backups can be created while connected to an application root PDB.

D. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

A. It is used to change failure priority only for HIGH or LOW priorities.

B. It is used to execute the advised repair script.

C. It is used to change failure priority only for the CRITICAL priority.

D. It is used to explicitly close the open failures.

E. It is used to inform the database about the repair after the repair script executes.

You execute this command successfully:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

What is the outcome?

A. It creates a binary backup of the control file.

B. It updates the alert log with the location and contents of the control file

C. It creates a file that contains SQL statements to re-create the control file.

D. It creates a file that contains RMAN scripts to create a duplicate database.

E. It creates a copy of the control file in the fast recovery area (FRA).

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

A. Decreasing PCTUSED

B. Decreasing PCTFREE

C. Increasing the number of DBWN process

D. Using Automatic Segment Space Management (ASSM)

E. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation

Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

A. when the duplicate ... from active database command contains the section size clause

B. when you perform active database duplication on a database with flashback disabled

C. when you specify set encryption before the duplicate ... from active database command

D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

E. when you perform active database duplication on a database that has readonly tablespaces

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

A. ADDM can run in a nonroot container.

B. AWR snapshots can be created in CDB$ROOT.

C. AWR reports can be generated while connected to any container.

D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E. AWR snapshots can be created in a PDB.

F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.