Oracle Database Administration II - 1Z0-083 Exam Questions

A. It cannot be used to provision applications. B. It is an Oracle Grid Infrastructure service. C. It can be used to deploy Oracle Database homes. D. It can be used to deploy Grid Infrastructure homes, including Oracle Restart. E. It is an Oracle Database service. F. It cannot be used to provision middleware.

A. It must have an application seed PDB. B. It must have an application root PDB. C. An application PDB can belong to multiple application containers. D. It can contain a single application. E. It can contain multiple applications. F. Two application containers can share an application seed PDB.

A. Data file 24 must be recovered while PDB2 is closed. B. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened. C. Data file 24 cannot be recovered while the CDB is opened. D. Data file 24 can be recovered while PDB2 is opened. E. Data file 24 must be recovered while the CDB is opened.

A. Unicode enables information from any language to be stored using a single character set. B. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA). C. Multibyte character sets allow more efficient space utilization than single byte character sets. D. Single-byte character sets always use 8-bit encoding schemes. E. Single-byte character sets always use 7-bit encoding schemes. F. Single-byte character sets provide better performance than multibyte character sets.

A. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database. B. A database can be flashed back using SQL*PLUS. C. It always generates REDO and UNDO. D. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time. E. It requires that the target database be in ARCHIVELOG mode. F. FLASHBACK LOGS are archived after a log switch.

A. It has the same number of roles as CDB1. B. It is in mount state after creation. C. It has the same common users defined as does CDB1. D. It has only local roles. E. It has no local users. F. Service PDB1 is created for remote logins to PDB1.

A. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session. B. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited. C. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service. D. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions. E. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session. F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

A. PDB1 and PDB2 are in READ ONLY state. B. PDB$SEED is in READ ONLY state. C. Redo logs are opened. D. PDB1 and PDB2 are in MOUNT state. E. CDB$ROOT is in MOUNT state.

A. RMAN uses the pull method to restore files using image copies B. RMAN uses the pull method to restore files using backup sets C. RMAN uses the push method to transfer image copies D. RMAN uses the push method to transfer backup sets

A. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback. B. A table's indexes must be set to unusable before issuing the flashback. C. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner. D. Row Movement must be enabled on the table being flashed back. E. A table's constraints must be disabled before issuing the flashback.