Oracle 1Z0-082 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-082
Exam Name/Title: Oracle Database Administration I
Certification Provider: Oracle
Corresponding Certification: Oracle Database 19c

Exam Questions: 165
Updated On: Jul 10, 2026

Question #1

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

A. Employee 200 will have SALARY set to the same value as the SALARY of employee 100

B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

C. Employees 100 and 200 will have the same SALARY as before the update command

D. Employee 100 will have SALARY set to the same value as the SALARY of employee 200

E. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

F. Employees 100 and 200 will have the same JOB_ID as before the update command

Discussion 0

Correct Answer: B,D Vote an answer

Question #2

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

A. V$SESSION_EVENT

B. V$SESSION_WAIT

C. V$SESSION

D. V$SESSION_WAIT_CLASS

E. V$SYSTEM_EVENT

Discussion 0

Correct Answer: A,B Vote an answer

Question #3

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

A. Column names in each SELECT in the compound query can be different

B. The number of columns in each SELECT in the compound query can be different

C. INTERSECT returns rows common to both sides of the compound query

D. INTERSECT ignores NULLs

E. Reversing the order of the intersected tables can sometimes affect the output

Discussion 0

Correct Answer: A,D Vote an answer

Question #4

Which is true about roles?

A. Roles can be created only by SYS or SYSTEM.

B. A role can be granted to other roles.

C. Roles containing object privileges can be created only by the object owner.

D. A role can be password-protected only if it has been granted system privileges.

E. All roles belong to the SYSTEM schema.

Discussion 0

Correct Answer: D Vote an answer

Question #5

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING
`dallas_db';
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

A. as SYS in both the databases

B. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

C. as SCOTT in BOSTON_DB

D. as SCOTT in both the databases

E. as SCOTT in DALLAS_DB

Discussion 0

Correct Answer: A Vote an answer

Question #6

Which two statements are true about interval data types?

A. INTERVAL year TO month columns support yearly intervals.

B. The year field in an interval year to month column must be a positive value.

C. INTERVAL day to second columns support fractions of seconds.

D. INTERVAL year to month columns only support monthly intervals within a range of years.

E. The value in an interval day to SECOND column can be copied into an interval year to month column.

F. INTERVAL year to month columns only support monthly Intervals within a single year.

Discussion 0

Correct Answer: A,C Vote an answer

Question #7

Which two statements are true about substitution variables?

A. A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

B. A substitution variable can be used with any clause in a select statement.

C. A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

D. A substitution variable prefixed with & always prompts only once for a value in a session.

E. A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

F. A substitution variable can be used only in a select statement.

Discussion 0

Correct Answer: E Vote an answer

Question #8

Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

A. No users can log on until instance recovery has completed.

B. It is guaranteed to complete within fast_start_mttr_target number of seconds.

C. The database opens after the roll forward phase of instance recovery has completed.

D. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.

E. Only the CURRENT REDO log group is required to perform instance recovery.

F. It is always performed when opening a database.

Discussion 0

Correct Answer: D,F Vote an answer

Question #9

Which three statements are true about roles?

A. Object privileges may not be granted to roles.

B. Roles must be password protected.

C. All roles granted to a user are set on by default when the user logs in,

D. The SET ROLE statement can enable one or more roles for a session.

E. Roles may be granted to roles.

F. The SET ROLE statement can disable one or more roles for a session.

Discussion 0

Correct Answer: A,E,F Vote an answer

Question #10

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A. The Oracle join syntax supports creation of a Cartesian product of two tables

B. The Oracle join syntax only supports right outer joins

C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

D. The Oracle join syntax supports natural joins

E. The SQL:1999 compliant ANSI join syntax supports natural joins

F. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

G. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

Discussion 0

Correct Answer: D,E,G Vote an answer

Download Free Oracle 1Z0-082 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-082 exam.