Online Access Free Oracle.1Z0-082.v2022-02-08.q102 Practice Test (Page 12)

1Z0-082 Exam Question 51

In which three situations does a new transaction always start? (Choose three.)

A.when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

B.when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

C.when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

D.when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

E.when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

F.when issuing a DML statement after a DML statement failed in the same session

1Z0-082 Exam Question 52

Which two statements are true about the SET VERIFY ON command? (Choose two.)

A.It displays values for variables prefixed with &&

B.It displays values for variables created by the DEFINE command

C.It can be used only in SQL*Plus

D.It can be used in SQL Developer and SQL*Plus

E.It displays values for variables used only in the WHERE clause of a query

1Z0-082 Exam Question 53

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 and commits the inserted row

B.The second ROLLBACK command undoes the insert

C.The second ROLLBACK command replays the delete

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

E.The second ROLLBACK command does nothing

1Z0-082 Exam Question 54

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

A.The sales user must have been granted the CREATE SESSION privilege

B.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

C.The sales user must have been granted the CREATE TABLE privilege

D.The sales user must have their quota on the users tablespace removed

E.The sales user must have a quota on the TEMP tablespace

F.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

1Z0-082 Exam Question 55

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: