Question 1

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

Accepted Answer

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

Question 2

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 3

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 c

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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 9

You cannot delete the last column in a table.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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) ;

Question 12

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 13

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 column

Question 14

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

Question 15

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 COLUMNS

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

DML commands are used to create or modify database tables.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

When a column is deleted, the deletion is permanent.

Accepted Answer

A) True 
 B)False

Exam 3: Table Creation and Management

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

DML commands are used to create or modify database tables.

Correct AnswerverifiedShow Answer

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

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

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

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

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

Correct AnswerverifiedShow Answer

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

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

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

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

When a column is deleted, the deletion is permanent.

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

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

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

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

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

Correct Answer
verified

Correct Answer
verified

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 $\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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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