Question 1

Which is the correct sequence of elements in a command to remove rows from a MySQL table?

Accepted Answer

A)  SELECT*, FROM, table name, WHERE clause with a condition, DELETE 
B)  DELETE FROM, table name, WHERE clause with a condition 
C)  DELETE, WHERE clause with a condition, FROM, table name 
D)  FROM, table name, WHERE clause with a condition, DELETE

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Changing a value in a table column to null is prohibited if, when you created the table, you specified _____.

Accepted Answer

A)  NOT NULL for the column 
B)  NULL for the column 
C)  a CHAR data type for the column 
D)  a NUMBER data type for the column

Question 4

The DROP TABLE command creates an empty table.

Accepted Answer

A) True 
 B)False

Question 5

Which is the correct sequence of elements for a SQL command that will change a value in an existing table row?

Accepted Answer

A)  UPDATE, table name, SELECT, column name, SET, new value 
B)  SELECT, table name, UPDATE, column name, equal sign, new value 
C)  IN, table name dot column name, SET, equal sign, new value 
D)  UPDATE, table name, SET, column name, equal sign, new value

Question 6

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)  SELECT* LEVEL1_CUSTOMER DROP TABLE;

Question 7

Which of the following commands executes a rollback?

Accepted Answer

A)  ROLLBACK TABLE; 
B)  ROLLBACK; 
C)  ROLLBACK ALL; 
D)  ROLLBACK UPDATE;

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

How do you use data from certain columns of an existing table to populate a new table with a matching structure?

Accepted Answer

A)  Place a SELECT command within an INSERT command. 
B)  Execute a CREATE TABLE command with an INSERT clause. 
C)  Copy the existing table and delete the unwanted columns. 
D)  Add an INSERT clause after the WHERE clause in a SELECT command.

Question 10

Which command can you use to create a new table using data in an existing table?

Accepted Answer

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

Question 11

Barney learns that the phone number for his friend Lacey in his ADDRESS_BOOK table has been disconnected; thus, her number is now unknown to him. Which SQL statement should Barney use to update the table so as to reflect this unknown value?

Accepted Answer

A)  SELECT PHONE_NO FROM ADDRESS_BOOK WHERE (NAME = 'Lacey') SET NULL; 
B)  ALTER ADDRESS_BOOK SET PHONE_NO = NULL WHERE (NAME = 'Lacey'); 
C)  UPDATE ADDRESS_BOOK SET PHONE_NO = 'NULL' WHERE (NAME = 'Lacey'); 
D)  UPDATE ADDRESS_BOOK SET PHONE_NO = NULL WHERE (NAME = 'Lacey');

Question 12

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

Accepted Answer

The answer of How can you use the COMMIT and...

Question 13

If you have not run the COMMIT command, you can reverse all updates made during the current work session by executing the _____.

Accepted Answer

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

Question 14

Which command should Josephine use if she would like to add a new row to the BMI table in MySQL?

Accepted Answer

A)  INSERT INTO BMI VALUES ('Emily', 'Cross', 66, 115); 
B)  UPDATE BMI SET ('Emily', 'Cross', 66, 115); 
C)  SELECT* FROM BMI INSERT ('Emily', 'Cross', 66, 115); 
D)  UPDATE BMI VALUES ('Emily', 'Cross', 66, 115);

Exam 6: Updating Data

Which is the correct sequence of elements in a command to remove rows from a MySQL table?

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

Changing a value in a table column to null is prohibited if, when you created the table, you specified _____.

The DROP TABLE command creates an empty table.

Which is the correct sequence of elements for a SQL command that will change a value in an existing table row?

Which of the following is a valid SQL command?

Which of the following commands executes a rollback?

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

How do you use data from certain columns of an existing table to populate a new table with a matching structure?

Which command can you use to create a new table using data in an existing table?

Barney learns that the phone number for his friend Lacey in his ADDRESS_BOOK table has been disconnected; thus, her number is now unknown to him. Which SQL statement should Barney use to update the table so as to reflect this unknown value?

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

If you have not run the COMMIT command, you can reverse all updates made during the current work session by executing the _____.

Which command should Josephine use if she would like to add a new row to the BMI table in MySQL?