Free Oracle 1Z1-082 Exam Dumps Questions & Answers

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 first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
• C.The second ROLLBACK command undoes the insert
• D.The second ROLLBACK command does nothing
• E.The second ROLLBACK command replays the delete

Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

• A.the first number column in the first select of the compound query
• B.the first column in the last select of the compound query
• C.the first number or varchar2 column in the last select of the compound query
• D.the first varchab2 column in the first select of the compound query
• E.the first column in the first select of the compound query

Which three statements are true about sequences in a single instance Oracle database?

• A.A sequence can Issue duplicate values.
• B.A sequence can only be dropped by a DBA.
• C.A sequence number that was allocated can be rolled back if a transaction fails.
• D.Sequences can always have gaps.
• E.A sequence's unallocated cached values are lost if the instance shuts down.
• F.Two or more tables cannot have keys generated from the same sequence.

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

• A.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
• B.The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
• C.The names and number of columns must be identical for all SELECT statements in the query.
• D.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
• E.The number, but not names, of columns must be identical for all SELECT statements in the query.

An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table.
Which three situations does the transaction complete thereby committing the updates?

• A.when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
• B.when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session
• C.when a CREATE INDEX statement is executed successfully in the same session
• D.when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
• E.when the session logs out successfully
• F.when a COMMIT statement is issued by the same user from another session in the same database instance