Quiz 1Z0-051

Quiz 1Z0-051, Oracle Database 11g, SQL Fundamentals I

Which statement is true regarding transactions?

When does a transaction complete?

Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a commandin the session?

Which three statements/commands would cause a transaction to end?

Which two statements are true regarding the DELETE and TRUNCATE commands?

Which statement is true about the DELETE statement?

Which statements are true regarding the FOR UPDATE clause in a SELECT statement?

Which ORDER BY clauses are valid for the above query?

Which statement is true regarding the outcome of the above query?

Which statement is true regarding the UNION operator?