Database Qualifying Exam Spring 2016, Exams of Database Management Systems (DBMS)

The instructions and questions for the Database Qualifying Exam at the University of Wisconsin-Madison's Computer Sciences Department. The exam consists of five questions and students are required to answer each question in a separate book. The document also includes general instructions on how to label the answer books and specific instructions for each question. The first question is about ARIES and the second question asks for insights into the use of database systems.

Typology: Exams

2015/2016

Uploaded on 05/11/2023

anwesha
anwesha 🇺🇸

4.9

(12)

238 documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1
University of Wisconsin-Madison
Computer Sciences Department
Database Qualifying Exam
Spring 2016
GENERAL INSTRUCTIONS
Answer each question in a separate book.
Indicate on the cover of each book the area of the exam, your code number, and the
question answered in that book. On one of your books list the numbers of all the
questions answered. Return all answer books in the folder provided. Additional answer
books are available if needed.
Do not write your name on any answer book.
SPECIFIC INSTRUCTIONS
Answer all five (5) questions. Before beginning to answer a question make sure that you
read it carefully. If you are confused about what the question means, state any
assumptions that you have made in formulating your answer. Good luck!
The grade you will receive for each question will depend on both the correctness of your
answer and the quality of the writing of your answer.
Policy on misprints and ambiguities:
The Exam Committee tries to proofread the exam as carefully as possible. Nevertheless,
the exam sometimes contains misprints and ambiguities. If you are convinced a problem
has been stated incorrectly, mention this to the proctor. If necessary, the proctor can
contact a representative of the area to resolve problems during the first hour of the exam.
In any case, you should indicate your interpretation of the problem in your written
answer. Your interpretation should be such that the problem is nontrivial.
pf3
pf4

Partial preview of the text

Download Database Qualifying Exam Spring 2016 and more Exams Database Management Systems (DBMS) in PDF only on Docsity!

University of Wisconsin-Madison Computer Sciences Department Database Qualifying Exam Spring 2016 GENERAL INSTRUCTIONS Answer each question in a separate book. Indicate on the cover of each book the area of the exam, your code number, and the question answered in that book. On one of your books list the numbers of all the questions answered. Return all answer books in the folder provided. Additional answer books are available if needed. Do not write your name on any answer book. SPECIFIC INSTRUCTIONS Answer all five (5) questions. Before beginning to answer a question make sure that you read it carefully. If you are confused about what the question means, state any assumptions that you have made in formulating your answer. Good luck! The grade you will receive for each question will depend on both the correctness of your answer and the quality of the writing of your answer. Policy on misprints and ambiguities: The Exam Committee tries to proofread the exam as carefully as possible. Nevertheless, the exam sometimes contains misprints and ambiguities. If you are convinced a problem has been stated incorrectly, mention this to the proctor. If necessary, the proctor can contact a representative of the area to resolve problems during the first hour of the exam. In any case, you should indicate your interpretation of the problem in your written answer. Your interpretation should be such that the problem is nontrivial.

1. ARIES.

During the REDO pass, when we are deciding whether to redo the operation in a log record l for a page p , the claim is that we don't even have to check the pageLSN for p if p is not in the Dirty Page Table or if the page's recoveryLSN in the DPT is greater than the LSN of l. a) Why is this true? b) How is it even possible that we are considering an update log record for a page p but p is not in the DPT? c) Consider the three points in the log: i. the beginning of analysis phase, ii. the beginning of the REDO phase, iii. the earliest log record considered by the UNDO phase. Is it possible that they could appear, from earliest to latest, in the order (i), (ii), (iii)? Explain your answer.

2. Are DBMS Really Necessary? Many people who deal with a lot of data do not use database systems. Even scientists whose experiments produce vast quantities of data and analysts exploring huge amounts of customer data often avoid the use of database systems for storing their data, relying instead on file system files for the task. This trend seems to be getting worse, with the advent of NoSQL systems. This question asks you to give your insights into this issue. a. What database system factors do you believe most limit the use of database systems for data management? b. Do you believe the inclusion of Map-Reduce as an interface to DBMS (that is, allowing users to use generic Map-Reduce programs to access DBMS-resident data) will significantly increase the use of database technology? Why or why not? c. One could argue that NoSQL systems and relational systems are becoming more similar over time, that is, they are adopting more and more of each other’s

iii. q3(X,Y,Z) :- a(X,Y), b(U,Y), c(X,Z). b) Does the following recursive Datalog program have an equivalent conjunctive query? If your answer is yes, give an equivalent query; if your answer is no, argue (informally is fine) why it does not. t(X,Y) :- e(X,W), t(Z,Y). t(X,Y) :- e(X,Y).