Study tips 1Z0-051

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?

Which two statements regarding the EMP_ID_SEQ sequence are true?

Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session?

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

Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

Which SQL statement can Mary use to accomplish that task?

Which query would accomplish this task?