Category: Oracle Database

1Z0-082 dumps have been updated to prepare you for successfully passing the Database Administration I Certification exam.
Obtaining Database Administration I Certification is not difficult, use Lead4Pass’s 1Z0-082 dumps, which contain real questions and moderated answers, to guarantee your first battle.
Lead4Pass 1Z0-082 Dumps last month data has been updated, 99.5% high score. You can visit https://www.leads4pass.com/1z0-082.html, check more information, really help you pass
Best platform for Oracle Database Administration I exam.

Read 1Z0-082 Free Dumps Online

QUESTION 1

Which two statements are true regarding a SAVEPOINT? (Choose two.)

A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
C. Only one SAVEPOINT may be issued in a transaction
D. A SAVEPOINT does not issue a COMMIT
E. Rolling back to a SAVEPOINT can undo a DELETE statement

Correct Answer: DE

QUESTION 2

In which three situations do 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

Correct Answer: ADE

A transaction begins when the first executable SQL statement is encountered. An executable SQL statement is a SQL
statement that generates calls to a database instance, including DML and DDL statements and the SET
TRANSACTION statement. A transaction ends when any of the following actions occurs: A user issues a COMMIT or
ROLLBACK statement without a SAVEPOINT clause. Answer D A user runs a DDL command such asCREATE,