Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

You cannot delete the last column in a table.​

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

The ____________________ datatype is used to store fixed length data.

Accepted Answer

The answer of The ____________________ datatype is used to store...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of The ____________________ keyword must be used with...

Question 7

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

Accepted Answer

The answer of The column list of the CREATE TABLE...

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of When adding a column to an existing...

Question 15

A table name can contain a maximum of ____________________ characters.

Accepted Answer

The answer of A table name can contain a maximum...

Question 16

The abbreviation for the DESCRIBE command is DES._________________________​

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)   ​" "
B)   ​,
C)   ​( ) 
D)   ​| |

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)   ​ALTER TABLE...MARK UNUSED
B)   ​ALTER TABLE...SET UNUSED
C)   ​ALTER TABLE...DROP UNUSED
D)   ​ALTER TABLE...SET COLUMN

Question 20

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

Accepted Answer

The answer of The ____________________ TABLE command can be used...

Exam 3: Table Creation and Management

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A table name can contain a maximum of ____________________ characters.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____________________ datatype is used to store fixed length data.

Correct AnswerverifiedShow Answer

You cannot delete the last column in a table.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The abbreviation for the DESCRIBE command is DES._________________________​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Every table name within a specific schema must be unique.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

You cannot delete the last column in a table.

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

The abbreviation for the DESCRIBE command is DES._________________________

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified