Solved MCQs From Midterm Papers
Q#1: Which of the following is NOT a feature of Context DFD?
(A) One process (which represents the entire system)
(B) All sources/sinks (external entities)
(C) Data flows linking the process to the sources and sinks
(D) Sub-processes (which explain and decompose the major process)
Answer: (D) Sub-processes (which explain and decompose the major process)
Q#2: Which of the following is true for the relational model?
(A) Degree of a relation is the number of rows in a relation
(B) Null value is a blank or zero value given to an attribute value when its value is unknown
(C) Complex key is a key consisting of more than one attribute
(D) Constraint is a rule that restricts the values in a database
Answer: (D) Constraint is a rule that restricts the values in a database
Q#3: Which of the following most certainly implies the need for an entire table to implement?
(A) A binary relationship
(B) A ternary relationship
(C) A recursive relationship
(D) An identifying relationship
Answer: (B) A ternary relationship
Q#4: Which of the following constraints enforces entity integrity?
(A) PRIMARY KEY
(B) FOREIGN KEY
(C) CHECK
(D) NOT NULL
Answer: (A) PRIMARY KEY
Q#5: Which of the following is NOT true about relational tables?
(A) Column values are of the same kind
(B) Each row is unique
(C) Each column must have a unique name
(D) The sequence of rows is significant
Answer: (D) The sequence of rows is significant
Q#6: In a conceptual model for a university, what type of relationship exists between Grade and Student entities?
(A) 1:1
(B) 1:M
(C) M:M
(D) Ternary
Answer: (B) 1:M
Q#7: Controlling redundancy in a database management system DOES NOT help to:
(A) Avoid duplication
(B) Avoid unnecessary wastage of storage space
(C) Avoid unauthorized access to data
(D) Avoid inconsistency among data
Answer: (C) Avoid unauthorized access to data
Q#8: Which of the following functions are NOT performed by a database administrator?
(A) Planning, designing and implementing database systems
(B) Establishing standards and procedures for database systems
(C) Communicating with database users
(D) Allocation of storage locations and data structures
Answer: (C) Communicating with database users
Q#9: Select the correct statement about the ANSI/SPARC architecture.
(A) The conceptual level is a level between the internal level and the external level
(B) The internal level in a database system will definitely be relational
(C) Any given database has many conceptual schemas and one physical schema
(D) The external level is not concerned with user perceptions
Answer: (A) The conceptual level is a level between the internal level and the external level
Q#10: Which of the following is a correct way to implement one-to-many relationship while designing tables?
(A) By splitting the data into two tables with primary key and foreign key relationships
(B) Using a junction table with composite primary key
(C) By splitting each table into three
(D) As a single table
Answer: (A) By splitting the data into two tables with primary key and foreign key relationships
Q#11: Which of the following is not a benefit of normalization?
(A) Minimize insertion anomalies
(B) Minimize deletion anomalies
(C) Minimize update anomalies
(D) Maximize redundancy
Answer: (D) Maximize redundancy
Q#12: The Entity Relation Model models:
(A) Entities, Relationships and Processes
(B) Entities and Relationships
(C) Relationships
(D) Entities
Answer: (B) Entities and Relationships
Q#13: User rights information is stored in:
(A) Physical database
(B) Catalog
(C) Logical database
(D) Buffer
Answer: (B) Catalog
Q#14: Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of:
(A) Physical data independence
(B) Concurrency control
(C) Logical data independence
(D) Functional dependency
Answer: (C) Logical data independence
Q#15: A collection of concepts that can be used to describe the structure of a database is called:
(A) Database
(B) DBMS
(C) Data model
(D) Data
Answer: (C) Data model
Q#16: Database management systems, operating systems, applications and utilities are examples of:
(A) Hardware
(B) Software
(C) Computer infrastructure
(D) Input and output
Answer: (B) Software