Free 1Z0-083 Questions for Oracle 1Z0-083 Exam

Question #1

Which are the three steps in the SQL tuning process for Oracle Database environments?

A. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

B. Identify poorly tuned SQL statements using the SQL Tuning Advisor.

C. Test the application as a whole using tuned SQL statements.

D. Tune individual SQL statements using the SQL Tuning Advisor.

E. Test tuned SQL statements one at a time for all statements in the application.

F. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #2

A schema owner truncated a table in error and must recover the data.
Which Oracle Flashback feature could be used to recover the data?

A. FLASHBACK TRANSACTION

B. FLASHBACK TABLE

C. FLASHBACK DATA ARCHIVE

D. FLASHBACK DATABASE

E. FLASHBACK VERSION QUERY

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #3

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

A. By default, AWR snapshots are taken every 60 minutes.

B. The taking of AWR snapshots can be disabled.

C. By default, AWR snapshots are retained for 7 days.

D. AWR data is stored in the SYSTEM tablespace.

E. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

Discussion 0

Correct Answer: A,B,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #4

Which two are true about an RPM-based Oracle Database installation? (Choose two.)

A. It includes the Oracle Preinstallation RPM.

B. It uses a service configuration script to create a single-instance database as part of the installation.

C. It requires an Unbreakable Linux Network (ULN) subscription.

D. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

E. It performs a software-only Oracle Database installation.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #5

A container database called CDB1is OMF-enabled.
PDB_FILE_NAME_CONVERTis not configured in CDB1.
PDB1was unplugged from CDB1earlier in the week.
Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

A. PDB1 data files already exist in the correct location.

B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

C. PDB_FILE_NAME_CONVERT must be set before executing the command.

D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

E. PDB1 must be dropped from CDB1.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1was created.
You want to recover PDB1 to Restore Point R1.
How do you achieve this?

A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

C. This cannot be done due to the lack of a clean restore point.

D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

E. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #7

Which three true about recovering tables using RMAN? (Choose three.)

A. RMAN can recover a table after a DDL operation has altered the table structure.

B. RMAN can recover tables in the SYSTEM tablespace.

C. RMAN can recover tables owed by the SYSTEM user.

D. RMAN can recover tables owned by the SYS user.

E. RMAN always uses an auxiliary instance.

F. RMAN can recover tables in the SYSAUX tablespace.

G. RMAN can recover tables in a standby database.

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #8

Which two are true about memory advisors? (Choose two.)

A. If Automatic Memory Management is enabled, no memory advisors are available.

B. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

C. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

D. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

E. All memory advisors use data from Automatic Workload Repository.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #9

Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

A. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

B. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

C. The control file is backed up automatically each time the SPFILE is backed up manually.

D. The control file is backed up whenever a new table is created.

E. It requires the use of fast recovery area (FRA).

F. The control file is backed up whenever a new tablespace is created.

Discussion 0

Correct Answer: B,C,F Vote an answer

Question #10

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

A. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

B. A transportable data pump import can leave a plugged-in tablespace in read-only mode.

C. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

D. Tablespaces never remain in read/write mode during transportable tablespace operations.

E. Tablespaces always remain in read/write mode during transportable tablespace operations.

F. A transportable data pump import can leave a plugged-in tablespace in read/write mode.

Discussion 0

Correct Answer: B,C,F Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free 1Z0-083 Questions for Oracle Database Administration II 1Z0-083 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z0-083 Demo