2.8. Review Questions

  1. What are the three types of DML (Data Manipulation Language) statements?

  2. If the user SCOTT is granted the privilege to insert records on the OE.WAREHOUSES table using the command GRANT INSERT ON OE.WAREHOUSES WITH GRANT OPTION, what does the WITH GRANT OPTION clause allow SCOTT to do?

  3. Under which tiers of a three-tier Oracle environment does iSQL*Plus run?

  4. What two methods are used to rename a column in the report output of a SQL SELECT statement?

  5. ODBC provides what capability to client applications?

  6. Which SELECT statement keyword removes duplicate rows from the result of the query?

  7. What is the name of the set of library routines that allows a developer to send SQL statements from a C program?

  8. What are some of the differences ...

Get Oracle Database Foundations now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial