OMIS 452 Final Exam Questions and
Answers
A transaction ____ indicates the starting & ending statement of a database
transaction. - 🧠 ANSWER ✔✔boundary
In a ____, all transactions come to a halt and remain at a standstill until one
of the transactions is aborted. - 🧠 ANSWER ✔✔deadlock
Which isolation level prevents dirty, non-repeatable, and phantom reads? -
🧠 ANSWER ✔✔serializable
The username & password for database in the configuration file of a web
app. is incorrect, so the web app. can't connect to the database. Which
failure scenario best describes this example? - 🧠 ANSWER ✔✔transaction
failure
, Refer to the Product table. Complete the SQL statement so the result table
shows 63, which is the total quantity of all products.
SELECT ______
FROM Product; - 🧠 ANSWER ✔✔SUM(Quantity)
Which SQL statement deletes the City column from the Supplier table? - 🧠
ANSWER ✔✔ALTER TABLE Supplier
DROP City;
Refer to the tables. The Product's Quantity column stores the stockroom's
product quantity before any products are sold. Which products are selected
by the query below?
SELECT ProductName
FROM Product P
WHERE Quantity >
(SELECT SUM(Quantity)
FROM Sales
Answers
A transaction ____ indicates the starting & ending statement of a database
transaction. - 🧠 ANSWER ✔✔boundary
In a ____, all transactions come to a halt and remain at a standstill until one
of the transactions is aborted. - 🧠 ANSWER ✔✔deadlock
Which isolation level prevents dirty, non-repeatable, and phantom reads? -
🧠 ANSWER ✔✔serializable
The username & password for database in the configuration file of a web
app. is incorrect, so the web app. can't connect to the database. Which
failure scenario best describes this example? - 🧠 ANSWER ✔✔transaction
failure
, Refer to the Product table. Complete the SQL statement so the result table
shows 63, which is the total quantity of all products.
SELECT ______
FROM Product; - 🧠 ANSWER ✔✔SUM(Quantity)
Which SQL statement deletes the City column from the Supplier table? - 🧠
ANSWER ✔✔ALTER TABLE Supplier
DROP City;
Refer to the tables. The Product's Quantity column stores the stockroom's
product quantity before any products are sold. Which products are selected
by the query below?
SELECT ProductName
FROM Product P
WHERE Quantity >
(SELECT SUM(Quantity)
FROM Sales
