Question 1

The maximum width of a(n)CHAR column is 4000 characters._________________________

Accepted Answer

A) True 
 B)False

Question 2

A datatype identifies the type of data to be stored in a column.​

Accepted Answer

A) True 
 B)False

Question 3

The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table._________________________​

Accepted Answer

A) True 
 B)False

Question 4

The DROP COLUMN clause of the ALTER TABLE command can only be used to delete one column at a time._________________________​

Accepted Answer

A) True 
 B)False

Question 5

The 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 6

When defining columns for a table,which of the following symbols is used to separate the column names in the column list?​

Accepted Answer

A)  ​" " 
B)  ​, 
C)  ​( ) 
D)  ​| | 
A)  ​" " 
B)  ​, 
C)  ​( ) 
D)  ​| |

Question 7

The column list of the CREATE TABLE command must be enclosed in ____________________.

Accepted Answer

The answer of The column list of the CREATE TABLE...

Question 8

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

A table name can contain a maximum of ____________________ characters.

Accepted Answer

The answer of A table name can contain a maximum...

Question 10

Every table name within a specific schema must be unique.​

Accepted Answer

A) True 
 B)False

Question 11

When adding a column to an existing table,the ____________________ clause must be used with the ALTER TABLE command.​

Accepted Answer

The answer of When adding a column to an existing...

Question 12

The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.

Accepted Answer

The answer of The ____________________ keyword must be used with...

Question 13

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 14

A table name must begin with a(n)number._________________________​

Accepted Answer

A) True 
 B)False

Question 15

The ALTER TABLE name can be used to rename a table.​

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ datatype is used to store fixed length data.

Accepted Answer

The answer of The ____________________ datatype is used to store...

Question 17

The abbreviation for the DESCRIBE command is DES._________________________​

Accepted Answer

A) True 
 B)False

Question 18

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 19

The USER_TAB_COLS data dictionary object contains a column to identify hidden columns.​

Accepted Answer

A) True 
 B)False

Question 20

You cannot delete the last column in a table.​

Accepted Answer

A) True 
 B)False

The maximum width of a(n)CHAR column is 4000 characters._________________________

A datatype identifies the type of data to be stored in a column.

The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table._________________________

The DROP COLUMN clause of the ALTER TABLE command can only be used to delete one column at a time._________________________

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

When defining columns for a table,which of the following symbols is used to separate the column names in the column list?

The column list of the CREATE TABLE command must be enclosed in ____________________.

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

A table name can contain a maximum of ____________________ characters.

Every table name within a specific schema must be unique.

When adding a column to an existing table,the ____________________ clause must be used with the ALTER TABLE command.

The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.

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

A table name must begin with a(n)number._________________________

The ALTER TABLE name can be used to rename a table.

The ____________________ datatype is used to store fixed length data.

The abbreviation for the DESCRIBE command is DES._________________________

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

The USER_TAB_COLS data dictionary object contains a column to identify hidden columns.

You cannot delete the last column in a table.

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 maximum width of a(n)CHAR column is 4000 characters._________________________

A datatype identifies the type of data to be stored in a column.​

The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table._________________________​

The DROP COLUMN clause of the ALTER TABLE command can only be used to delete one column at a time._________________________​

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

When defining columns for a table,which of the following symbols is used to separate the column names in the column list?​

The column list of the CREATE TABLE command must be enclosed in ____________________.

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

A table name can contain a maximum of ____________________ characters.

Every table name within a specific schema must be unique.​

When adding a column to an existing table,the ____________________ clause must be used with the ALTER TABLE command.​

The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.

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

A table name must begin with a(n)number._________________________​

The ALTER TABLE name can be used to rename a table.​

The ____________________ datatype is used to store fixed length data.

The abbreviation for the DESCRIBE command is DES._________________________​

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

The USER_TAB_COLS data dictionary object contains a column to identify hidden columns.​

You cannot delete the last column in a table.​

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

A datatype identifies the type of data to be stored in a column.

The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table._________________________

The DROP COLUMN clause of the ALTER TABLE command can only be used to delete one column at a time._________________________

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

When defining columns for a table,which of the following symbols is used to separate the column names in the column list?

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

Every table name within a specific schema must be unique.

When adding a column to an existing table,the ____________________ clause must be used with the ALTER TABLE command.

A table name must begin with a(n)number._________________________

The ALTER TABLE name can be used to rename a table.

The abbreviation for the DESCRIBE command is DES._________________________

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

The USER_TAB_COLS data dictionary object contains a column to identify hidden columns.

You cannot delete the last column in a table.