10.6. Review Questions

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

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

  3. What clause do you add 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?

  5. Name two ways in which external tables are different from relational tables.

  6. True or false: Oracle resolves object references by checking for private synonyms first.

  7. What are two reasons for creating a view against one or more tables?

  8. What database object type can be used to generate a series of sequential numbers?

  9. True or false: Data dictionary tables retain their contents even after the database ...

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