DBST Fall 2009 Final Exam WebTycho

DBST Fall 2009 Final Exam WebTycho - DBST 651 Final...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
DBST 651   Final Examination – Fall 2009  Name:                     Date: 1. Final exam is due no later than end of  Sunday December 6, 2009 11:59 PM EST. 2. Late submission - 10% penalty per day late up to five days after which zero credit is given. 3. This is an online (take-home) exam, there should not be any sort of interaction or collaboration  with class members in completing the exam 4. Originality and depth of analysis will be considered for grading 5. Responses should be well within the limits specified for each response 6. Make sure you make note for all your assumptions (if any) and show all steps in completing  your work.  7. Your responses should be submitted as a word document with filename including your first  initial of your first name and last name formatted – example PMentaFinal.doc and post the file  as an attachment in assignment folder for midterm exam. Please sign the following statement: Independent Work Statement I solemnly affirm, acknowledge and certify that my responses to this examination were completed without any contact with other persons during or before the examination. I pledge on my honor that I have not given or received any assistance on this examination and certify that the enclosed responses are solely my own work. Signed _____________________________ Date_______________________ PRINTED NAME___________________ Course __________________ Good Luck
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Part A (50 Points) Multiple Choice Questions Submit your responses to PART A in the following format: Q no: Response 1 2 3 4 1. When adding historical details to a relationship, typically the 1-M relationship is converted to an M-N relationship with an attribute. True False 2. In simple conditions, only rows in which the condition evaluates to false are excluded from the result set. True False 3. When null values exist in one of the columns in a simple condition, it is possible that those rows will not appear in the result of either the simple condition or its negation. True False 4. Julia has a shared lock on the savings account and Bill is trying to perform an action requesting an exclusive lock on the same data: A. Bill's transaction is granted permission to perform the desired action and Julia's transaction must now wait B. Bill's transaction must wait until Julia's lock is released C. Bill's transaction must wait until Julia has read the savings account value D. None of the above
Background image of page 2
5. Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the immediate update mode. The transaction terminates abnormally after 10 rows have been
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

DBST Fall 2009 Final Exam WebTycho - DBST 651 Final...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online