Final_CMPS180_Winter2018_MultipleChoice_A.pdf - CMPS 180...

Info icon This preview shows pages 1–3. Sign up to view the full content.

CMPS 180, Final Exam, Winter 2018, Shel Finkelstein Multiple Choice Questions (Part I) Answered on Scantron Sheet Test Form letter: A This first Section (Part I) of the Winter 2018 CMPS 180 Final is multiple choice and is double-sided. Answer all multiple choice questions on your Scantron sheet. You do not have to hand in this first Section of the Exam, but you must hand in the Scantron sheet, with your Name, email and Student ID on that Scantron sheet. Please be sure to use a #2 pencil to mark your choices on this Section of the Final. Name and Student ID must also be filled in by shading letters/numbers on the form. You must also mark the version (“Test Form letter A ”) of the Final th at you took. The box for Test Form letter is at the top of the Scantron sheet, just to the left of the multiple choice questions. The separate second Section (Parts II and III) of the Final is not multiple choice and is single-sided, so that you have extra space to write your answers. If you use that extra space, please be sure to write the number of the problem that you’re solving next to your answer. Please write your name, email and student id on the second Section of the Exam, which you must hand in. You may use any writing implement on this Section of the Exam. At the end of the Final, please be sure to hand in both your Scantron sheet for this first Section of the Exam and also the separate second Section of the Exam, and show your UCSC id when you hand them in.
Image of page 1

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

Part I: (40 points, 2 points each) Answer the questions in Part I on your Scantron sheets, which should have your name, email and UCSC id on them. Select the best answer for each of the following. For some questions, a choice is “All of the above , so read answer choices carefully. Question 1: The relational model has logical independence. Which of the following illustrates logical independence” for the relational model? a) When you write queries, you don’t have to know how the tables used are stored, or what indexes exist. b) If you change what’s a table and what’s a view, then your queries will still work. c) You can port a Relational Database System on different hardware and operating systems and it will still run. d) You can also write your queries using a Navigational Model, with links. e) None of the above. Question 2: Let R(A,B,C,D) be a relation, where (A, B) is the Primary Key for R, Attribute C is Unique and can be NULL, and attribute D is Unique but cannot be NULL. Attribute A’s domain has 9 di fferent values, B’s domain has 4 different values, C’s domain has 2 different values, and D’s domain has 7 different values. What is the maximum number of different tuples that can be in an instance of R? a) 2 b) 3 c) 7 d) 13 e) 36 Question 3: We discussed ACID properties of transactions. What does Consistency (the “C” in ACID) mean for transactions?
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.
  • Winter '08
  • Polyzotis,N
  • Scantron Sheet, Relational model, relation, lossless join decomposition

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern