A.10. Chapter 10

  1. The data dictionary view IND has the same definition as what other data dictionary view?

    Answer: The data dictionary view IND is equivalent to the data dictionary view USER_INDEXES.

  2. The most common form of a table in the Oracle database is a(n) ___________ table.

    Answer: Relational

  3. What clause do you add to the CREATE TABLE statement to create a temporary table?

    Answer: You add the clause GLOBAL TEMPORARY to the CREATE TABLE statement to create a temporary table.

  4. What tables are displayed if a user accesses the ALL_TABLES data dictionary view?

    Answer: The ALL_TABLES data dictionary view contains a row for each table in the user's schema plus a row for each table that the user has access to in other schemas of the database.

  5. Name two ...

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