Question 1

To add data from an existing table to a new table,use a SELECT command in a(n)____ command.​

Accepted Answer

A) SET 
B) ​ADD 
C) INSERT 
D) ​UPDATE 
A) SET 
B) ​ADD 
C) INSERT 
D) ​UPDATE C

Question 2

To sort rows in a specific order,use the ____________________ clause with the desired sort key(s).​

Accepted Answer

ORDER BY​

Question 3

You can use the existing value in a column and a calculation to update a value.

Accepted Answer

A) True 
 B)False  True

Question 4

The ____ command is permanent.​

Accepted Answer

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

Question 5

You can use the ____ command to delete an entire table and its data.​

Accepted Answer

A) ROLLBACK 
B) ​DELETE TABLE 
C) DROP TABLE 
D) ​DELETE 
A) ROLLBACK 
B) ​DELETE TABLE 
C) DROP TABLE 
D) ​DELETE

Question 6

When you add a new column to a table,the default for Oracle,SQL Server,and Access is to accept null values.

Accepted Answer

A) True 
 B)False

Question 7

With SQL,you can change a table's structure by using the ____________________ command.​

Accepted Answer

The answer of With SQL,you can change a table's structure...

Question 8

The DROP TABLE command creates an empty table.

Accepted Answer

A) True 
 B)False

Question 9

You cannot commit and roll back data in SQL Server.

Accepted Answer

A) True 
 B)False

Question 10

In Access,use the Documenter tool to show the layout of a table.

Accepted Answer

A) True 
 B)False

Question 11

In order to use the COMMIT command in Oracle,you need to clear the check mark from the ____ check box.​

Accepted Answer

A) Transaction 
B) ​Autocommit 
C) Permanent 
D) ​Temporary 
A) Transaction 
B) ​Autocommit 
C) Permanent 
D) ​Temporary

Question 12

To permanently remove both a table and its data,you must issue both a DROP TABLE command and a DELETE command.

Accepted Answer

A) True 
 B)False

Question 13

There are table structure changes that are beyond the capabilities of SQL.

Accepted Answer

A) True 
 B)False

Question 14

In a transaction,if any update cannot be completed,execute the ____________________ command and discontinue the updates for the current transaction.​

Accepted Answer

The answer of In a transaction,if any update cannot be...

Question 15

____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.​

Accepted Answer

A) Execute 
B) ​Run 
C) Autocommit 
D) ​Enabled 
A) Execute 
B) ​Run 
C) Autocommit 
D) ​Enabled

Question 16

Access does not support the COMMIT or ROLLBACK commands.

Accepted Answer

A) True 
 B)False

Question 17

You use the ____________________ command to remove rows from a table.​

Accepted Answer

The answer of You use the ____________________ command to remove...

Question 18

In some cases,you might need to change a table's structure in ways that are beyond the capabilities of your DBMS.When that happens,use the RESTRUCTURE command to redesign the table.

Accepted Answer

A) True 
 B)False

Question 19

In a transaction,it is acceptable if some steps fail.

Accepted Answer

A) True 
 B)False

Question 20

You can use REMOVE ROW to remove a row from a table.

Accepted Answer

A) True 
 B)False

To add data from an existing table to a new table,use a SELECT command in a(n)____ command.

To sort rows in a specific order,use the ____________________ clause with the desired sort key(s).

You can use the existing value in a column and a calculation to update a value.

The ____ command is permanent.

You can use the ____ command to delete an entire table and its data.

When you add a new column to a table,the default for Oracle,SQL Server,and Access is to accept null values.

With SQL,you can change a table's structure by using the ____________________ command.

The DROP TABLE command creates an empty table.

You cannot commit and roll back data in SQL Server.

In Access,use the Documenter tool to show the layout of a table.

In order to use the COMMIT command in Oracle,you need to clear the check mark from the ____ check box.

To permanently remove both a table and its data,you must issue both a DROP TABLE command and a DELETE command.

There are table structure changes that are beyond the capabilities of SQL.

In a transaction,if any update cannot be completed,execute the ____________________ command and discontinue the updates for the current transaction.

____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.

Access does not support the COMMIT or ROLLBACK commands.

You use the ____________________ command to remove rows from a table.

In some cases,you might need to change a table's structure in ways that are beyond the capabilities of your DBMS.When that happens,use the RESTRUCTURE command to redesign the table.

In a transaction,it is acceptable if some steps fail.

You can use REMOVE ROW to remove a row from a table.

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

To add data from an existing table to a new table,use a SELECT command in a(n)____ command.​

To sort rows in a specific order,use the ____________________ clause with the desired sort key(s).​

You can use the existing value in a column and a calculation to update a value.

The ____ command is permanent.​

You can use the ____ command to delete an entire table and its data.​

When you add a new column to a table,the default for Oracle,SQL Server,and Access is to accept null values.

With SQL,you can change a table's structure by using the ____________________ command.​

The DROP TABLE command creates an empty table.

You cannot commit and roll back data in SQL Server.

In Access,use the Documenter tool to show the layout of a table.

In order to use the COMMIT command in Oracle,you need to clear the check mark from the ____ check box.​

To permanently remove both a table and its data,you must issue both a DROP TABLE command and a DELETE command.

There are table structure changes that are beyond the capabilities of SQL.

In a transaction,if any update cannot be completed,execute the ____________________ command and discontinue the updates for the current transaction.​

____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.​

Access does not support the COMMIT or ROLLBACK commands.

You use the ____________________ command to remove rows from a table.​

In some cases,you might need to change a table's structure in ways that are beyond the capabilities of your DBMS.When that happens,use the RESTRUCTURE command to redesign the table.

In a transaction,it is acceptable if some steps fail.

You can use REMOVE ROW to remove a row from a table.

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

To add data from an existing table to a new table,use a SELECT command in a(n)____ command.

To sort rows in a specific order,use the ____________________ clause with the desired sort key(s).

The ____ command is permanent.

You can use the ____ command to delete an entire table and its data.

With SQL,you can change a table's structure by using the ____________________ command.

In order to use the COMMIT command in Oracle,you need to clear the check mark from the ____ check box.

In a transaction,if any update cannot be completed,execute the ____________________ command and discontinue the updates for the current transaction.

____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.

You use the ____________________ command to remove rows from a table.