Question 1

To verify that the correct change was made to data in a table,use the DISPLAY command.

Accepted Answer

A) True 
 B)False

Question 2

The command,CREATE TABLE AS LEVEL1_CUSTOMER USING CUSTOMER;creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.

Accepted Answer

A) True 
 B)False

Question 3

To delete rows from the database,use the ____ command.​

Accepted Answer

A) ROLLBACK 
B) ​COMMIT 
C) DELETE 
D) ​UPDATE 
A) ROLLBACK 
B) ​COMMIT 
C) DELETE 
D) ​UPDATE

Question 4

You cannot use a compound condition with an UPDATE command.

Accepted Answer

A) True 
 B)False

Question 5

You use the APPEND command to add additional rows to tables.

Accepted Answer

A) True 
 B)False

Question 6

If you decrease the size of a column,it is possible to lose some data currently in the column.

Accepted Answer

A) True 
 B)False

Question 7

The format for the UPDATE command is the word UPDATE,followed by the name of the table to be updated.The next portion of the command consists of the word ____________________,followed by the name of the column to be updated,an equals sign,and the new value.​

Accepted Answer

The answer of The format for the UPDATE command is...

Question 8

Which of the following is a valid SQL command?​

Accepted Answer

A) COMMIT TABLE; 
B) ​COMMIT CHANGES; 
C) COMMIT DB; 
D) ​COMMIT; 
A) COMMIT TABLE; 
B) ​COMMIT CHANGES; 
C) COMMIT DB; 
D) ​COMMIT;

Question 9

By default,Oracle commits each action query as soon as the user executes the query.

Accepted Answer

A) True 
 B)False

Question 10

During your current work session you can save your changes immediately by executing the ____________________ command.​

Accepted Answer

The answer of During your current work session you can...

Question 11

How can you use the COMMIT and ROLLBACK commands to support transactions?​

Accepted Answer

You can use the COMMIT and ROLLBACK comm

Question 12

The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the ____________________ to be altered,followed by an appropriate clause.​

Accepted Answer

The answer of The format for the ALTER TABLE command...

Question 13

A(n)____ can be viewed as a sequence of steps that accomplishes a single task.​

Accepted Answer

A) procedure 
B) ​transaction 
C) program 
D) ​method 
A) procedure 
B) ​transaction 
C) program 
D) ​method

Question 14

The data stored in tables changes only infrequently.

Accepted Answer

A) True 
 B)False

Question 15

If you change the value of a column to NULL,you must enclose the NULL value in single quotation marks.

Accepted Answer

A) True 
 B)False

To verify that the correct change was made to data in a table,use the DISPLAY command.

The command,CREATE TABLE AS LEVEL1_CUSTOMER USING CUSTOMER;creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.

To delete rows from the database,use the ____ command.

You cannot use a compound condition with an UPDATE command.

You use the APPEND command to add additional rows to tables.

If you decrease the size of a column,it is possible to lose some data currently in the column.

The format for the UPDATE command is the word UPDATE,followed by the name of the table to be updated.The next portion of the command consists of the word ____________________,followed by the name of the column to be updated,an equals sign,and the new value.

Which of the following is a valid SQL command?

By default,Oracle commits each action query as soon as the user executes the query.

During your current work session you can save your changes immediately by executing the ____________________ command.

How can you use the COMMIT and ROLLBACK commands to support transactions?

The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the ____________________ to be altered,followed by an appropriate clause.

A(n)____ can be viewed as a sequence of steps that accomplishes a single task.

The data stored in tables changes only infrequently.

If you change the value of a column to NULL,you must enclose the NULL value in single quotation marks.

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 verify that the correct change was made to data in a table,use the DISPLAY command.

The command,CREATE TABLE AS LEVEL1_CUSTOMER USING CUSTOMER;creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.

To delete rows from the database,use the ____ command.​

You cannot use a compound condition with an UPDATE command.

You use the APPEND command to add additional rows to tables.

If you decrease the size of a column,it is possible to lose some data currently in the column.

The format for the UPDATE command is the word UPDATE,followed by the name of the table to be updated.The next portion of the command consists of the word ____________________,followed by the name of the column to be updated,an equals sign,and the new value.​

Which of the following is a valid SQL command?​

By default,Oracle commits each action query as soon as the user executes the query.

During your current work session you can save your changes immediately by executing the ____________________ command.​

How can you use the COMMIT and ROLLBACK commands to support transactions?​

The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the ____________________ to be altered,followed by an appropriate clause.​

A(n)____ can be viewed as a sequence of steps that accomplishes a single task.​

The data stored in tables changes only infrequently.

If you change the value of a column to NULL,you must enclose the NULL value in single quotation marks.

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 delete rows from the database,use the ____ command.

The format for the UPDATE command is the word UPDATE,followed by the name of the table to be updated.The next portion of the command consists of the word ____________________,followed by the name of the column to be updated,an equals sign,and the new value.

Which of the following is a valid SQL command?

During your current work session you can save your changes immediately by executing the ____________________ command.

How can you use the COMMIT and ROLLBACK commands to support transactions?

The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the ____________________ to be altered,followed by an appropriate clause.

A(n)____ can be viewed as a sequence of steps that accomplishes a single task.