Oracle Certification Exam Question: Download Oracle Certification PDF

Explain Which three statements/commands would cause a transaction to end? (Choose three.)
A. COMMIT
B. SELECT
C. CREATE
D. ROLLBACK
E. SAVEPOINT

Answers:

Answer #1A. COMMIT
C. CREATE
D. ROLLBACK

Answer #2Commit

Download Oracle Certification PDF Read All 25 Oracle Certification Questions

Previous Question

Next Question

Explain What are the benefits of system-managed locally managed tablespace?

Explain Which statements are correct regarding indexes? (Choose all that apply.)
A. When a table is dropped, the corresponding indexes are automatically dropped
B. A FOREIGN KEY constraint on a column in a table automatically creates a nonunique key
C. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a
unique index
D. For each data manipulation language operation performed, the corresponding indexes are
automatically updated