Free Access Oracle.1Z1-082.v2026-07-18.q117 Practice Test (Page 15)

Question 66

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

A.Display suppliers whose PROD_LIST_PRICE is less than 1000

B.Display the total number of products supplied by supplier 102 which have a product status of obsolete

C.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

D.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

E.Display the minimum PROD_LIST_PRICE for each product status

Question 67

Examine the description of the BOOKS table:

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 first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

B.The second ROLLBACK command replays the delete

C.The second ROLLBACK command undoes the insert

D.The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

E.The second ROLLBACK command does nothing

Question 68

Examine the description of the BOOKS table:

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 undoes the insert

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

C.The second ROLLBACK command does nothing

D.The second ROLLBACK command replays the delete

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

Question 69

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

A.undo

B.index

C.stored procedures

D.sequences

E.tables

F.clusters

Question 70

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

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

B.A synonym can be available to all users

C.A SEQUENCE can have a synonym

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

E.Any user can drop a PUBLIC synonym

Other Version: 1484Oracle.1Z1-082.v2023-04-08.q100

Latest Upload: 206Cisco.300-610.v2026-08-19.q170; 204CompTIA.PT0-003.v2026-08-19.q179; 153Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 148SAP.C_CR125_2601.v2026-08-17.q28; 210Salesforce.Field-Service-Consultant.v2026-08-17.q134; 167Oracle.1Z0-1170.v2026-08-16.q64; 176Oracle.1Z1-1170.v2026-08-16.q64; 200Juniper.JN0-336.v2026-08-13.q60; 377EMC.NCP-AII.v2026-08-13.q200; 222CIRO.RSE.v2026-08-12.q41

Question 66

Question 67

Question 68

Question 69

Question 70

Download PDF File