Oracle Database Administration II - 1Z0-083 Exam Practice Test

Question 1

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?
(Choose three.)

A. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

B. A whole database backup must exist before upgrade

C. DBUA must be launched from the target Oracle Home.

D. The database must be opened in read-only mode.

E. The Pre-Upgrade Information Tool script is executed by DBUA.

F. All pluggable databases are automatically upgraded as part of a container database upgrade.

Correct Answer: C,E,F

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)

A. A CDB-level resource plan can limit PDB CPU utilization.

B. PDB-level resource plans can limit uncommitted UNDO per consumer group.

C. A CDB-level resource plan can limit session CPU utilization.

D. A CDB-level resource plan is mandatory when using PDB-level resource plans.

E. A PDB-level resource plan can limit session PGA memory.

F. A CDB-level resource plan can limit PDB UNDO use.

Correct Answer: A,B,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

Application PDBs, SALES_APP1and SALES_APP2, must be created and they must access common tables of the SALES_APPapplication.
Examine these steps:
1. Install the SALES_APPapplication, including the common tables, in the application root.
2. Install the SALES_APPapplication in the application root and the common tables in both the CDB root and the application root.
3. Create an application seed.
4. Install the SALES_APPapplication in the application seed.
5. Create the SALES_APP1and SALES_APP2application PDBs.
6. Sync the SALES_APP1and SALES_APP2application PDBs with the application root.
7. Sync the SALES_APP1and SALES_APP2application PDBs with the application seed.
8. Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

A. 1, 5, 6

B. 1, 3, 5, 6, 7

C. 3, 4, 1, 6, 8

D. 1, 3, 5, 7

E. 2, 5, 6

Correct Answer: A

Question 4

You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

A. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

C. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Correct Answer: C

Question 5

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?

A. Re-createthepasswordfileintheOracleDatabase12cformat. Correct

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

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

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

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

Correct Answer: B,E

Question 6

You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)

A. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

B. All files in the current FRA that have been backed up already, are backed up.

C. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.

D. All files in any previous FRA that have been backed up already, are backed up.

E. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.

F. All files in any previous FRA that have not yet been backed up, are backed up.

G. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.

Correct Answer: A,E,G

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

A. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.

B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.

C. Row Movement must be enabled on the table being flashed back.

D. A table's indexes must be set to unusable before issuing the flashback.

E. A table's constraints must be disabled before issuing the flashback.

Correct Answer: B,C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

Which two statements are true about the Oracle Database server architecture?

A. An Oracle Database server process is always associated with a session.

B. Each server process has its own User Global Area (UGA).

C. A connection represents the state of a user's login to an instance.

D. An Oracle Database server process represents the state of a user's login to an instance.

E. The entire data dictionary is always cached in the large pool.

Correct Answer: B,C

Question 9

Which three RMAN persistent settings can be set for a database?

A. default section size for backups

B. backup retention policy

C. multiple backup device types for a single backup

D. default destinations for backups

E. default backup device type

Correct Answer: B,D,E

Oracle Database Administration II - 1Z0-083 Exam Practice Test

Latest Update

Useful Links

Contact Us