MIS 315 - Final Exam || A+ Verified.
A View is a named SELECT statement that is stored in the database. correct answers true
Which of the following is a purpose for a View?
all of the above
to control access
to modularize database code
to simplify the data model for users correct answers all of the above
The name of a view can be very helpful in describing the SELECT statement. correct answers
true
A View can generally be used just like a table. correct answers true
A Stored Procedure is similar to a subroutine or function in other programming languages.
correct answers true
You cannot create a loop in a stored procedure. correct answers false
Stored Procedures are generally slower because they must be compiled each time they are
executed. correct answers false
In order for a user to run a stored procedure that does an INSERT on a table, the user must have
INSERT permissions on the table. correct answers true
All variables in Transact SQL must have a name that begins with "@". correct answers true
A stored procedure can have an OUTPUT parameter. correct answers true
Which of the ACID requirements of a transaction means that a transactions should be
indivisible?
A - atomic
C - consistent
D - durable
I - isolated correct answers A - Atomic
Which of the ACID requirements for a transaction means that the integrity of the database should
be maintained?
A - acid
C - consistent
D - durable
I - isolated correct answers C - Consistent
, Which of the ACID requirements for a transaction means that the concurrent transactions should
not affect each other?
A - acid
C - consistent
D - durable
I - isolated correct answers I - isolated
Which of the ACID requirements for a transaction means that the transaction should not be
affected by database failures that occur during the transaction.
A - acid
C - consistent
D - durable
I - isolated correct answers D - durable
A Checkpoint writes dirty pages from memory (RAM) to disk correct answers true
During the _________ phase of a transaction, all the locks necessary for the transaction are
obtained.
growing
shrinking correct answers growing
During the _____________ phase of a transaction, all the locks are given up.
growing
shrinking correct answers shrinking
Which of the following are data errors that can arise from concurrent transactions?
all of the above
dirty reads
lost updates
non-repeatable reads
phantom records correct answers all of the above
A transaction Isolation Level sets the tolerance for data errors for the transaction. correct answers
true
Locks are markers on resources that indicate that the resource is in use by a transaction. correct
answers true
The Recovery Point Objective (RPO) defines the point-in-time to which systems and data must
be recovered after an outage. correct answers true
A View is a named SELECT statement that is stored in the database. correct answers true
Which of the following is a purpose for a View?
all of the above
to control access
to modularize database code
to simplify the data model for users correct answers all of the above
The name of a view can be very helpful in describing the SELECT statement. correct answers
true
A View can generally be used just like a table. correct answers true
A Stored Procedure is similar to a subroutine or function in other programming languages.
correct answers true
You cannot create a loop in a stored procedure. correct answers false
Stored Procedures are generally slower because they must be compiled each time they are
executed. correct answers false
In order for a user to run a stored procedure that does an INSERT on a table, the user must have
INSERT permissions on the table. correct answers true
All variables in Transact SQL must have a name that begins with "@". correct answers true
A stored procedure can have an OUTPUT parameter. correct answers true
Which of the ACID requirements of a transaction means that a transactions should be
indivisible?
A - atomic
C - consistent
D - durable
I - isolated correct answers A - Atomic
Which of the ACID requirements for a transaction means that the integrity of the database should
be maintained?
A - acid
C - consistent
D - durable
I - isolated correct answers C - Consistent
, Which of the ACID requirements for a transaction means that the concurrent transactions should
not affect each other?
A - acid
C - consistent
D - durable
I - isolated correct answers I - isolated
Which of the ACID requirements for a transaction means that the transaction should not be
affected by database failures that occur during the transaction.
A - acid
C - consistent
D - durable
I - isolated correct answers D - durable
A Checkpoint writes dirty pages from memory (RAM) to disk correct answers true
During the _________ phase of a transaction, all the locks necessary for the transaction are
obtained.
growing
shrinking correct answers growing
During the _____________ phase of a transaction, all the locks are given up.
growing
shrinking correct answers shrinking
Which of the following are data errors that can arise from concurrent transactions?
all of the above
dirty reads
lost updates
non-repeatable reads
phantom records correct answers all of the above
A transaction Isolation Level sets the tolerance for data errors for the transaction. correct answers
true
Locks are markers on resources that indicate that the resource is in use by a transaction. correct
answers true
The Recovery Point Objective (RPO) defines the point-in-time to which systems and data must
be recovered after an outage. correct answers true
