Question 1
2 / 2 pts
(TCO C) When a COMMIT has been issued, which of the following have been released?

All memory holds on the data have been released.
All data changes since the previous commit are saved and available to other users.
All changes are discarded.
All changes to the last savepoint are available to other users.

Chapter 2, page 158
Question 2
2 / 2 pts
(TCO C) A ROLLBACK statement allows you to bring the state of the tables to the state as of _.
the first COMMIT.
the last COMMIT.
the last UPDATE.
the first UPDATE.
Chapter 2, page 158

Question 3
2 / 2 pts
(TCO D) If you want to see how a table was created, which command would you issue?
SHOW TABLES;
USE TABLE Table_Name;
SHOW CREATE TABLE Table_Name
SHOW CREATE DATABASE Table_Name
Appendix E, page 972

Question 4
0 / 2 pts
(TCO D) Which statement would you use to remove the EMPLOYEE_ID_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
ALTER TABLE employee
DROP PRIMARY KEY;

ALTER TABLE employee
DELETE PRIMARY KEY CASCADE;

MODIFY TABLE employee
DROP CONSTRAINT employee_id_pk CASCADE;

ALTER TABLE employee
DROP PRIMARY KEY employee_id_pk CASCADE;

MODIFY TABLE employee
DELETE PRIMARY KEY employee_id_pk CASCADE;
Chapter 2, page 127

Question 5
2 / 2 pts
(TCO D) Which integrity constraint type states that a foreign key value in the EMP table must match a primary key value in the DEPT table or be NULL?

Entity

Column

Referential

User-defined
Chapter 2, page 166

Question 6
2 / 2 pts
(TCO D) Which phrase creates an index on a column?

CREATE INDEX

ALTER INDEX

DROP INDEX

DELETE INDEX
Chapter 2, page 124

Question 7
0 / 2 pts
TCO D) Given this script:
;
START TRANSACTION;
INSERT INTO employee(salary, last_name, first_name)
VALUES(35000, ‘Wagner’, ‘Madeline’);
SAVEPOINT save_a;
INSERT INTO employee(salary, last_name, first_name)
VALUES(40000, ‘Southall’, ‘David’);
SAVEPOINT save_b;
DELETE FROM employee
WHERE dept_no = 10;
SAVEPOINT save_c;
INSERT INTO employee(salary, last_name, first_name)
VALUES(25000, ‘Brown’, ‘Bert’);
ROLLBACK TO SAVEPOINT save_c;
INSERT INTO employee(salary, last_name, first_name)
VALUE(32000, ‘Dean’, ‘Mike’);
ROLLBACK TO SAVEPOINT save_a;
COMMIT;
END;
Which change to the database will be made permanent?

DELETE FROM employee WHERE dept_no = 10;

INSERT INTO employee(salary, last_name, first_name) VALUE(32000, ‘Dean’, ‘Mike’);

INSERT INTO employee(salary, last_name, first_name) VALUES(25000, ‘Brown’, ‘Bert’);

INSERT INTO employee(salary, last_name, first_name) VALUES(40000, ‘Southall’, ‘David’);

INSERT INTO employee(salary, last_name, first_name) VALUES(35000, ‘Wagner’, ‘Madeline’);
Chapter 2. Page 161.

Question 8
7 / 7 pts
(TCO D) Provide the definition of integrity constraints.

Question 9
7 / 7 pts
(TCO D) Explain how to use COMMIT within MySQL transaction.

Question 10
7 / 7 pts
(TCO D) What statement will allow a partial rollback of certain DML statements within a transaction?

Question 11
7 / 7 pts
Explain the ACID properties of SQL transactions.

Question 12
8 / 8 pts
(TCO D) What is the difference between table and view?

Please click on the “PURCHASE” link below to get “MIS562 Week 4 Quiz A+ Solution”.

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on ekmtutor@gmail.com.

Leave a Comment