Oracle 1Z0-083 Exam Real Questions

Prepare and pass your Oracle Database Administration II with free 1Z0-083 exam questions.

Page: 1 / 57

Total 285 Questions | Updated On: Oct 11, 2024

Add To Cart

Question 1

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

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

B : 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 : report on the database schema at an earlier point in time.

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

Answer: A,B,D

Question 2

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

A : UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B : AN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C : UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D : UNDO TABLESPACE clause is never required.

E : AN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

Answer: A,B

Question 3

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

A : R snapshots can be created in CDB$ROOT.

B : DM can run in a nonroot container.

C : R reports can be generated while connected to any container.

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

E : R snapshots can be created in a PDB.

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

Answer: A,D

Question 4

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

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

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

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

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

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

Answer: B,C

Question 5

Choose three. Which three are true about a container database (CDB)?

A : can be created from a non-CDB.

B : can contain only one PDB$SEED, which is created when the CDB is created.

C : can have local users with the same name in different PDBs.

D : can contain only one Application Container seed, which is created when the Application Container is created.

E : can be created by cloning an existing CDB.

F : can have any number of pluggable databases (PDBs) limited only by space availability.

G : contains predefined common roles in both the root and the seed.

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Oct 11, 2024

Add To Cart