Q#1: Which is not the function of Database Management System?
(A) A user accessible Catalog
(B) Concurrency Control Services
(C) Failure Response Service
(D) Support for Data Communication
Answer: (D) Support for Data Communication
Q#2: The conceptual database design can be transformed into any:
(A) Data model
(B) Database design
(C) E-R model
(D) Entity set
Answer: (A) Data model
Q#3: Which is the second stage in the database development process?
(A) Database design
(B) Preliminary Study
(C) Physical Design
(D) Requirement Analysis
Answer: (B) Preliminary Study
Q#4: Functional dependencies under interference rule reflexivity are called dependencies.
(A) Augmentation
(B) Transitivity
(C) Projectivity
(D) Trivial
Answer: (D) Trivial
Q#5: If many instances of the “Book” entity are associated with the many instances of the “Student” entity, then the relationship between them is:
(A) One to one
(B) One to many
(C) Many to many
(D) Many to one
Answer: (C) Many to many
Q#6: Which of the following constraints enforces entity integrity?
(A) PRIMARY KEY
(B) FOREIGN KEY
(C) CHECK
(D) NOT NULL
Answer: (A) PRIMARY KEY
Q#7: Unary operations involve:
(A) Only one relation
(B) Only two relations
(C) More than two relations
(D) Not more than five relations
Answer: (A) Only one relation
Q#8: A entity has a primary key that is partially or totally derived from the parent entity in the relationship.
(A) Strong
(B) Weak
(C) Business
(D) Relationship
Answer: (B) Weak
Q#9: In appropriate data model is chosen.
(A) ERD
(B) Conceptual Database Design
(C) Logical Database Design
(D) DFA
Answer: (C) Logical Database Design
Q#10: Which of the following is drawback of standardization?
(A) Difficult to understand
(B) Uniformity
(C) Lack of uniqueness
(D) Easy to develop applications
Answer: (A) Difficult to understand
Q#11: Recursive relationship is also called:
(A) Unary
(B) Ternary
(C) Primary
(D) Secondary
Answer: (A) Unary
Q#12: The foreign key attribute, which is present as a primary key in another relation is called as ______ of the foreign key attribute.
(A) Binary relation
(B) Composite relation
(C) Home relation
(D) Recursive relation
Answer: (C) Home relation
Q#13: DFD does not provide us a way to represent:
(A) Entities
(B) Decisions
(C) Data stores
(D) Processes
Answer: (B) Decisions
Q#14: A ______ is used to maintain a connection between the users of the database system.
(A) Virtual server
(B) File server
(C) Client server
(D) FTP server
Answer: (C) Client server
Q#15: Which of the following is an advantage of using the Traditional File Organization?
(A) Time consuming
(B) Data security
(C) Simplicity
(D) Efficiency
Answer: (C) Simplicity
Q#16: Which of the following is the input to Analysis Phase?
(A) DFD
(B) Logical database design
(C) Physical database design
(D) Data model
Answer: (A) DFD
Q#17: Name and ______ are part of the definitions of an attribute.
(A) Domain
(B) Symbol
(C) Property
(D) Entity instance
Answer: (A) Domain
Q#18: Which of the following most certainly implies the need for an entire table to implement?
(A) A ternary relationship
(B) A recursive relationship
(C) An identify relationship
(D) A binary relationship
Answer: (A) A ternary relationship
Q#19: Core of the Database Architecture is:
(A) Internal level
(B) External level
(C) Conceptual level
(D) ANSI SPARK
Answer: (C) Conceptual level
Q#20: ______ is same as equi-join with a slight difference.
(A) Natural join
(B) Semi join
(C) Outer join
(D) Theta join
Answer: (A) Natural join