Limited-Time Offer: Enjoy 50% Savings! Ends in 00h 00m 00s Coupon code: 50OFF
Skip to content
Login Sign up

Free Oracle Database Administration II 1Z0-083 Exam Questions

Page: 1 / 20 Total 286 questions

Want more questions? Get Premium Access.

Question 1

Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?

(Choose two.)

Correct Answer: B. SQL statements doing only logical reads never require tuning because they do no physical I/O.; E. Poorly performing SQL statements can be tuned automatically by the Oracle server.

Question 2

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.

FORCE LOGGING is enabled for the database.

Which two could improve read performance? (Choose two.)

Correct Answer: D. Enable asynchronous disk I/O.; E. Increase the level of RMAN multiplexing.

Question 3

Which two are true about RMAN encryption? (Choose two.)

Correct Answer: C. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.; D. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

Question 4

You have configured RMAN SBT channels to write backups to media.

You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

Correct Answer: B. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.; D. The SPFILE is included in the self-contaied archival backup.; E. The control file is included in the self-contained archival backup.

Question 5

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

Correct Answer: B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.; C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.; F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Question 6

Which three are true In Oracle 19c and later releases?

Correct Answer: A. Tablespaces always remain In read/write mode during transportable tablespace operations.; D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.; E. A transportable data pump import can leave a plugged-in tablespace in read-only mode.

Question 7

Which three are true about block media recovery? (Choose three.)

Correct Answer: A. The data file containing the block being recovered remains online.; B. To use it, Flashback Database must be enabled.; E. The target database for which one or more blocks are to be recovered must be in the OPEN state.

Question 8

Which two are true about Oracle instance recovery? (Choose three.)

Correct Answer: B. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.; E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).; F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Question 9

Which two are true about Oracle Flashback features? (Choose two.)

Correct Answer: D. FLASHBACK DROP can undrop an index when undropping a table.; E. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Question 10

A database is configured in ARCHIVELOG mode.

Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.

In which two scenarios is complete recovery possible? (Choose two.)

Correct Answer: D. after losing an archived log from before the most recent backup; E. after losing the SYSTEM tablespace

Question 11

Which three are true in Oracle 19c and later releases? (Choose three.)

Correct Answer: B. Schema Only accounts can be granted administrator privileges.; C. All the Oracle-supplied accounts are Schema Only accounts.; D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.

Question 12

Which three are located by using environment variables? (Choose three.)

Correct Answer: A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.; B. the location of Oracle Net Services configuration files; E. the temporary disk space used by Oracle Installer during installation

Question 13

Which two are true about the automatic execution of operating system scripts when performing silent mode

installation starting from Oracle Database 19c? (Choose two.)

Correct Answer: D. The response file must contain the root or sudo password.; E. The response file can specify the path of the sudo program.
Explanation:

execution/

Question 14

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic

Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

Correct Answer: C. AWR reports can be generated while connected to any container.; E. AWR snapshots can be created in a PDB.; F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Question 15

Examine this configuration:

1. CDB1 and CDB2 are two container databases.

2. PDB1 is a pluggable database in CDB1.

3. PDB1_C1_SRV is a service for PDB1.

4. CDB1_LINK is a database link in CDB2 referring to PDB1.

5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.

You execute these commands successfully:

$ sqlplus sys/oracle_4U@cdb2 as sysdba

SQL> CREATE PLUGGABLE DATABASE PDB1

FROM PDB1@CDB1_LINK

SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');

Which two are true? (Choose two.)

Correct Answer: A. PDB1 will be created in CDB2 and automatically opened.; C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
Page: 1 / 20 Total 286 questions