Question 1

A table must contain a minimum of two columns._________________________

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

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)  ​zero 
A)  ​one 
B)  ​four 
C)  ​five 
D)  ​zero

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

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

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

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

Accepted Answer

A)  ​Automatic 
B)  ​Virtual 
C)  ​Calculated 
D)  ​Static 
A)  ​Automatic 
B)  ​Virtual 
C)  ​Calculated 
D)  ​Static

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 above 
A)  ​column names 
B)  ​not null requirements 
C)  ​datatypes 
D)  ​all of the above

A table must contain a minimum of two columns._________________________

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

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.

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

Using the DESC on a table will display hidden columns.

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

When a column is deleted,the deletion is permanent.

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

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

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

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

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

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

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

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

Which of the following is displayed by the DESCRIBE command?

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

A table must contain a minimum of two columns._________________________

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

Using the DESC on a table will display hidden columns.

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

When a column is deleted,the deletion is permanent.

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

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

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

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

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

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

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

Which of the following is displayed by the DESCRIBE command?