MANAGING DATABASES WITH ORACLE QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

Using the Oracle-supplied database creation procedures.

Using the SQL CREATE DATABASE command.

Using the Oracle Database Configuration Assistant.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

The default extension for an Oracle SQL*Plus file is:

.ora

.pls

.txt

.sql

TRUE ANSWER : ?
YOUR ANSWER : ?

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

DURING

INSTEAD OF

AFTER

BEFORE

TRUE ANSWER : ?
YOUR ANSWER : ?

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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

DESCRIBE [TableName].

DESCRIBE STRUCTURE [TableName].

STRUCTURE [TableName].

DESC TABLE [TableName].

TRUE ANSWER : ?
YOUR ANSWER : ?

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

You can add a column at any time as long as it is a NULL column.

You cannot increase or decrease the number of decimal places.

You can increase the number of characters in character columns or the number of digits in numeric columns

You can drop a column at any time.

TRUE ANSWER : ?
YOUR ANSWER : ?