1Z0-083 Online Practice Questions and Answers

Examine this configuration:

1.

CDB1 is a container database.

2.

PDB1 and PDB2 are pluggable databases in CDB1.

3.

PDB1 and PDB2 are OPEN in READ WRITE mode. You execute these commands successfully:

Which two are true? (Choose two.)

A. Uncommitted transactions in PDB1 have been rolled back.

B. PDB1 is closed.

C. Uncommitted transactions in CDB1 and PDB1 have been rolled back.

D. CDB1 is shut down.

E. CDB1 is in MOUNT state

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.

You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.

Which two are always true? (Choose two.)

A. CDB1 and CDB2 must be in shared undo mode.

B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D. Cloning HR_ROOT automatically clones HR_PDB1.

E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.

B. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.

C. A new PDB is automatically created when importing a non-CDB into a CDB.

D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

E. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Which three are true about an application container? (Choose three.)

A. It can contain a single application.

B. It can contain multiple applications.

C. It must have an application seed PDB.

D. It must have an application root PDB.

E. Two application containers can share an application seed PDB.

F. An application PDB can belong to multiple application containers.

Which two are true about RMAN duplexed backup sets? (Choose two.)

A. They can be written only to disk.

B. They must be written to media.

C. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.

D. They can be created only by using the COPIES option of a BACKUP command.

E. They can be written to media.

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

A. A PDB snapshot can be a sparse copy of a source PDB.

B. A PDB snapshot depends on an existing storage snapshot of the source PDB.

C. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

E. A PDB snapshot can be a full copy of a source PDB.

F. A snapshot copy PDB can be a full copy of a source PDB.

G. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output? (Choose three.)

A. Some messages in the error stack are not errors.

B. If an RMAN command fails, the output will only identify the command that failed.

C. If an RMAN command fails, the output will identify the channel ID where the failure occurred.

D. Media Management errors appear as a line with "sbtio" and a number.

E. Media Management errors appear as a line with "sbtio".

F. Media Management errors appear as a line with "Additional information" and a number.

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

A. They are generated if STATISTICS_LEVEL is set to TYPICAL.

B. They are generated if STATISTICS_LEVEL is set to ALL.

C. They are always created automatically.

D. They are always created manually.

E. They can be retained forever.

F. They are generated if STATISTICS_LEVEL is set to BASIC.

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

F. BACKUP SPFILE SECTION SIZE 1M;

G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)

A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E. Re-createthepasswordfileintheOracleDatabase12cformat. Correct

Which three are true about upgrading an application in an application container? (Choose three).

A. An application root clone gets created automatically.

B. The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

C. After an application upgrade, the application container's PDBs remain synchronized with the existing application root.

D. The upgrade must be performed when connected to CDB$ROOT.

E. An application name and version number must be specified to upgrade the application.

F. After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

Examine the command to duplicate a database:

Which two statements are true about the DUPLICATE command?

A. The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.

B. A backup of pdb1 and pdb5 must exist before executing the command.

C. The root and the seed database in the container database (CDB) are also duplicated.

D. A backup of CDB and pdb1 and pdb5 must exist before executing the command.

E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

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

A. It facilitates and helps to enforce keystore backup requirements.

B. It handles encrypted data without modifying applications.

C. It enables a keystore to be stored only in a file on a file system.

D. It enables separation of duties between the database administrator and the security administrator.

E. It transparently decrypts data for the database users and applications that access this data.

F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Which two are prerequisites for creating a backup-based duplicate database?

A. connecting to the target database and a recovery catalog to execute the duplicate command

B. creating a password file for an auxiliary instance

C. connecting to an auxiliary instance

D. matching the database identifier (DBID) of the source database and the duplicate database

E. creating an SPFILE for the target database

Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? (Choose three).

A. The control file is backed up whenever a new tablespace is created.

B. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

C. The control file is backed up whenever a new table is created.

D. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

E. It requires the use of fast recovery area (FRA).

F. The control file is backed up automatically each time the SPFILE is backed up manually.