Study tips 1Z0-051

Which is the valid CREATE [TABLE statement?

Which views can have all DML operations performed on it?

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?

What is true regarding sub queries?

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

What would be the outcome?

Which statement is true regarding the above two SQL statements?

Examine the structure and data of the CUSTJTRANS table: CUSTJRANS Name Null?

Which statement is true regarding the above query?

Which two statements are true regarding sub queries?