A.2. Chapter 2

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

    Answer: The three types of DML statements are INSERT, UPDATE, and DELETE.

  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?

    Answer: It allows SCOTT to grant another user, such as HR, the same INSERT privilege on the OE.WAREHOUSES table.

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

    Answer: iSQL*Plus runs on only the middleware tier where the Apache web server is running. However, Apache can run on the client with the user who is executing the SQL statements, on its own dedicated ...

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