Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 promotion
AS (gift VARCHAR2(15), minretail NUMBER(5, 2), maxretail NUMBER(5, 2)); 
C)  CREATE TABLE promotion
ADD (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); 
A)  CREATE TABLE promotion
(gift VARCHAR2(15), minretail NUMBER(5, 2), maxretail NUMBER(5, 2)); 
B)  CREATE TABLE promotion
AS (gift VARCHAR2(15), minretail NUMBER(5, 2), maxretail NUMBER(5, 2)); 
C)  CREATE TABLE promotion
ADD (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 3

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 4

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 
A)  DELETE UNUSED COLUMNS 
B)  DROP UNUSED COLUMNS 
C)  UNSET UNUSED COLUMNS 
D)  DROP SET COLUMNS

Question 5

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 
A)  ALTER TABLE 
B)  GENERATE TABLE 
C)  CREATE TABLE...AS 
D)  CREATE TABLE...FROM

Question 6

DML commands are used to create or modify database tables.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

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

Question 9

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 
A)  ALTER TABLE...MARK UNUSED 
B)  ALTER TABLE...SET UNUSED 
C)  ALTER TABLE...DROP UNUSED 
D)  ALTER TABLE...SET COLUMN

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

When a column is deleted, the deletion is permanent.

Accepted Answer

A) True 
 B)False

Question 13

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 
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 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 
A)  ALTER TABLE...ADD 
B)  ALTER TABLE...DROP COLUMN 
C)  ALTER TABLE...MODIFY 
D)  ALTER TABLE...AS

Question 15

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 16

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 17

You cannot delete the last column in a table.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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 
A)  before the GIFT column 
B)  after the GIFT column 
C)  after the MINRETAIL column 
D)  after the MAXRETAIL column

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

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

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

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

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

DML commands are used to create or modify database tables.

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

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

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

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

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

When a column is deleted, the deletion is permanent.

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?

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

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

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

You cannot delete the last column in a table.

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

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

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

Overview of Database Concepts

Basic Sql Select Statements

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 3: Table Creation and Management

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

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

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

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

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

DML commands are used to create or modify database tables.

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

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

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

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

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

When a column is deleted, the deletion is permanent.

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?

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

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

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

You cannot delete the last column in a table.

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

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

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

Overview of Database Concepts

Basic Sql Select Statements

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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

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

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

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

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