Study tips 1z0-007

Study tips 1z0-007, Introduction to Oracle9i SQL

Which three statements correctly describe the functions and use of constraints?

What is true of using group functions on columns that contain NULL values?

What will be displayed?

Why does the DELETE statement fail when you execute it?

Which statement do you execute to retrieve this information?

Which two statements about subqueries are true?

Which two are character manipulation functions?

Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?

What is its output?

Which expression finds the number of different countries represented in the CUSTOMERS table?