Question 1

If the CREATE TABLE is being used to create a table from existing data, the SUBQUERY keyword must be used.

Accepted Answer

A) True 
 B)False

Question 2

When a column is deleted, the deletion is permanent.

Accepted Answer

A) True 
 B)False

Question 3

The maximum width of a(n) $\underline { \mathrm{CHAR}   }$ column is 4000 characters. _________________________

Accepted Answer

A) True 
 B)False

Question 4

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...FROME) All of the above
F) A) and B)

Question 5

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 6

Structure of the PROMOTION table
 
-If a new column is added to the PROMOTION table, where will the new column be listed?

Accepted Answer

A)   before the GIFT column
B)   after the GIFT column
C)   after the MINRETAIL column
D)   after the MAXRETAIL columnE) A) and C)
F) A) and B)

Question 7

Which keywords are used to complete the deletion of a column previously marked with SET UNUSED?

Accepted Answer

A)   DELETE UNUSED COLUMNS
B)   DROP UNUSED COLUMNS
C)   UNSET UNUSED COLUMNS
D)   DROP SET COLUMNSE) B) and D)
F) A) and C)

Question 8

The $\underline {  \text { MODIFY }  }$ clause can be included in the ALTER TABLE command to add a default value to an existing column. _________________________

Accepted Answer

A) True 
 B)False

Question 9

The $\underline {  \text { CHANGE }  }$ TABLE command can be used to modify an existing table. _________________________

Accepted Answer

A) True 
 B)False

Question 10

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 COLUMNE) A) and D)
F) A) and B)

Question 11

The RENAME command can be used to assign a table to a new schema.

Accepted Answer

A) True 
 B)False

Question 12

More than one column can be changed at a time with the $\underline {   \text { ALTER TABLE ...MODIFY } }$ command. _________________________

Accepted Answer

A) True 
 B)False

Question 13

The DROP TABLE command can be used to remove a table and all its data from a database.

Accepted Answer

A) True 
 B)False

Question 14

DML commands are used to create or modify database tables.

Accepted Answer

A) True 
 B)False

Question 15

The $\underline {  \text { 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 16

You cannot delete the last column in a table.

Accepted Answer

A) True 
 B)False

Question 17

Structure of the PROMOTION table
 
-If the MAXRETAIL column of the PROMOTION table has been set as unused, which of the following commands is valid?

Accepted Answer

A)   ALTER TABLE promotion RESET maxretail USED;
B)   ALTER TABLE promotion DROP COLUMN maxretail;
C)   ALTER TABLE promotion DROP UNUSED COLUMNS;
D)   both b and cE) C) and D)
F) All of the above

Question 18

Which of the following keywords cannot be used to modify an existing table?

Accepted Answer

A)   ALTER TABLE...ADD
B)   ALTER TABLE...DROP COLUMN
C)   ALTER TABLE...MODIFY
D)   ALTER TABLE...ASE) None of the above
F) B) and C)

Question 19

A table name can contain the number sign and ____________________ symbols.

Accepted Answer

The answer of A table name can contain the number...

Question 20

Structure of the PROMOTION table
 
-Which of the following SQL statements was most likely used to create the PROMOTION table?

Accepted Answer

A)   CREATE TABLE promotion(gift VARCHAR2(15) , minretail NUMBER(5, 2) , maxretail NUMBER(5, 2) ) ;
B)   CREATE TABLE promotionAS (gift VARCHAR2(15) , minretail NUMBER(5, 2) , maxretail NUMBER(5, 2) ) ;
C)   CREATE TABLE promotionADD (gift VARCHAR2(15) , minretail NUMBER(5, 2) , maxretail NUMBER(5, 2) ) ;
D)   CREATE TABLE promotion(gift VARCHAR2(15) , minretail NUMBER(5, 2) , maxretail NUMBER(5, 2) ;E) A) and B)
F) A) and C)

Exam 3: Table Creation and Management

Which keywords are used to complete the deletion of a column previously marked with SET UNUSED?

Correct AnswerverifiedShow Answer

DML commands are used to create or modify database tables.

Correct AnswerverifiedShow Answer

When a column is deleted, the deletion is permanent.

Correct AnswerverifiedShow Answer

Structure of the PROMOTION table -If a new column is added to the PROMOTION table, where will the new column be listed?

Correct AnswerverifiedShow Answer

If the CREATE TABLE is being used to create a table from existing data, the SUBQUERY keyword must be used.

Correct AnswerverifiedShow Answer

The RENAME command can be used to assign a table to a new schema.

Correct AnswerverifiedShow Answer

The MODIFY ‾\underline { \text { MODIFY } } MODIFY ​ clause can be included in the ALTER TABLE command to add a default value to an existing column. _________________________

Correct AnswerverifiedShow Answer

Structure of the PROMOTION table -Which of the following SQL statements was most likely used to create the PROMOTION table?

Correct AnswerverifiedShow Answer

The scale ‾\underline { \text { scale } } 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

You cannot delete the last column in a table.

Correct AnswerverifiedShow Answer

The CHANGE ‾\underline { \text { CHANGE } } CHANGE ​ TABLE command can be used to modify an existing table. _________________________

Correct AnswerverifiedShow Answer

The DROP TABLE command can be used to remove a table and all its data from a database.

Correct AnswerverifiedShow Answer

More than one column can be changed at a time with the ALTER TABLE ...MODIFY ‾\underline { \text { ALTER TABLE ...MODIFY } } ALTER TABLE ...MODIFY ​ command. _________________________

Correct AnswerverifiedShow Answer

Which of the following keywords cannot be used to modify an existing table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The maximum width of a(n) CHAR‾\underline { \mathrm{CHAR} }CHAR​ column is 4000 characters. _________________________

Correct AnswerverifiedShow Answer

Structure of the PROMOTION table -If the MAXRETAIL column of the PROMOTION table has been set as unused, which of the following commands is valid?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A table name can contain the number sign and ____________________ symbols.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

The $\underline { \text { MODIFY } }$ clause can be included in the ALTER TABLE command to add a default value to an existing column. _________________________

Correct Answer
verified

Correct Answer
verified

The $\underline { \text { scale } }$ of a NUMBER column indicates the total number of digits that can be stored in the column. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

The $\underline { \text { CHANGE } }$ TABLE command can be used to modify an existing table. _________________________

Correct Answer
verified

Correct Answer
verified

More than one column can be changed at a time with the $\underline { \text { ALTER TABLE ...MODIFY } }$ command. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

The maximum width of a(n) $\underline { \mathrm{CHAR} }$ column is 4000 characters. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified