Oracle 1z0-083 Exam Dumps

Oracle Database Administration II

Oracle 1z0-083 Sample Questions

Question # 1

Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)

A. They are generated if STATISTICS_LEVEL is set to TYPICAL.
B. They are generated if STATISTICS_LEVEL is set to ALL.
C. They are always created automatically.
D. They are always created manually.
E. They can be retained forever.
F. They are generated if STATISTICS_LEVEL is set to BASIC.

Answer: A,C,F

Show Answer

Question # 2

Your container database, CDB1, has an application container, HR_ROOT, with anapplication PDB, HR_PDB1.You have the required privilege to clone HR_PDB1 to container database CDB2, whichdoes not containHR_ROOT.Which two are always true? (Choose two.)

A. CDB1 and CDB2 must be in shared undo mode.
B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASEprivilege.
C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
D. Cloning HR_ROOT automatically clones HR_PDB1.
E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

Answer: B,D

Show Answer

Question # 3

Which three are true about monitoring waits for sessions and services? (Choose three.)

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

Answer: B,C,F

Show Answer

Question # 4

Which three are true about patchsets? (Choose three.) 

A. They can be applied in a rolling fashion for Clusterware and the databases.  
B. They can introduce new features.
C. They are installed via OPatch or OPatchAuto.
D. Installing a patchset is considered an “upgrade”.
E. They are only released quarterly.
F. A base release is not needed to install patchsets.

Answer: D,E,F

Show Answer

Question # 5

Which three can be done using Oracle Database Configuration Assistant (DBCA) startingfrom Oracle Database 19c? (Choose three.)

A. cloning a remote container database in interactive mode
B. cloning a remote pluggable database in silent mode
C. relocating a remote pluggable database in interactive mode
D. relocating a remote container database in silent mode
E. cloning a remote container database in silent mode
F. relocating a remote pluggable database in silent mode
G. relocating a remote container database in interactive mode

Answer: B,E,F

Show Answer

Question # 6

Which two are true about creating RMAN backups for an Oracle container database?(Choose two.)

A. Online Redo Log backups can be created while connected to the root container.
B. Control file backups can be created while connected to the root container.
C. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN isconnected toCDB$ROOT.
D. Archived Redo Log backups can be created while connected to an application root CDB.
E. Control file backups can be created while connected to a nonroot container.

Answer: D,E

Show Answer

Question # 7

Which three are true about thresholds, metrics, and server-generated alerts? (Choosethree.)

A. All metrics are instance related.
B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
C. A space usage management alert is automatically cleared after the underlying problemis resolved.
D. They are generated by SMON when a tablespace is 97% full.
E. Metrics are statistical counts for a specific unit.
F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Answer: B,C,E

Show Answer

Question # 8

How do you configure a CDB for local undo mode?

A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASELOCAL UNDO ON,and then restart the CDB instance.
B. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASELOCAL UNDO ON,and create an UNDO tablespace in each PDB, then restart the CDB instance.
C. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace.Execute ALTERDATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.
D. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTERDATABASE LOCAL UNDO ON,and then change the CDB to read/write mode.
E. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASELOCAL UNDO ON,create an UNDO tablespace, and then restart the CDB instance.

Answer: B

Show Answer

Question # 9

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they mustaccess common tables ofthe SALES_APP application.Examine these steps:1. Install the SALES_APP application, including the common tables, in the application root.2. Install the SALES_APP application in the application root and the common tables in boththe CDB root andthe application root.3. Create an application seed.4. Install the SALES_APP application in the application seed.5. Create the SALES_APP1 and SALES_APP2 application PDBs.6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.7. Sync the SALES_APP1 and SALES_APP2 application 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. 3, 4, 1, 6, 8
B. 2, 5, 6
C. 1, 5, 6
D. 1, 3, 5, 6, 7
E. 1, 3, 5, 7

Answer: C

Show Answer

Question # 10

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and laterreleases? (Choose three.)

A. It is only possible for RMAN to connect to a pluggable database as a target if an RMANVirtual Private Catalog is used.
B. It is always possible for RMAN to connect to a pluggable database as a target if anyRMAN Catalog is used.
C. A Virtual Private Catalog used to register a container database must be created in apluggable database.
D. A Virtual Private Catalog used to register a container database can be created in apluggable database.
E. It is always possible for RMAN to connect to a pluggable database as a target.
F. A Virtual Private Catalog used to register a container database can be created in a non container database.

Answer: D,E,F

Show Answer

Question # 11

Which two are true about diagnosing Oracle Database failure situations using DataRecovery Advisor? (Choose two.)

A. Using the Data Recovery Advisor LIST FAILURE command always requires that thedatabase for which failures are to be listed is in MOUNT state.
B. A failure can be closed only when it has been repaired.
C. Data Recovery Advisor can be used if a database is closed.
D. The Data Recovery Advisor CHANGE FAILURE command can be used only to changefailure priorities.
E. Data Recovery Advisor can proactively check for failures.

Answer: D,E

Show Answer

Question # 12

Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

A. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned 
B. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
C. creating a new empty PDB in the local database from PDB$SEED  
D. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database 
E. automatically dropping the database link to the remote database if it already exists  
F. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
G. opening the cloned PDB  

