FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Table Creation and Management

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

The DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____________________ column(s) at a time.

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

Which of the following is a valid table name?

The INTERVAL datatype can be used to identify a specific interval, or amount, of time.

You cannot specify the width for a(n) $\underline { \text { NUMBER } }$ column. _________________________

Once a column has been set as UNUSED, which of the following is correct?

A column's ____________________ identifies the type of data that can be stored in a column.

The ____________________ clause of the ALTER TABLE command can be used to change the size of a column.

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table, add a column list containing ____ names in the CREATE TABLE clause.

The ____________________ of a NUMBER column indicates the total number of digits that can be stored in the column.

The $\underline { \text { DELETE TABLE } }$ command can be used to delete all the data stored in a table and release the storage space, yet retain the structure of the table. _________________________

A table must contain a minimum of $\underline { \text { two } }$ columns. _________________________

The default size of a VARCHAR2 column is one character.

The DELETE TABLE command can be used to remove a table from a database.

A column name can consist of up to 225 characters.

_________________________ commands are used to create database objects.

The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.

What is the maximum width that can be assigned to a DATE column?

A DATE column consists of ____________________ bytes.

The maximum width of the NUMBER datatype is ____ digits.