Question 1

If you specified ____ for a column when you created a table,then changing a value in a column to null is prohibited.​

Accepted Answer

A) NOT NULL 
B) ​NULL 
C) CHAR 
D) ​NUMBER 
A) NOT NULL 
B) ​NULL 
C) CHAR 
D) ​NUMBER

Question 2

You can change the characteristics of existing columns by using the ____________________ clause of the ALTER TABLE command.​

Accepted Answer

The answer of You can change the characteristics of existing...

Question 3

To change rows for which a specific condition is true,use the ____ command​

Accepted Answer

A) CHANGE 
B) ​MODIFY 
C) UPDATE 
D) ​ALTER 
A) CHANGE 
B) ​MODIFY 
C) UPDATE 
D) ​ALTER

Question 4

Which of the following is a valid SQL command?​

Accepted Answer

A) DROP TABLE LEVEL1_CUSTOMER; 
B) ​DROP LEVEL1_CUSTOMER; 
C) DELETE LEVEL1_CUSTOMER; 
D) ​All of the above 
A) DROP TABLE LEVEL1_CUSTOMER; 
B) ​DROP LEVEL1_CUSTOMER; 
C) DELETE LEVEL1_CUSTOMER; 
D) ​All of the above

Question 5

In SQL Server,the word NULL appears in the results when a column contains a null value.

Accepted Answer

A) True 
 B)False

Question 6

If you specify NOT NULL for a column when you create a table,you are prohibited from changing a value in the column to null.

Accepted Answer

A) True 
 B)False

Question 7

If the Autocommit mode is turned off,you can cancel updates at any time during your current work session.

Accepted Answer

A) True 
 B)False

Question 8

You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values.​

Accepted Answer

A) ADD 
B) ​MODIFY 
C) UPDATE 
D) ​NULL 
A) ADD 
B) ​MODIFY 
C) UPDATE 
D) ​NULL

Question 9

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

Accepted Answer

The answer of In Oracle,use the ____________________ command to display...

Question 10

To add a new column,use the ____________________ clause of the ALTER TABLE command.​

Accepted Answer

The answer of To add a new column,use the ____________________...

Question 11

Describe the format of the ALTER TABLE command to add a new column.​

Accepted Answer

To add a new column,use the ADD clause o

Question 12

If you have not run the COMMIT command,executing the ____ command will reverse all updates made during the current work session.​

Accepted Answer

A) UPDATE 
B) ​REVERSE 
C) ROLLBACK 
D) ​ROLL 
A) UPDATE 
B) ​REVERSE 
C) ROLLBACK 
D) ​ROLL

Question 13

What happens if you run a DELETE command that does not contain a WHERE clause?​

Accepted Answer

A) The table will be deleted. 
B) ​All rows will be deleted from the table. 
C) All values would be replaced by nulls. 
D) ​None of the above. 
A) The table will be deleted. 
B) ​All rows will be deleted from the table. 
C) All values would be replaced by nulls. 
D) ​None of the above.

Question 14

One of the nicest features of a relational DBMS,such as Oracle,is the ease with which you can change table structures.

Accepted Answer

A) True 
 B)False

Question 15

If you specified ____________________ for the column when you created the table,then changing a value in a column to null is prohibited.​

Accepted Answer

The answer of If you specified ____________________ for the column...

Question 16

Describe the format for the UPDATE command.​

Accepted Answer

The format for the UPDATE command is the

Question 17

You can increase the length of column but you cannot decrease the length of a column.

Accepted Answer

A) True 
 B)False

Question 18

You can create a new table using data in an existing table.

Accepted Answer

A) True 
 B)False

Question 19

Before beginning the updates for a transaction,commit any previous updates by executing the ____________________ command.​

Accepted Answer

The answer of Before beginning the updates for a transaction,commit...

Question 20

Access does not support the ____ data type.​

Accepted Answer

A) DECIMAL 
B) ​CURRENCY 
C) CHAR 
D) ​INT 
A) DECIMAL 
B) ​CURRENCY 
C) CHAR 
D) ​INT

If you specified ____ for a column when you created a table,then changing a value in a column to null is prohibited.

You can change the characteristics of existing columns by using the ____________________ clause of the ALTER TABLE command.

To change rows for which a specific condition is true,use the ____ command

Which of the following is a valid SQL command?

In SQL Server,the word NULL appears in the results when a column contains a null value.

If you specify NOT NULL for a column when you create a table,you are prohibited from changing a value in the column to null.

If the Autocommit mode is turned off,you can cancel updates at any time during your current work session.

You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values.

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

To add a new column,use the ____________________ clause of the ALTER TABLE command.

Describe the format of the ALTER TABLE command to add a new column.

If you have not run the COMMIT command,executing the ____ command will reverse all updates made during the current work session.

What happens if you run a DELETE command that does not contain a WHERE clause?

One of the nicest features of a relational DBMS,such as Oracle,is the ease with which you can change table structures.

If you specified ____________________ for the column when you created the table,then changing a value in a column to null is prohibited.

Describe the format for the UPDATE command.

You can increase the length of column but you cannot decrease the length of a column.

You can create a new table using data in an existing table.

Before beginning the updates for a transaction,commit any previous updates by executing the ____________________ command.

Access does not support the ____ data type.

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

If you specified ____ for a column when you created a table,then changing a value in a column to null is prohibited.​

You can change the characteristics of existing columns by using the ____________________ clause of the ALTER TABLE command.​

To change rows for which a specific condition is true,use the ____ command​

Which of the following is a valid SQL command?​

In SQL Server,the word NULL appears in the results when a column contains a null value.

If you specify NOT NULL for a column when you create a table,you are prohibited from changing a value in the column to null.

If the Autocommit mode is turned off,you can cancel updates at any time during your current work session.

You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values.​

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

To add a new column,use the ____________________ clause of the ALTER TABLE command.​

Describe the format of the ALTER TABLE command to add a new column.​

If you have not run the COMMIT command,executing the ____ command will reverse all updates made during the current work session.​

What happens if you run a DELETE command that does not contain a WHERE clause?​

One of the nicest features of a relational DBMS,such as Oracle,is the ease with which you can change table structures.

If you specified ____________________ for the column when you created the table,then changing a value in a column to null is prohibited.​

Describe the format for the UPDATE command.​

You can increase the length of column but you cannot decrease the length of a column.

You can create a new table using data in an existing table.

Before beginning the updates for a transaction,commit any previous updates by executing the ____________________ command.​

Access does not support the ____ data type.​

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

If you specified ____ for a column when you created a table,then changing a value in a column to null is prohibited.

You can change the characteristics of existing columns by using the ____________________ clause of the ALTER TABLE command.

To change rows for which a specific condition is true,use the ____ command

Which of the following is a valid SQL command?

You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values.

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

To add a new column,use the ____________________ clause of the ALTER TABLE command.

Describe the format of the ALTER TABLE command to add a new column.

If you have not run the COMMIT command,executing the ____ command will reverse all updates made during the current work session.

What happens if you run a DELETE command that does not contain a WHERE clause?

If you specified ____________________ for the column when you created the table,then changing a value in a column to null is prohibited.

Describe the format for the UPDATE command.

Before beginning the updates for a transaction,commit any previous updates by executing the ____________________ command.

Access does not support the ____ data type.