Free Oracle 1Z0-082 Exam Questions

Become Oracle Certified with updated 1Z0-082 exam questions and correct answers

Page: 1 / 29

Total 144 Questions | Updated On: May 11, 2026

Add To Cart

Question 1

Which two actions can you perform using DBCA for an existing database?

A : Create a template that can be used to clone the database.

B : Change the server mode from dedicated to shared, and vice versa.

C : Change the character set.

D : Create an additional listener.

E : Create nonstandard block size tablespaces.

Answer: B,C

Question 2

Examine the description of the BOOKS table:

Other-Image-23cf679d4-e595-43a2-9926-33e15cdf075b

The table has 100 rows.

Examine this sequence of statements issued in a new session:

INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL);

SAVEPOINT a;

DELETE FROM books;

ROLLBACK TO SAVEPOINT a;

ROLLBACK;

Which two statements are true? (Choose two.)

A : The second ROLLBACK command does nothing

B : The second ROLLBACK command replays the delete

C : The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

D : The second ROLLBACK command undoes the insert

E : The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Answer: C,D

Question 3

Evaluate these commands which execute successfully:

Other-Image-28cf0cb7b-b11d-4b80-bafa-57b0fe4fad71

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

A : If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

B : Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

C : Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

D : Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

E : Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Answer: B,C

Question 4

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.

You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.

Examine this SQL statement:

Other-Image-40a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

Exhibit 1.

Other-Image-60a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

Exhibit 2.

Other-Image-80a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

What will be the result?

A : It gives an error because the ALL keyword is not valid

B : It gives an error because the GROUP BY clause is not valid

C : It executes successfully but does not give the required result

D : It executes successfully and gives the required result

Answer: D

Question 5

View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Other-Image-3de95013a-a7fc-4279-9a4b-7740f766c151

Which three statements are true?

A : The statement will fall if a row already exists in the sales table for product 23.

B : The sales table has five foreign keys.

C : A product can have a different unit price at different times.

D : A customer can exist in many countries.

E : The statement will execute successfully and a new row will be inserted into the sales table.

F : The statement will fail because a subquery may not be contained in a values clause.

Answer: A,B,C

Page: 1 / 29

Total 144 Questions | Updated On: May 11, 2026

Add To Cart