Ilovejesseduong, COSC 3380 Exam 4 With
Questions And Answers Latest Update 2026
Refer to the animation above and match the
conflict type with the corresponding
transactions.
T1 reads salaries of some Accounting
department employees
T2 transfers Maria Rodriguez from Accounting
to Development Phantom read
T2 commits
T1 reads salaries of remaining Accounting
employees
T1 computes and writes total salary of
Accounting employees
T1 commits
Initial values: X = 2, Y = 8, Z = 0
conflicting
B and C are schedules
If user needs to know only average department
salaries for the Toy and CS departments, which
View
one should be used: the table or one of the
views?
Assume existence of user Assistant Manager
assistant. What privilege should you grant to
assistant who needs to know only average SELECT
department salaries? Express it in proper SQL.
GRANT ON Deptinfo TO assistant
Consider the following Schedule:
S = [R1(Z), W2(X), R2(Z), R2(Y), W1(X), W3(Z),
W1(Y), R3(X)]
YES
where Ri(Z)/Wi(Z) indicates a read/write by
transaction i on data item Z.
Is the Schedule Serializable.
, Execute each schedule and complete the given
statements.
equivalent
Initial vales: X = 2, Y = 8, Z = 0.
A and B are Schedules.
Verifying the identity of a user is called authentication
After a rollback, the database restarts a
Sometimes
transaction
When a failure occurs, the database is notified
False
and attempts to restart the transaction.
Select transaction's 5 isolation level READ UNCOMMITED
In the refined two-phase locking protocol, lock
during the growing phase
upgrading can take place
Procedures that monitor actions such as
changes to the database and cause an action to triggers
be taken when certain conditions arise are called
A bank stores checking account data in a
database. The bank stores account owner data
in a file on a different computer. A database
transaction creates a new owner in the file and
assigns the owner to a checking account in the False
database.
True/False
The transaction is always consistent.
The database restarts a transaction that was
False
explicitly rolled back by a user command.
A database administrator creates a MySQL
statement with incorrect syntax. What does
Error code
MySQL Workbench display when the statement
is executed?
In an online bank application that transfers
funds from a checking account to a savings
account, the property ensures that the durability
changes made to each account will not be lost
due to a computer failure.
In an online bank application that transfers atomicity
funds from a checking account to a savings
account, if a debit is made successfully from the
checking account, the property ensures
Questions And Answers Latest Update 2026
Refer to the animation above and match the
conflict type with the corresponding
transactions.
T1 reads salaries of some Accounting
department employees
T2 transfers Maria Rodriguez from Accounting
to Development Phantom read
T2 commits
T1 reads salaries of remaining Accounting
employees
T1 computes and writes total salary of
Accounting employees
T1 commits
Initial values: X = 2, Y = 8, Z = 0
conflicting
B and C are schedules
If user needs to know only average department
salaries for the Toy and CS departments, which
View
one should be used: the table or one of the
views?
Assume existence of user Assistant Manager
assistant. What privilege should you grant to
assistant who needs to know only average SELECT
department salaries? Express it in proper SQL.
GRANT ON Deptinfo TO assistant
Consider the following Schedule:
S = [R1(Z), W2(X), R2(Z), R2(Y), W1(X), W3(Z),
W1(Y), R3(X)]
YES
where Ri(Z)/Wi(Z) indicates a read/write by
transaction i on data item Z.
Is the Schedule Serializable.
, Execute each schedule and complete the given
statements.
equivalent
Initial vales: X = 2, Y = 8, Z = 0.
A and B are Schedules.
Verifying the identity of a user is called authentication
After a rollback, the database restarts a
Sometimes
transaction
When a failure occurs, the database is notified
False
and attempts to restart the transaction.
Select transaction's 5 isolation level READ UNCOMMITED
In the refined two-phase locking protocol, lock
during the growing phase
upgrading can take place
Procedures that monitor actions such as
changes to the database and cause an action to triggers
be taken when certain conditions arise are called
A bank stores checking account data in a
database. The bank stores account owner data
in a file on a different computer. A database
transaction creates a new owner in the file and
assigns the owner to a checking account in the False
database.
True/False
The transaction is always consistent.
The database restarts a transaction that was
False
explicitly rolled back by a user command.
A database administrator creates a MySQL
statement with incorrect syntax. What does
Error code
MySQL Workbench display when the statement
is executed?
In an online bank application that transfers
funds from a checking account to a savings
account, the property ensures that the durability
changes made to each account will not be lost
due to a computer failure.
In an online bank application that transfers atomicity
funds from a checking account to a savings
account, if a debit is made successfully from the
checking account, the property ensures
