Question 1

By placing a(n)____________________ command in an INSERT command,you can add the query results to a table.​

Accepted Answer

The answer of By placing a(n)____________________ command in an INSERT...

Question 2

To add a new column,use the ADD NEW COLUMN clause of the ALTER TABLE command.

Accepted Answer

A) True 
 B)False

Question 3

In SQL Server,execute the sp_columns command to list all the columns in a table.

Accepted Answer

A) True 
 B)False

Question 4

The ROLLBACK command reverses changes made to the ____________________ only.​

Accepted Answer

The answer of The ROLLBACK command reverses changes made to...

Question 5

It is a good idea to use a SELECT command to display the data you changed to verify that the correct update was made.

Accepted Answer

A) True 
 B)False

Question 6

A(n)____________________ is a logical unit of work.​

Accepted Answer

The answer of A(n)____________________ is a logical unit of work.​...

Question 7

You cannot change the characteristics of existing columns.

Accepted Answer

A) True 
 B)False

Question 8

Updates become permanent automatically when you exit from the DBMS.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following commands executes a rollback?​

Accepted Answer

A) ROLLBACK TABLE; 
B) ​ROLLBACK; 
C) ROLLBACK ALL; 
D) ​ROLLBACK DB; 
A) ROLLBACK TABLE; 
B) ​ROLLBACK; 
C) ROLLBACK ALL; 
D) ​ROLLBACK DB;

Question 10

In Oracle 11 g,a null value is displayed as a hyphen.

Accepted Answer

A) True 
 B)False

Question 11

When necessary,include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.

Accepted Answer

A) True 
 B)False

Question 12

The ADD clause consists of the word ADD followed by the name of the ____________________ to be added,followed by the characteristics.​

Accepted Answer

The answer of The ADD clause consists of the word...

Question 13

You can use the ____ command to create a new table using data in an existing table.​

Accepted Answer

A) CREATE TABLE 
B) ​NEW TABLE 
C) UPDATE 
D) ​ALTER TABLE 
A) CREATE TABLE 
B) ​NEW TABLE 
C) UPDATE 
D) ​ALTER TABLE

Question 14

In SQL,use the ____ data type for variable-length character columns.​

Accepted Answer

A) TEXT 
B) ​VARCHAR 
C) VARIABLE 
D) ​CHARLENGTH 
A) TEXT 
B) ​VARCHAR 
C) VARIABLE 
D) ​CHARLENGTH

Question 15

In Oracle,use the ____ command to display the structure of a table.​

Accepted Answer

A) SHOW TABLE 
B) ​SHOW LAYOUT 
C) DESCRIBE 
D) ​DISPLAY LAYOUT 
A) SHOW TABLE 
B) ​SHOW LAYOUT 
C) DESCRIBE 
D) ​DISPLAY LAYOUT

Question 16

To change a column that currently rejects null values so that it accepts null vlaues,use the ____________________ clause in the ALTER TABLE command.​

Accepted Answer

The answer of To change a column that currently rejects...

Question 17

In a transaction,if you can complete all updates successfully,execute the ____________________ command after completing the final update.​

Accepted Answer

The answer of In a transaction,if you can complete all...

Question 18

If you have verified that the update you made is correct,you can use the ____ command to make the update permanent.​

Accepted Answer

A) UPDATE 
B) ​ROLL 
C) COMMIT 
D) ​SAVE 
A) UPDATE 
B) ​ROLL 
C) COMMIT 
D) ​SAVE

Question 19

If you decide that you do not want to save the changes you have made during your current work session,you can reverse the changes by executing the ____________________ command.​

Accepted Answer

The answer of If you decide that you do not...

Question 20

You can delete a table that is no longer needed by using the ____________________ TABLE command.​

Accepted Answer

The answer of You can delete a table that is...

By placing a(n)____________________ command in an INSERT command,you can add the query results to a table.

To add a new column,use the ADD NEW COLUMN clause of the ALTER TABLE command.

In SQL Server,execute the sp_columns command to list all the columns in a table.

The ROLLBACK command reverses changes made to the ____________________ only.

It is a good idea to use a SELECT command to display the data you changed to verify that the correct update was made.

A(n)____________________ is a logical unit of work.

You cannot change the characteristics of existing columns.

Updates become permanent automatically when you exit from the DBMS.

Which of the following commands executes a rollback?

In Oracle 11 g,a null value is displayed as a hyphen.

When necessary,include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.

The ADD clause consists of the word ADD followed by the name of the ____________________ to be added,followed by the characteristics.

You can use the ____ command to create a new table using data in an existing table.

In SQL,use the ____ data type for variable-length character columns.

In Oracle,use the ____ command to display the structure of a table.

To change a column that currently rejects null values so that it accepts null vlaues,use the ____________________ clause in the ALTER TABLE command.

In a transaction,if you can complete all updates successfully,execute the ____________________ command after completing the final update.

If you have verified that the update you made is correct,you can use the ____ command to make the update permanent.

If you decide that you do not want to save the changes you have made during your current work session,you can reverse the changes by executing the ____________________ command.

You can delete a table that is no longer needed by using the ____________________ TABLE command.

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Database Administration

SQL Functions and Procedures

Filters

Exam 6: Updating Data

By placing a(n)____________________ command in an INSERT command,you can add the query results to a table.​

To add a new column,use the ADD NEW COLUMN clause of the ALTER TABLE command.

In SQL Server,execute the sp_columns command to list all the columns in a table.

The ROLLBACK command reverses changes made to the ____________________ only.​

It is a good idea to use a SELECT command to display the data you changed to verify that the correct update was made.

A(n)____________________ is a logical unit of work.​

You cannot change the characteristics of existing columns.

Updates become permanent automatically when you exit from the DBMS.

Which of the following commands executes a rollback?​

In Oracle 11 g,a null value is displayed as a hyphen.

When necessary,include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.

The ADD clause consists of the word ADD followed by the name of the ____________________ to be added,followed by the characteristics.​

You can use the ____ command to create a new table using data in an existing table.​

In SQL,use the ____ data type for variable-length character columns.​

In Oracle,use the ____ command to display the structure of a table.​

To change a column that currently rejects null values so that it accepts null vlaues,use the ____________________ clause in the ALTER TABLE command.​

In a transaction,if you can complete all updates successfully,execute the ____________________ command after completing the final update.​

If you have verified that the update you made is correct,you can use the ____ command to make the update permanent.​

If you decide that you do not want to save the changes you have made during your current work session,you can reverse the changes by executing the ____________________ command.​

You can delete a table that is no longer needed by using the ____________________ TABLE command.​

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Database Administration

SQL Functions and Procedures

Filters

By placing a(n)____________________ command in an INSERT command,you can add the query results to a table.

The ROLLBACK command reverses changes made to the ____________________ only.

A(n)____________________ is a logical unit of work.

Which of the following commands executes a rollback?

The ADD clause consists of the word ADD followed by the name of the ____________________ to be added,followed by the characteristics.

You can use the ____ command to create a new table using data in an existing table.

In SQL,use the ____ data type for variable-length character columns.

In Oracle,use the ____ command to display the structure of a table.

To change a column that currently rejects null values so that it accepts null vlaues,use the ____________________ clause in the ALTER TABLE command.

In a transaction,if you can complete all updates successfully,execute the ____________________ command after completing the final update.

If you have verified that the update you made is correct,you can use the ____ command to make the update permanent.

If you decide that you do not want to save the changes you have made during your current work session,you can reverse the changes by executing the ____________________ command.

You can delete a table that is no longer needed by using the ____________________ TABLE command.