inf3703 mcq exam type questions amp answers terminology
Connected book
Book Title:
Author(s):
Edition:
ISBN:
Edition:
Written for
University of South Africa (Unisa)
INF3703 - Databases II (INF3703)
All documents for this subject (52)
Seller
Follow
JayJo
Reviews received
Content preview
LIS3781 Exam 1
Study online at https://quizlet.com/_6ufmob
1. A transaction is a ____ unit of work that must be logical
either entirely completed or aborted.
2. A consistent database is ____. One in which all
data integrity con-
straints are satis-
fied
3. ____ requires that all operations of a transaction be atomicity
completed.
4. ____ means that data used during the execution of a isolation
transaction cannot be used by a second transaction
until the first one is completed.
5. All transactions must display ____. atomicity, durabil-
ity, consistency,
isolation, and seri-
alizability
6. A single-user database system automatically en- serializability and
sures ____ of the database, because only one trans- isolation
action is executed at a time.
7. The ANSI has defined standards that govern SQL COMMIT
database transactions. Transaction support is provid-
ed by two SQL statements: ____ and ROLLBACK.
8. ANSI defines four events that signal the end of a The end of a pro-
transaction. Of the following events, which is defined gram is success-
by ANSI as being equivalent to a COMMIT? fully reached.
9. ANSI defines four events that signal the end of a The program is
transaction. Of the following events, which is defined abnormally termi-
by ANSI as being equivalent to a ROLLBACK? nated.
10. The implicit beginning of a transaction is ____. (That When the first
is, according to the ANSI SQL standard, when does a SQL statement is
transaction begin?) encountered
, LIS3781 Exam 1
Study online at https://quizlet.com/_6ufmob
11. The information stored in the ____ is used by the transaction log
DBMS for a recovery requirement triggered by a
ROLLBACK statement, a program's abnormal termi-
nation, or a system failure such as a network discrep-
ancy or a disk crash.
12. One of the three most common data integrity and lost updates
consistency problems is ____.
13. As long as two transactions, T1 and T2, access ____ unrelated
data, there is no conflict, and the order of execution
is irrelevant to the final outcome.
14. A ____ lock prevents the use of any tables in the data- database-level
base from one transaction while another transaction
is being processed.
15. ____ are required to prevent another transaction from Locks
reading inconsistent data.
16. The ____ manager is responsible for assigning and Lock
policing the locks used by the transactions.
17. Lock ____ indicates the level of lock use. granularity
18. A ____ lock locks the entire table preventing access table-level
to any row by a transaction while another transaction
is using the table.
19. A ____ lock locks the entire diskpage. page-level
20. A ____ lock allows concurrent transactions to access row-level
different rows of the same table.
21. A system table space, a user data table space, an file groups
index table space, and a temporary table space are
examples of _____.
22. table space
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller JayJo. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $4.33. You're not tied to anything after your purchase.