Question 1

How does the procedure for adding rows to an existing MySQL table compare to that for populating a new table that has just been created?

Accepted Answer

A)  They are identical. 
B)  They are similar, except you use the UPDATE command for adding rows to an existing table. 
C)  They are similar, except you use the ALTER command for adding rows to an existent table. 
D)  They require both different commands and different clauses. 
A)  They are identical. 
B)  They are similar, except you use the UPDATE command for adding rows to an existing table. 
C)  They are similar, except you use the ALTER command for adding rows to an existent table. 
D)  They require both different commands and different clauses. A

Question 2

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)  Nothing; this will cause an error. 
A)  The table will be deleted. 
B)  All rows will be deleted from the table. 
C)  All values would be replaced by nulls. 
D)  Nothing; this will cause an error. B

Question 3

Once you have verified that the update you made is correct, you can make the update permanent by using the _____.

Accepted Answer

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

Question 4

The default transaction mode in Oracle, which commits each action query as soon as the user executes the query, is _____.

Accepted Answer

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

Question 5

Patty begins entering an order into her DBMS using SQL, but soon discovers she cannot complete the order entry process owing to missing data. What should she do to follow best practices related to transactions?

Accepted Answer

A)  turn on the Autocommit feature 
B)  execute the ROLLBACK command 
C)  leave the order in a partially entered state 
D)  execute the COMMIT command 
A)  turn on the Autocommit feature 
B)  execute the ROLLBACK command 
C)  leave the order in a partially entered state 
D)  execute the COMMIT command

Question 6

Describe the format of the command used to add a new column to an existing MySQL table.

Accepted Answer

To add a new column, use the ADD clause

Question 7

Which command is used to display the structure of a table in MySQL?

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 8

A logical unit of work, often conceptualized as a sequence of steps that accomplish a single task, is called a _____.

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

James has created a new MySQL table called FAVORITES and would like to populate it with data from the existing CANDY table. Which command can he use to add data for rows with a rating of seven or more?

Accepted Answer

A)  SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7)); 
B)  INSERT INTO FAVORITES (SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7)); 
C)  SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7)) INSERT INTO FAVORITES; 
D)  INSERT INTO FAVORITES (FROM CANDY IF RATING > 7); 
A)  SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7)); 
B)  INSERT INTO FAVORITES (SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7)); 
C)  SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7)) INSERT INTO FAVORITES; 
D)  INSERT INTO FAVORITES (FROM CANDY IF RATING > 7);

Question 11

A MySQL command to change a value within a table to null _____.

Accepted Answer

A)  requires that the value NULL be enclosed in double quotation marks 
B)  is formatted differently from other commands to change table data 
C)  incorporates the UPDATE and SET commands and a WHERE clause 
D)  will execute only if the column selected was specified as NOT NULL 
A)  requires that the value NULL be enclosed in double quotation marks 
B)  is formatted differently from other commands to change table data 
C)  incorporates the UPDATE and SET commands and a WHERE clause 
D)  will execute only if the column selected was specified as NOT NULL

Question 12

How do you change a value in a column to null?

Accepted Answer

The command for changing a value in a co

Question 13

Using SQL, you can increase the length of an existing table column but you cannot decrease the length of a column.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What command is used to delete rows from the database?

Accepted Answer

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

Question 16

What do you need to know to complete the FIRST step in the process of creating a new table using data from an existing table, called CANDY, in MySQL?

Accepted Answer

A)  the number of rows and columns in the existing table 
B)  the primary key value for each row in the table of existing data 
C)  the columns from CANDY that you want to include and their characteristics 
D)  the rows from CANDY that you want to include in the new table 
A)  the number of rows and columns in the existing table 
B)  the primary key value for each row in the table of existing data 
C)  the columns from CANDY that you want to include and their characteristics 
D)  the rows from CANDY that you want to include in the new table

Question 17

Describe the format for the UPDATE command.

Accepted Answer

The format for the UPDATE command is the

Question 18

Which command(s) can you use to delete an entire table and its data?

Accepted Answer

A)  ROLLBACK 
B)  SELECT and DELETE TABLE 
C)  DROP TABLE 
D)  DELETE and ALTER TABLE 
A)  ROLLBACK 
B)  SELECT and DELETE TABLE 
C)  DROP TABLE 
D)  DELETE and ALTER TABLE

Question 19

Which clause can you use with 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 20

Which command can you use to change rows for which a specific condition is true?

Accepted Answer

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

How does the procedure for adding rows to an existing MySQL table compare to that for populating a new table that has just been created?

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

Once you have verified that the update you made is correct, you can make the update permanent by using the _____.

The default transaction mode in Oracle, which commits each action query as soon as the user executes the query, is _____.

Patty begins entering an order into her DBMS using SQL, but soon discovers she cannot complete the order entry process owing to missing data. What should she do to follow best practices related to transactions?

Describe the format of the command used to add a new column to an existing MySQL table.

Which command is used to display the structure of a table in MySQL?

A logical unit of work, often conceptualized as a sequence of steps that accomplish a single task, is called a _____.

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

James has created a new MySQL table called FAVORITES and would like to populate it with data from the existing CANDY table. Which command can he use to add data for rows with a rating of seven or more?

A MySQL command to change a value within a table to null _____.

How do you change a value in a column to null?

Using SQL, you can increase the length of an existing table column but you cannot decrease the length of a column.

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

What command is used to delete rows from the database?

What do you need to know to complete the FIRST step in the process of creating a new table using data from an existing table, called CANDY, in MySQL?

Describe the format for the UPDATE command.

Which command(s) can you use to delete an entire table and its data?

Which clause can you use with the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values?

Which command can you use to change rows for which a specific condition is true?

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Single Table Queries

Multiple Table Queries

Database Administration

Functions Procedures and Triggers

Filters

Exam 6: Updating Data

How does the procedure for adding rows to an existing MySQL table compare to that for populating a new table that has just been created?

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

Once you have verified that the update you made is correct, you can make the update permanent by using the _____.

The default transaction mode in Oracle, which commits each action query as soon as the user executes the query, is _____.

Patty begins entering an order into her DBMS using SQL, but soon discovers she cannot complete the order entry process owing to missing data. What should she do to follow best practices related to transactions?

Describe the format of the command used to add a new column to an existing MySQL table.

Which command is used to display the structure of a table in MySQL?

A logical unit of work, often conceptualized as a sequence of steps that accomplish a single task, is called a _____.

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

James has created a new MySQL table called FAVORITES and would like to populate it with data from the existing CANDY table. Which command can he use to add data for rows with a rating of seven or more?

A MySQL command to change a value within a table to null _____.

How do you change a value in a column to null?

Using SQL, you can increase the length of an existing table column but you cannot decrease the length of a column.

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

What command is used to delete rows from the database?

What do you need to know to complete the FIRST step in the process of creating a new table using data from an existing table, called CANDY, in MySQL?

Describe the format for the UPDATE command.

Which command(s) can you use to delete an entire table and its data?

Which clause can you use with the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values?

Which command can you use to change rows for which a specific condition is true?

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Single Table Queries

Multiple Table Queries

Database Administration

Functions Procedures and Triggers

Filters