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

A DATE column consists of ____________________ bytes.

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

The default size of a VARCHAR2 column is one character.

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

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

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

Which of the following is a valid table name?

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. _________________________

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

_________________________ commands are used to create database objects.

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

A column name can consist of up to 225 characters.

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

The ____________________ of a NUMBER column indicates the total number of digits that can be stored in the 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 DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____________________ column(s) at a time.

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

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

The maximum width of the NUMBER datatype is ____ digits.

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