Question 1

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 2

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

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 abbreviation for the DESCRIBE command is DES._________________________​

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

A table name can contain a maximum of ____________________ characters.

Accepted Answer

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

Question 9

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 10

​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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

You cannot delete the last column in a table.​

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

The ____________________ datatype is used to store fixed length data.

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 3: Table Creation and Management

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

Correct AnswerverifiedShow Answer

The abbreviation for the DESCRIBE command is DES._________________________​

Correct AnswerverifiedShow Answer

A table name can contain a maximum of ____________________ characters.

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____________________ datatype is used to store fixed length data.

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You cannot delete the last column in a table.​

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 table name must begin with a(n)number._________________________​

Correct AnswerverifiedShow Answer

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

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 ____________________ TABLE command can be used to delete a table from a database.

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Every table name within a specific schema must be unique.

Correct Answer
verified

The abbreviation for the DESCRIBE command is DES._________________________

Correct Answer
verified

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

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

Correct Answer
verified

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

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

Correct Answer
verified

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

Correct Answer
verified

You cannot delete the last column in a table.

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 table name must begin with a(n)number._________________________

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

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

Correct Answer
verified

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

Correct Answer
verified