Study tips 1z0-007

Study tips 1z0-007, Introduction to Oracle9i SQL

Which DELETE statement is valid?

Which are iSQL*Plus commands?

Which statement shows the department ID, minimum salary, and maximum salary paid in that department…?

Which statement is true?

Which statement is valid?

Which statement do you execute to retrieve this information?

which three cases would you use the USING clause?

which two actions can you use the TO_DATE function?

Which option enables Scott to eliminate the need to qualify the view with the name MARY.EMP_DEPT_LOC_VU each time the view is referenced?

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?