Free Oracle 1Z1-082 Practice Test & Real Exam Questions

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

Exam Questions: 165
Updated On: Oct 04, 2026

Question #40

Which three are types of segments in an Oracle Database? (Choose three.)

A. sequences

B. index

C. clusters

D. tables

E. undo

F. stored procedures

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question #41

Which two statements are true about single row functions? (Choose two.)

A. CEIL : can be used for positive and negative numbers

B. TRUNC : can be used with NUMBER and DATE values

C. FLOOR : returns the smallest integer greater than or equal to a specified number

D. MOD : returns the quotient of a division operation

E. CONCAT : can be used to combine any number of values

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #42

Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

A. WHERE city LIKE *%AN%*

B. ORDER BY 1, 2

C. WHERE city IN (?AN%')

D. ORDER BY 1, LNAME DESC

E. ORDER BY last_narae DESC, city ASC

F. WHERE city = =%AN%'

Discussion 0

Correct Answer: A,D Vote an answer

Question #43

Which two queries execute successfully?

A. SELECT COALESCE(100, NULL, 200) FROM DUAL;

B. SELECT NULLIF(100,100) FROM DUAL;

C. SELECT NULLIF(NULL, 100) FROM DUAL;

D. SELECT COALESCE (100, 'AM FROM DUAL;

E. SELECT 2TOLLIF(100, 'A') FROM DUAL;

Discussion 0

Correct Answer: A Vote an answer

Question #44

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

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

B. INTERSECT ignores NULLs

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

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

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

Discussion 0

Correct Answer: B,E Vote an answer

Question #45

Which two can you use to recover a dropped table? (Choose two.)

A. FLASHBACK QUERY

B. FLASHBACK DROP

C. FLASHBACK DATABASE

D. FLASHBACK TRANSACTION

E. FLASHBACK TABLE TO SCN

Discussion 0

Correct Answer: B,E Vote an answer

Question #46

Which two tasks can you perform using DBCA for databases? (Choose two.)

A. Change the standard block size of an existing database

B. Configure incremental backups for a new database

C. Register a new database with an available Enterprise Manager Management server

D. Configure a nonstandard block size for a new database

E. Enable flashback database for an existing database

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #47

Which three statements are true about Oracle synonyms? (Choose three.)

A. A SEQUENCE can have a synonym

B. A synonym created by one user can refer to an object belonging to another user

C. A synonym cannot be created for a PL/SQL package

D. A synonym can be available to all users

E. Any user can drop a PUBLIC synonym

Discussion 0

Correct Answer: A,B,D Vote an answer

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

Question #48

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

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

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

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

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

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

Discussion 0

Correct Answer: A,E Vote an answer

Question #49

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

A. input files

B. password files

C. bad files

D. control files

E. dump files

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #50

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

A. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;

B. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

C. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;

D. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

E. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

Discussion 0

Correct Answer: A,E Vote an answer

Question #51

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

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

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

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

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

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

Discussion 0

Correct Answer: A,C Vote an answer

Question #52

Which three statements are true regarding indexes? (Choose three.)

A. An update to a table can result in updates to any or all of the table's indexes

B. A SELECT statement can access one or more indices without accessing any tables

C. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

D. An update to a table can result in no updates to any of the table's indexes

E. A UNIQUE index can be altered to be non-unique

F. A table belonging to one user can have an index that belongs to a different user

Discussion 0

Correct Answer: A,C,E Vote an answer

Download Free Oracle 1Z1-082 Demo

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