Question 1

A table must contain a minimum of two columns._________________________

Accepted Answer

A) True 
 B)False

Question 2

You cannot specify the width for a(n)NUMBER column._________________________​

Accepted Answer

A) True 
 B)False

Question 3

The MODIFY TABLE command can be used to change the size of a table.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of The ____________________ of a NUMBER column indicates...

Question 5

A _______ column generates values automatically at runtime and may reference values from other columns.​

Accepted Answer

A)   ​Automatic
B)   ​Virtual
C)   ​Calculated
D)   ​StaticE) None of the above
F) All of the above

Question 6

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table,add a column list containing ____ names in the CREATE TABLE clause.​

Accepted Answer

A)   ​one
B)   ​four
C)   ​five
D)   ​zeroE) A) and B)
F) C) and D)

Question 7

Which of the following is displayed by the DESCRIBE command?​

Accepted Answer

A)   ​column names
B)   ​not null requirements
C)   ​datatypes
D)   ​all of the aboveE) A) and C)
F) C) and D)

Question 8

Only one column can be added to an existing table at one time.​

Accepted Answer

A) True 
 B)False

Question 9

Using the DESC on a table will display hidden columns.​

Accepted Answer

A) True 
 B)False

Question 10

When a column is deleted,the deletion is permanent.​

Accepted Answer

A) True 
 B)False

Question 11

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) None of the above

Question 12

To retain the structure of a table,while deleting all its data and releasing their storage space,execute the TRUNC command.​

Accepted Answer

A) True 
 B)False

Question 13

The CHANGE TABLE command can be used to modify an existing table._________________________
​

Accepted Answer

A) True 
 B)False

Question 14

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 15

DDL commands are used to create or modify database objects._________________________​

Accepted Answer

A) True 
 B)False

Question 16

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) None of the above
F) C) and D)

Exam 3: Table Creation and Management

A _______ column generates values automatically at runtime and may reference values from other columns.

Correct Answer
verified

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

Correct Answer
verified

When a column is deleted,the deletion is permanent.

Correct Answer
verified

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

Correct Answer
verified

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table,add a column list containing ____ names in the CREATE TABLE clause.

Correct Answer
verified

DDL commands are used to create or modify database objects._________________________

Correct Answer
verified

Which of the following is displayed by the DESCRIBE command?

Correct Answer
verified

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

Correct Answer
verified

To retain the structure of a table,while deleting all its data and releasing their storage space,execute the TRUNC command.

Correct Answer
verified

Using the DESC on a table will display hidden columns.

Correct Answer
verified

The MODIFY TABLE command can be used to change the size of a table.

Correct Answer
verified

A table must contain a minimum of two columns._________________________

Correct Answer
verified

Only one column can be added to an existing table at one time.

Correct Answer
verified

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

Correct Answer
verified

You cannot specify the width for a(n)NUMBER column._________________________

Correct Answer
verified

The CHANGE TABLE command can be used to modify an existing table._________________________

Correct Answer
verified

Exam 3: Table Creation and Management

A _______ column generates values automatically at runtime and may reference values from other columns.​

Correct AnswerverifiedShow Answer

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

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

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table,add a column list containing ____ names in the CREATE TABLE clause.​

Correct AnswerverifiedShow Answer

DDL commands are used to create or modify database objects._________________________​

Correct AnswerverifiedShow Answer

Which of the following is displayed by the DESCRIBE command?​

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

To retain the structure of a table,while deleting all its data and releasing their storage space,execute the TRUNC command.​

Correct AnswerverifiedShow Answer

Using the DESC on a table will display hidden columns.​

Correct AnswerverifiedShow Answer

The MODIFY TABLE command can be used to change the size of a table.

Correct AnswerverifiedShow Answer

A table must contain a minimum of two columns._________________________

Correct AnswerverifiedShow Answer

Only one column can be added to an existing table at one time.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You cannot specify the width for a(n)NUMBER column._________________________​

Correct AnswerverifiedShow Answer

The CHANGE TABLE command can be used to modify an existing table._________________________ ​

Correct AnswerverifiedShow Answer

A _______ column generates values automatically at runtime and may reference values from other columns.

Correct Answer
verified

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

Correct Answer
verified

When a column is deleted,the deletion is permanent.

Correct Answer
verified

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

Correct Answer
verified

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table,add a column list containing ____ names in the CREATE TABLE clause.

Correct Answer
verified

DDL commands are used to create or modify database objects._________________________

Correct Answer
verified

Which of the following is displayed by the DESCRIBE command?

Correct Answer
verified

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

Correct Answer
verified

To retain the structure of a table,while deleting all its data and releasing their storage space,execute the TRUNC command.

Correct Answer
verified

Using the DESC on a table will display hidden columns.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Only one column can be added to an existing table at one time.

Correct Answer
verified

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

Correct Answer
verified

You cannot specify the width for a(n)NUMBER column._________________________

Correct Answer
verified

The CHANGE TABLE command can be used to modify an existing table._________________________

Correct Answer
verified