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 41

Multiple Choice

Review LaterAdd Note

Review Later

​Which of the following keywords uses a subquery to create a new table using existing database tables?

A) ​ALTER TABLE
B) ​GENERATE TABLE
C) ​CREATE TABLE...AS
D) ​CREATE TABLE...FROM

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

The USER_TAB_COLS data dictionary object contains a column to identify hidden columns.​

The column list of the CREATE TABLE command must be enclosed in ____________________.

You cannot delete the last column in a table.​

When defining columns for a table,which of the following symbols is used to separate the column names in the column list?​

The maximum width of a(n)CHAR column is 4000 characters._________________________

A table name must begin with a(n)number._________________________​

The ____________________ TABLE command can be used to delete a table from a database.

The ALTER TABLE name can be used to rename a table.​

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

Every table name within a specific schema must be unique.​

The abbreviation for the DESCRIBE command is DES._________________________​

The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table._________________________​

When adding a column to an existing table,the ____________________ clause must be used with the ALTER TABLE command.​

A datatype identifies the type of data to be stored in a column.​

Which of the following keywords is used to mark a column for deletion at a later time?​

A table name can contain a maximum of ____________________ characters.

The ____________________ datatype is used to store fixed length data.

The DROP COLUMN clause of the ALTER TABLE command can only be used to delete one column at a time._________________________​