Quiz 1z0-007

Quiz 1z0-007, Introduction to Oracle9i: SQL

Which two statements are true about WHERE and HAVING clauses?

Which two aggregate functions are valid on the START_DATE column?

What does the FORCE option for creating a view do?

Which WHERE clause identifies customers that are located in France?

Which three subqueries work?

Which view should a user query to display the columns associated with the constraints on a table owned by the user?

Which query would you use?

Which query would you use?

Which SQL statement would you use to create the view EMP_VU?

Which two statements complete a transaction?