CS
cs2203 Quiz Review.docx

cs2203 Quiz Review.docx - Question 1 Correct Mark 1.00 out...

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

Question 1 Correct Mark 1.00 out of 1.00 Not flaggedFlag question Question text A foreign key must always be a candidate key. Select one: True False Correct Feedback The correct answer is 'False'. Question 2 Correct Mark 1.00 out of 1.00 Not flaggedFlag question Question text An information model is an abstract, formal representation of entities that includes their properties, relationships and the operations that can be performed on them. Select one: True Correct False Feedback The correct answer is 'True'. Question 3 Correct Mark 1.00 out of 1.00 Not flaggedFlag question Question text A characteristic of data, a real-world data feature modeled in the database is called:
Image of page 1

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

Select one: a. attribute Correct b. cell c. column d. value Feedback The correct answer is: attribute Question 4 Correct Mark 1.00 out of 1.00 Not flaggedFlag question Question text A database management system (DBMS) allows you to specify the logical organization for a database and access and use the information within a database. Select one: True Correct False Feedback The correct answer is 'True'. Question 5 Incorrect Mark 0.00 out of 1.00 Not flaggedFlag question Question text Which of the following is NOT an information model? Select one: a. pureXML model b. Relational Model c. Hierarchial model
Image of page 2
d. Network model Incorrect Feedback The correct answer is: pureXML model Question 6 Correct Mark 1.00 out of 1.00 Not flaggedFlag question Question text A unique KEY field Select one: a. Is a special field that each database has to have. b. Is a special field that identifies a particular record in a database c. Is a special field that identifies a particular record in a data table Correct d. is a special field that has to be a unique number Feedback The correct answer is: Is a special field that identifies a particular record in a data table Question 7 Correct Mark 1.00 out of 1.00 Not flaggedFlag question Question text A candidate key cannot also be the primary key of a relation. Select one: True False Correct Feedback The correct answer is 'False'. Question 8 Incorrect
Image of page 3

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

Mark 0.00 out of 1.00 Not flaggedFlag question Question text The surrogate key provides a unique alternate for using a foreign key that is used to save space. Select one: True Incorrect False Feedback The correct answer is 'False'. Question 9 Correct Mark 1.00 out of 1.00 Not flaggedFlag question Question text The number of attributes in a relation is known as: Select one: a. The relation degree Correct b. The relation cardinality c. The relation domain d. The relation schema Feedback The correct answer is: The relation degree Question 10 Correct Mark 1.00 out of 1.00 Not flaggedFlag question Question text A formal description of all the database relations and all of the relationships existing between them is called a database schema.
Image of page 4
Select one: True Correct False Feedback The correct answer is 'True'.
Image of page 5

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

Image of page 6
This is the end of the preview. Sign up to access the rest of the document.
  • Winter '17
  • Final Test Review, Relational model, Database normalization

{[ 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