1z0-082 Practice Test

Examine the description of the BOOKS table:

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

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

A.

Private Temporary Tables (PTTS) store metadata in memory only

B.

An index created with the UNUSABLE attribute has no segment

C.

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

D.

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

E.

A table that is truncated will always have its segment removed

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A.

A TRUNCATE command issued in a session causes all rows in a GLOBAL
TEMPORARY TABLE for the issuing session to be deleted.

B.

GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

C.

GLOBAL TEMPORARY TABLE space allocation occurs at session start.

D.

Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

E.

A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.

F.

A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

A.

Column positions must be used in the ORDER BY clause

B.

Only column names from the first SELECT statement in the compound query are recognized

C.

The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

D.

Each SELECT statement in the compound query must have its own ORDER BY clause

E.

Each SELECT statement in the compound query can have its own ORDER BY clause

Which two statements are true about the rules of precedence for operators? (Choose two.)

A.

The concatenation operator | | is always evaluated before addition and subtraction in an expression

B.

NULLS influence the precedence of operators in an expression

C.

The + binary operator has the highest precedence in an expression in a SQL statement

D.

Arithmetic operators with equal precedence are evaluated from left to right within an expression

E.

Multiple parentheses can be used to override the default precedence of operators in an expression