1Z0-083 Practice Online

Question 1

Choose two. Which two statements are true when row-archival management is enabled?

A : The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.

B : The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query

C : The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

D : The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.

E : The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.

Answer: B,C

Question 2

choose two Which two are true about RMAN image copies?

A : They can only be written to disk.

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

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

D : They 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 3

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

A : orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

B : root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

C : The sudo password can be specified in a response file.

D : root.sh can be executed automatically by the Database installer only by using sudo credentials

E : The sudo password must be specified in a response file.

F : The root password cannot be specified in a response file.

Answer: A

Question 4

Choose three. Which three are true about cloning databases into an existing CDB with RMAN?

A : A non-CDB can be cloned into a PDB.

B : A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

C : Only one PDB can be cloned at a time.

D : Two or more PDBs can be cloned with the same command.

E : A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

F : The target and auxiliary instance passwords must be the same.

Answer: A,B,C

Question 5

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

A : to allow database duplication without a connection to the target instance

B : to store backup metadata that would cause the controlfile to become too large.

C : to store backups that would cause the controlfile to become too large

D : to report on the database schema at an earlier point in time.

E : to allow database duplication without a connection to the auxiliary instance.

Answer: A,B,D

Name:	Oracle Database Administration II
Exam Code:	1Z0-083
Certification:	Oracle Database
Vendor:	Oracle
Total Questions:	285
Last Updated:	Apr 22, 2024

Download Demo 1Z0-083 Dumps

Create Account

Password Recovery

1Z0-083 Practice Online

Download Demo 1Z0-083 Dumps

Member Login

Create Account

Password Recovery

1Z0-083 Practice Online