Study tips 1Z0-051

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?

Which statement is true regarding the default behavior of the ORDER BY clause?

Which is the correct output of the above query?

What would be the outcome of the above statements?

Which two statements are true about constraints?