MANAGING DATABASES WITH ORACLE QUIZ

You cannot increase or decrease the number of decimal places.

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

You can drop a column at any time.

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

False

True

Indexes are created with the ALTER TABLE command.

Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.

Indexes are created to enforce uniqueness on columns.

Indexes are created to enable fast retrieval by column values.

Consistent backup

Full backup

Differential backup

Inconsistent backup

ALTER TABLE [TableName].

UPDATE TABLE [TableName].

MODIFY TABLE [TableName].

CHANGE TABLE [TableName].

False

True

are case sensitive.

must always be in upper case.

must always be in lower case.

are case insensitive.

A semicolon ( ; ) followed by [Enter].

A period ( . ) followed by [Enter].

A colon ( : ) followed by [Enter].

A left slash ( ) followed by [Enter].

True

False

False

True