Quiz 1z0-007

Quiz 1z0-007, Introduction to Oracle9i: SQL

Which two statements regarding the EMP_ID_SEQ sequence are true?

Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?

A subquery can be used to ___.

Which is an iSQL*Plus command?

Which two statements are true about constraints?

Which statement produces the number of different departments that have employees with last name Smith?

What is the result when the above query is executed?

Which statement creates the foreign key?

Which two statements are valid?

which situation would you use a nonequijoin query?