Graded QUIZ UNIT 3 (CS 2203) PDF

Preview

Summary

Do well to like and comment....

Description

GRADED QUIZ UNIT 3 (CS 2203) 1. A pool of atomic values constitutes a domain. Select one: True (Correct) False The correct answer is 'True'. 2. The address of a student can be defined using street, city, state, and zip code. What type of attribute should be used to represent the address of a student? Select one: a. Single valued attribute b. Multi-valued attribute c. Composite attribute Correct d. Derived attribute The correct answer is: Composite attribute 3. What does “a named column of a relation” refer to? Select one: a. Relation b. Tuple c. Attribute (Correct) d. Domain The correct answer is: Attribute 4. A Database Administrator is responsible for developing logical data model. Select one: True False The correct answer is 'False' 5. For the relationship represented in the figure below, which of the following is wrong? Select one: teaches course instructor a. A course has to be taught by one instructor b. An instructor does not have to teach any course. c. A course can be taught by more than one instructor. (Correct) d. An instructor can teach more than one course. The correct answer is: A course can be taught by more than one instructor. 6. Which of the following statements is wrong? Select one: a. All the values in any column must be of the same type. b. The E-R model is used to build a conceptual model. c. It is not a good practice to use a surrogate key. d. A relation is a one-dimensional table. The correct answer is: A relation is a one-dimensional table. 7. Considering the below E-R diagram. Which of the following statements is wrong? Select one:

a. A sale can only be sold by one store. b. A customer may not buy anything. c. A customer can buy many times. d. An item can be sold many times The correct answer is: An item can be sold many times. 8. In an Entity-Relationship model, which concept is generally used to represent the name of an instructor? Select one: a. Constraint b. Attribute c. Entity d. Relationship set The correct answer is: Attribute 9. What is the Primary Key of this table? Select one: EmpID Budget ProjectID Hours S75 S75 S79 S79 S80

32 40 32 27 40

P1 P2 P1 P3 P2

7 3 4 1 5

a. ProjectID, Budget b. ProjectID c. EmpID, ProjectID (Correct) d. EmpID The correct answer is: EmpID, ProjectID 10. Which of the following statements is wrong? Select one:

11.

12.

13.

14.

15.

a. A relational database can be defined as a self-describing collection of non-integrated relations. Correct b. Physical model includes the lowest level of abstractions c. A relational database stores data in the form of relations. d. Both the primary key and a candidate key can uniquely identify the tuples in a relation. The correct answer is: A relational database can be defined as a self-describing collection of non-integrated relations. Which of the following is true about a relation? Select one: a. The order of the tuples of a relation is determined by the primary key Incorrect b. All the values in any column must be of the same type. c. There is a single attribute in each relation d. A relation is a one-dimensional table The correct answer is: All the values in any column must be of the same type. Which of the following statements is correct? Select one: a. A relation is in the first normal form if it has no more than one multivalued attribute. b. A surrogate key is an attribute or set of attributes that uniquely identifies a record in a relation c. There is a single attribute in each relation d. Two or more attributes can be defined on the same domain. The correct answer is: Two or more attributes can be defined on the same domain. Which of the following is wrong about the functional dependency A → (B, C, D)? Select one: a. B, C, and D together determine A Correct b. A determines D. c. B, C, and D are functionally dependent on A d. C is functionally dependent on A. The correct answer is: B, C, and D together determine A A primary key of a relation should be part of every other relation to provide referential integrity. Select one: True False The correct answer is 'False' Considering the below dependency diagram. Which of the following statements is wrong? elect one:

a. Title and PublYear were dependent on BookID ( Correct) b. Primary key: BookID, CopyNr and Author c. Candidate key: ISBN, CopyNr and Author d. AuthorBornYear was dependent on Author The correct answer is: Title and PublYear were dependent on BookID...