Answer: B,E,F

Show Answer

Question # 13

Which three are true about RMAN persistent configuration settings, administration, andtheir effects? (Choose three.)

A. A target database’s persistent RMAN configuration settings are always stored in thetarget’s control file
B. Backup older than the recovery window retention policy are always deletedautomatically if the backup location has insufficient space.
C. Backups written to the fast recovery area (FRA) that are oboslete based on theredundancy retention policy can be deleted automatically to free space.
D. The RMAN SHOW ALL command displays only settings with nondefault values.
E. A target database’s persistent RMAN configuration settings are always synchronizedautomatically with the RMAN catalog.
F. The V$RMAN_CONFIGURATION view displays only settings with values that have beenmodified.
G. A DBA must specify either a redundancy retention policy or a recovery window retentionpolicy.

Answer: A,C,F

Show Answer

Question # 14

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

A. The Pre-Upgrade Information Tool script is executed by DBUA.  
B. DBUA must be launched from the target Oracle Home.  
C. All pluggable databases are automatically upgraded as part of a container database upgrade.  
D. A whole database backup must exist before upgrade
E. The database must be opened in read-only mode.
F. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

Answer: A,C,D

Show Answer

Question # 15

Which three are true about creating container databases (CDBs) and pluggable databases(PDBs) in Oracle 19c and later releases? (Choose three.)

A. A PDB snapshot can be a sparse copy of a source PDB.
B. A PDB snapshot depends on an existing storage snapshot of the source PDB.
C. A CDB can be duplicated using Recovery Manager (RMAN) with no configurationrequired before startingthe duplication.
D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silentmode with noconfiguration required before starting the duplication.
E. A PDB snapshot can be a full copy of a source PDB.
F. A snapshot copy PDB can be a full copy of a source PDB.
G. A snapshot copy PDB does not depend on an existing storage snapshot of the sourcePDB.

Answer: A,B,F

Show Answer

Question # 16

Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.) 

A. It can be launched from both the command line and the Universal Installer (OUI) interfaces. 
B. It can be used to change the character set of an existing database.
C. It can be used to convert a non-container database to a container database.
D. It can be used to create container databases and non-container databases.
E. It can only be launched from the command line interface.

Answer: B,E

Show Answer

Question # 17

Which three are true about a whole database backup? (Choose three.)

A. It can consist of either backup sets or image copies.
B. It is the only possible backup type for a database in NOARCHIVELOG mode.
C. It can be consistent.
D. It can be created only by using RMAN.
E. It can be inconsistent.
F. It always includes all data files, the current control file, the server parameter file, andarchived redo logs.

Answer: A,C,F

Show Answer

Question # 18

Which three are true about recovery operations done without using Recovery Manager(RMAN)? (Choose three.)

A. A lost SPFILE can be recovered from memory using SQL*PLUS.
B. A lost password file can be re-created with SQL*PLUS.
C. A lost TEMPFILE must always be re-created manually.
D. A lost password file can be manually re-created with the orapwd utility.
E. A lost PFILE can be re-created alert.log using SQL*PLUS.
F. A lost index tablespace can be re-created without performing any recovery.

Answer: B,D,E

Show Answer

Question # 19

How do you configure a CDB for local undo mode?

A. Open the CDB instance in upgrade mode. In cdb$root, execute alter database localundo on, and then restart the CDB instance.
B. Open the CDB in read-only mode. In cdb$root, execute alter database local undo on,and then change the CDB to read/write mode.
C. Open the CDB instance in restricted mode. In cdb$root, execute alter database localundo on. create an undo tablespace in each PDB, and then restart the CDB instance
D. Open the CDB instance in restricted mode. In cdb$root, drop the undo tablespace.Execute alter database local undo on in each PDB, and then restart the CDB instance.
E. Open the CDB instance in upgrade mode. In each PDB, execute alter database localundo on, create an undo tablespace, and then restart the CDB instance.

Answer: D

Show Answer

Question # 20

You want to transport the UNIVERSITY tablespace from one database to another.The UNIVERSITY tablespace is currently open read/write.The source and destination platforms have the same endian format.Examine this list of steps:1. Make the UNIVERSITY tablespace read-only on the source system.2. Export the UNIVERSITY tablespace metadata using EXPDP.3. Create a cross-platform backup set from the UNIVERSITY tablespace on the sourcesystem, using anRMAN command that includes the DATAPUMP clause.4. Copy the cross-platform backup sets to the destination system.5. Copy the Data Pump dump set from the source to the destination system.6. Restore the cross-platform backup set on the destination system using an RMANcommand that includesthe DATAPUMP clause.7. Import the UNIVERSITY tablespace metadata using IMPDP.8. Make the UNIVERSITY tablespace read/write on the destination system.Which are the minimum number of steps required, in the correct order, to transport theUNIVERSITYtablespace?

A. 1, 3, 4, 6, 8
B. 3, 4, 6
C. 1, 2, 3, 4, 5, 6, 7, 8
D. 2, 3, 4, 5, 6, 7

Answer: A

Show Answer