Study tips 1Z0-051

Which two SQL statements would execute successfully?

What is the outcome?

Which is a valid CREATE TABLE statement?

Which two statements are true regarding the above view?

Which DELETE statements are valid?

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

Which is the valid DDL statement for creating the ORD_DETAIL table?

Which three statements are true regarding sub queries?

Which SQL statements are valid?

Which SQL statement displays the date March 19, 2001 in a format that appears as Nineteenth of March 2001 12:00:00 AM?