Q.1

SQL*Plus will finish the statement and execute it when the user types in this:

  • A left slash ( \ ) followed by [Enter].
  • A colon ( : ) followed by [Enter].
  • A semicolon ( ; ) followed by [Enter].
  • A period ( . ) followed by [Enter].
Q.2

What Oracle backup and recover file contains user and system data?

  • Control file
  • Datafile
  • OnLine ReDo file
  • Offline ReDo file
Q.3

Which statement about sequences is not true?

  • A sequence is an object that generates a sequential series of unique numbers.
  • Sequences are most often used to provide values for surrogate keys.
  • NextVal and CurrVal are both sequence methods.
  • Sequences guarantee valid surrogate key values.
Q.4

An Oracle System Change Number (SCN):

  • is a value that is incremented whenever a dirty read occurs.
  • is incremented whenever a deadlock occurs.
  • is a value that keeps track of explicit locks.
  • is a value that is incremented whenever database changes are made.
Q.5

To obtain the structure of an Oracle table, the command to use is:

  • STRUCTURE [TableName].
  • DESCRIBE [TableName].
  • DESCRIBE STRUCTURE [TableName].
  • DESC TABLE [TableName].
Q.6

Which of the following is NOT an Oracle-supported trigger?

  • BEFORE
  • DURING
  • AFTER
  • INSTEAD OF
Q.7

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

  • are case insensitive.
  • are case sensitive.
  • must always be in lower case.
  • must always be in upper case.
Q.8

Which SQL phrase is not supported by Oracle?

  • ON DELETE CASCADE
  • ON UPDATE CASCADE
  • CREATE SEQUENCE [SequenceName]
  • DROP SEQUENCE [SequenceName]
Q.9

Which prefixes are available to Oracle triggers?

  • :new only
  • :old only
  • Both :new and :old
  • Neither :new nor :old
Q.10

To see the contents of the SQL*Plus buffer, type:

  • CONTENTS.
  • BUFFER.
  • CURRENT.
  • LIST.
Q.11

After a table has been created, its structure can be modified using the SQL command:

  • UPDATE TABLE [TableName].
  • MODIFY TABLE [TableName].
  • ALTER TABLE [TableName].
  • CHANGE TABLE [TableName].
Q.12

Which of the following is not true about modifying table columns?

  • You can drop a column at any time.
  • You can add a column at any time as long as it is a NULL column.
  • You can increase the number of characters in character columns or the number of digits in numeric columns
  • You cannot increase or decrease the number of decimal places.
Q.13

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

  • Full backup
  • Consistent backup
  • Inconsistent backup
  • Differential backup
Q.14

In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

  • The line numbers reported match the line numbers you see in your text editor.
  • SQL*Plus will automatically show the errors to you.
  • To see the errors, enter SHOW ERRORS in SQL*Plus.
  • If there are no syntax errors, you will receive the message "NO ERRORS."
Q.15

Which of the following is not true about indexes?

  • Indexes are created to enforce uniqueness on columns.
  • Indexes are created to enable fast retrieval by column values.
  • Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
  • Indexes are created with the ALTER TABLE command.
Q.16

The semicolon terminates a SQL statement (and executes it).

  • True
  • False
Q.17

Oracle commands, column names, table names, view names and all other database elements are case sensitive.

  • True
  • False
Q.18

When you type into SQL*Plus and press enter, the statement will be finished and executed.

  • True
  • False
Q.19

SQL*Plus is a text editor.

  • True
  • False
Q.20

If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.

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