Free Oracle 1Z0-083 Exam Questions

Become Oracle Certified with updated 1Z0-083 exam questions and correct answers

Page: 1 / 57

Total 285 Questions | Updated On: Mar 27, 2025

Add To Cart

Question 1

Which two are true about creating RMAN backups for an Oracle container database?

A : line Redo Log backups can be created while connected to CDB$ROOT

B : Control file backups can be created while connected to CDB$ROOT.

C : The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.

D : chived Redo Log backups can be created while connected to PDB

E : Control file backups can not be created while connected to a PDB

Answer: A,B

Question 2

Choose two. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

A : ta Recovery Advisor can proactively check for failures.

B : ing the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

C : Recovery Advisor can be used if a database is in the NOMOUNT state.

D : failure can be closed only if the database is in MOUNT state.

E : ta Recovery Advisor can be used if a database is closed.

Answer: A,B

Question 3

Choose two You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID ------------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?

A : -create or migrate the password file to the Oracle Database 12c format

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

C : py the password file from a sample file in the DBS dierectory

D : ign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.

Answer: A,B

Question 4

choose two Which two are true about RMAN image copies?

A : ey can only be written to disk.

B : ey can be encrypted using Transparent Data Encryption (TDE).

C : ey can be used as a level 0 incremental backup.

D : ey can be used as a level 1 incremental backup.

E : They are the only backup option available for databases in NOARCHIVELOG mode.

Answer: A,C

Question 5

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

A : B1 and PDB2 are in MOUNT state.

B : Redo logs are opened.

C : B1 and PDB2 are in READ ONLY state.

D : B$ROOT is in MOUNT state.

E : B$SEED is in READ ONLY state.

Answer: A,D

Page: 1 / 57

Total 285 Questions | Updated On: Mar 27, 2025

Add To Cart