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

Which two are true about the roles? (Choose two.)

A. The SET ROLE statement enables as well as disables roles in a session.

B. All privileges and roles granted to a user are enabled by default when the user logs in.

C. The SET ROLE statement can be used once per session.

D. A role must be disabled before it can be revoked from a user.

E. The ALTER USER statement must be used to set specific default roles for a user.

Discussion 0

Correct Answer: A,B Vote an answer

Question #12

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

A. in the SGA

B. in the temporary tablespace

C. in the SYSAUX tablespace

D. in the undo tablespace

E. in the PGA

Discussion 0

Correct Answer: D Vote an answer

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

Question #13

Which two statements are true about the Oracle Data Dictionary?

A. Data dictionary base tables can be queried directly.

B. It is owned by the sys user.

C. All data dictionary view joins base tables to dynamic performance views.

D. It is owned by the system user.

E. Data dictionary views are always created with queries that join two or more base tables.

Discussion 0

Correct Answer: A,B Vote an answer

Question #14

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

A. NULLS are not ignored during duplicate checking

B. The names of columns selected in each SELECT statement must be identical

C. Duplicates are eliminated automatically by the UNION ALL operator

D. The output is sorted by the UNION ALL operator

E. The number of columns selected in each SELECT statement must be identical

Discussion 0

Correct Answer: A,E Vote an answer

Question #15

Which three statements are true about using SQL*Plus?

A. It can run scripts entered at the SQL prompt.

B. It can run scripts passed to it by a shell script.

C. It has its own commands that are separate from any SQL statements.

D. It has both command-line and graphical user interfaces (GUI).

E. It must be downloaded from the Oracle Technology Network (OTN).

F. It can run Recovery Manager (RMAN) commands.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #16

Which two statements are true about the rules of precedence for operators? (Choose two.)

A. The concatenation operator | | is always evaluated before addition and subtraction in an expression

B. Arithmetic operators with equal precedence are evaluated from left to right within an expression

C. The + binary operator has the highest precedence in an expression in a SQL statement

D. NULLS influence the precedence of operators in an expression

E. Multiple parentheses can be used to override the default precedence of operators in an expression

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #17

Which three statements are true about views in an Oracle database? (Choose three.)

A. Data Manipulation Language (DML) can always be used on views

B. The WITH CHECK clause prevents certain rows from being updated or inserted

C. Tables in the defining query of a view must always exist in order to create the view

D. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

E. The WITH CHECK clause prevents certain rows from being displayed when querying the view

F. Views can be updated without the need to re-grant privileges on the view

G. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #18

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

A. Private Temporary Tables (PTTS) store metadata in memory only

B. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

C. An index that is altered to be UNUSABLE will retain its segment

D. A table that is truncated will always have its segment removed

E. An index created with the UNUSABLE attribute has no segment

Discussion 0

Correct Answer: B,E Vote an answer

Question #19

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;

B. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

C. SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;

D. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

E. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
"DUES AMOUNT" FROM transactions;

Discussion 0

Correct Answer: B,D Vote an answer

Question #20

Which two statements are true about the PMON background process? (Choose two.)

A. It frees resources held by abnormally terminated processes

B. It records checkpoint information in the control file

C. It kills sessions that exceed idle time

D. It frees unused temporary segments

E. It registers database services with all local and remote listeners known to the database instance

Discussion 0

Correct Answer: A,E Vote an answer

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

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.