Question 1

The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.

Accepted Answer

A) True 
 B)False

Question 2

The$\underline {  \text { 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 3

Which of the following datatypes refers to variable-length character data, where n represents the maximum length of the column?

Accepted Answer

A)  CHAR(n) 
B)  BFILE 
C)  VARCHAR2(n) 
D)  LONG 
A)  CHAR(n) 
B)  BFILE 
C)  VARCHAR2(n) 
D)  LONG

Question 4

A CHAR column cannot be resized to a width that is smaller than the data it already contains.

Accepted Answer

A) True 
 B)False

Question 5

Each ____________________ name within a table must be unique.

Accepted Answer

The answer of Each ____________________ name within a table must...

Question 6

The column definition of NUMBER(7, 4) indicates a precision of ____.

Accepted Answer

A)  7 
B)  4 
C)  11 
D)  3 
A)  7 
B)  4 
C)  11 
D)  3

Question 7

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?

Accepted Answer

When a column is dropped with the DROP C

Question 8

Which of the following symbols cannot be used in a table name?

Accepted Answer

A)  _ 
B)  % 
C)  # 
D)  none of the above 
A)  _ 
B)  % 
C)  # 
D)  none of the above

Question 9

The width of a NUMBER column cannot be $\underline { \text { changed }   }$once it contains data. _________________________

Accepted Answer

A) True 
 B)False

Question 10

Which of the following SQL*Plus commands will display the structure of a table?

Accepted Answer

A)  DISPLAY 
B)  DESC 
C)  DSC 
D)  VIEW 
A)  DISPLAY 
B)  DESC 
C)  DSC 
D)  VIEW

Question 11

The DROP COLUMN clause of the ALTER TABLE command can only be used to $\underline { \text { delete } }$one column at a time. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Once a table is ____________________, any associated indexes will be removed from the database.

Accepted Answer

The answer of Once a table is ____________________, any associated...

The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.

The $\underline { \text { MODIFY } }$ clause can be used with the ALTER TABLE command to add a column to an existing table. _________________________

Which of the following datatypes refers to variable-length character data, where n represents the maximum length of the column?

A CHAR column cannot be resized to a width that is smaller than the data it already contains.

Each ____________________ name within a table must be unique.

The column definition of NUMBER(7, 4) indicates a precision of ____.

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?

Which of the following symbols cannot be used in a table name?

The width of a NUMBER column cannot be $\underline { \text { changed } }$ once it contains data. _________________________

Which of the following SQL*Plus commands will display the structure of a table?

The DROP COLUMN clause of the ALTER TABLE command can only be used to $\underline { \text { delete } }$ one column at a time. _________________________

Once a table is ____________________, any associated indexes will be removed from the database.

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 precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.

The MODIFY ‾\underline { \text { MODIFY } } MODIFY ​ clause can be used with the ALTER TABLE command to add a column to an existing table. _________________________

Which of the following datatypes refers to variable-length character data, where n represents the maximum length of the column?

A CHAR column cannot be resized to a width that is smaller than the data it already contains.

Each ____________________ name within a table must be unique.

The column definition of NUMBER(7, 4) indicates a precision of ____.

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?

Which of the following symbols cannot be used in a table name?

The width of a NUMBER column cannot be changed ‾\underline { \text { changed } } changed ​ once it contains data. _________________________

Which of the following SQL*Plus commands will display the structure of a table?

The DROP COLUMN clause of the ALTER TABLE command can only be used to delete ‾\underline { \text { delete } } delete ​ one column at a time. _________________________

Once a table is ____________________, any associated indexes will be removed from the database.

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 { MODIFY } }$ clause can be used with the ALTER TABLE command to add a column to an existing table. _________________________

The width of a NUMBER column cannot be $\underline { \text { changed } }$ once it contains data. _________________________

The DROP COLUMN clause of the ALTER TABLE command can only be used to $\underline { \text { delete } }$ one column at a time. _________________________