Get Oracle 1Z0-082 Exam Practice Questions - Real and Updated

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.)

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

Examine this command:

Which two statements are true? (Choose two.)

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Which three statements are true about a self join? (Choose three.)