Quiz 1z0-007

Quiz 1z0-007, Introduction to Oracle9i: SQL

Which two statements are true regarding the default behavior of the ORDER BY clause?

What happens when you run the statement a second time?

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

Which UPDATE statement is valid?

Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin placed his orders?

Which UPDATE statement meets the requirements?

Which UPDATE statement is valid?

Which SQL statement, when used to create the EMP_VU view, allows the users to insert rows?