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

Question #1

Which three are true about the SQL Tuning Advisor? (Choose three.)

A. It checks each query being analyzed for missing statistics.

B. It considers all SQL statements being analyzed by the advisor task as a group.

C. It can recommend semantic changes to SQL statements.

D. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

E. It only recommends syntactic changes to SQL statements.

F. It checks each query being analyzed for stale statistics.

Discussion 0

Correct Answer: A,C,F Vote an answer

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

Question #2

Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)

A. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

B. creating a database service using Oracle Database Configuration Assistant (DBCA)

C. creating an Oracle Database service by modifying the SERVICE_NAMES parameter

D. creating a database service using DBMS_SERVICE.CREATE_SERVICE

E. creating a disk group using the CREATE DISKGROUP SQL statement

F. creating a database using the CREATE DATABASE SQL statement

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 #3

Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)

A. It can only install and configure Oracle Database software. The database has to be created separately.

B. It does not require the setup wizard.

C. It uses a single RPM that automatically extracts and installs the Oracle Database software.

D. It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

E. It can be used for both Oracle Database and Oracle Grid Infrastructure installation.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #4

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

A. Metrics are statistical counts for a specific unit.

B. All metrics are instance related.

C. STATISTICS_LEVEL must be set to ALL to generate alerts.

D. They are generated by SMON when a tablespace is 97% full.

E. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

F. A space usage management alert is automatically cleared after the underlying problem is resolved.

Discussion 0

Correct Answer: A,E,F Vote an answer

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

Question #5

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

A. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

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

C. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

D. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

E. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

F. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

G. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

H. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

Discussion 0

Correct Answer: A,E,G,H Vote an answer

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

Question #6

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

A. A failure can be closed only when it has been repaired.

B. Data Recovery Advisor can proactively check for failures.

C. Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

D. The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

E. Data Recovery Advisor can be used if a database is closed.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #7

Which statement describes the significance of the CHANGE FAILURE command in RMAN?
(Choose all that apply.)

A. It is used to inform the database about the repair after the repair script executes.

B. It is used to execute the advised repair script.

C. It is used to change failure priority only for HIGH or LOW priorities.

D. It is used to change failure priority only for the CRITICAL priority.

E. It is used to explicitly close the open failures.

Discussion 0

Correct Answer: C,E Vote an answer

Question #8

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace?
(Choose two.)

A. Backups must be done incrementally.

B. Backups must be contained in backup sets.

C. Backups can be done incrementally.

D. Only consistent backups can be created.

E. The database must be registered in an RMAN catalog.

F. Backups can be taken only if the database is in ARCHIVELOG mode.

Discussion 0

Correct Answer: C,F Vote an answer

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

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

Download Free Oracle 1Z1-083 Demo