Quiz 1Z0-051

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

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”?

Which three tasks can be performed using SQL functions built into Oracle Database?

which action can you use the TO_DATE function?