Q.1

Oracle allows the ORDER BY clause in view definitions.

  • True
  • False
Q.2

Oracle does NOT support a CASCADE UPDATE constraint.

  • True
  • False
Q.3

Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.

  • True
  • False
Q.4

When you type Start FILENAME, the statement in your file will be executed automatically.

  • True
  • False
Q.5

The only time that case matters is inside quotation marks of strings.

  • True
  • False
Q.6

Sequences guarantee valid surrogate key values.

  • True
  • False
Q.7

Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.

  • True
  • False
Q.8

Money is defined in Oracle with the Currency data type.

  • True
  • False
Q.9

The default extension for SQL*Plus is .sql.

  • True
  • False
Q.10

You can check on the status of tables with the DESCRIBE or DESC command.

  • True
  • False
Q.11

Oracle directly supports the definition of surrogate keys.

  • True
  • False
Q.12

You can use the DROP statement to remove structures from the database.

  • True
  • False
Q.13

The left-leaning slash tells Oracle to execute whatever statement is in the buffer.

  • True
  • False
Q.14

Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.

  • True
  • False
Q.15

Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.

  • True
  • False
0 h : 0 m : 1 s