Study tips 1Z0-047

Which two matches would be returned by this expression?

Which multitable INSERT statement would you use?

Which three statements indicate the end of a transaction?

Evaluate the following ALTER TABLE statement:ALTER TABLE ordersSET UNUSED order_date;Which statement is true?

Which two statements are true about the GROUPING function?

The following are the steps for a correlated subquery, listed in random order:

Which two statements are true regarding multiple-row subqueries?

Which statement is true regarding Flashback Version Query?

Which CREATE TABLE statement is valid?

Which statement is true regarding the ROLLUP operator specified in the GROUP BY clause of a SQL statement?