CS403 MID TERM SOLVED MCQs || PAST PAPERS || GROUP-1 || DATABASE MANAGEMENT SYSTEM || VuTech
Visit Website For More Solutions
www.vutechofficial.blogspot.com
CS403
Database Management Systems
Solved Mid Term Past Papers
______________________________
MCQs
______________________________
Group-1
Question No: 1
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
Correct Answer:
The correct answer is 'b'.
CS 402 SOLVED MID TERM MCQs -----> Click Here
Question No: 2
Which of the following constraints enforces entity integrity?
a) PRIMARY KEY
b) FOREIGN KEY
c) CHECK
d) NOT NULL
Correct Answer:
The correct answer is 'd'.
Question No: 3
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
Correct Answer:
The correct answer is 'd'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 4
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
Correct Answer:
The correct answer is 'b'.
Question No: 5
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
Correct Answer:
The correct answer is 'a'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 6
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
Correct Answer:
The correct answer is 'c'.
Question No: 7
Select the correct statement about the ANSI/SPARC architecture.
a) The conceptual level is a level of indication 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, but it has only one external schemas.
d) The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.
Correct Answer:
The correct answer is 'a'.
Question No: 8
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 the keys from both the tables forming the composite primary key of the junction table
c) by splitting each table into three
d) as a single table and rarely as two tables with primary and foreign key relationships
Correct Answer:
The correct answer is 'a'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 9
Which of the following is not a benefit of normalization?
a) Minimize insertion anomolies
b) Minimize deletion anomolies
c) Minimize updation anomolies
d) Maximize redundancy
Correct Answer:
The correct answer is 'd'.
Question No: 10
The Entity Relation Model models
a) Entities, Relationships and Processes
b) Entities and Relationships
c) Relationships
d) Entities
Correct Answer: