CS403 MID TERM SOLVED MCQs || PAST PAPERS || GROUP-2 || DATABASE MANAGEMENT SYSTEM || VuTech
Visit Website For More Solutions
www.vutechofficial.blogspot.com
CS403
Database Management Systems
Solved Mid Term Past Papers
______________________________
MCQs
______________________________
Group-2
Question No: 1
User rights information is stored in
a) Physical database
b) Catalog
c) Logical database
d) Buffer
Correct Answer:
The correct answer is 'b'.
CS 403 SOLVED MID TERM MCQs -----> Click Here
Question No: 2
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
Correct Answer:
The correct answer is 'c'.
Question No: 3
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 (external entities)
d) Sub-Processes (which explain and decomposed the major process into small processes)
Correct Answer:
The correct answer is 'd'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 4
A relation (from the relational database model) consists of a set of tuples, which implies that
a) All tuples in a relation must be distinct
b) Relational model supports multi-valued attributes whose values can be represented in sets
c) For any two tuples, the values associated with all of their attributes may be the same
d) All tuples in a particular relation may have different attributes
Correct Answer:
The correct answer is 'a'.
Question No: 5
Identify the correct statement with respect to normalization
a) Normalization is a formal technique that can be used only at the starting phase of the database design
b) Normalization can be used as a top-down standalone database design technique
c) The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed
d) The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed
Correct Answer:
The correct answer is 'b'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 6
Identify the INCORRECT statement among the given.
a) An entity may be an object with a physical existence like a car, a house or an Employee
b) One cannot consider something which has conceptual existence like a course in a degree program as an entity.
c) Age can be considered as a single value attribute of a person.
d) An entity type describes the schema or intension for a set of entities which share the same structure.
Correct Answer:
The correct answer is 'b'.
Question No: 7
Structural constraints of a relationship type refer to
a) Identifying the owner entity type relevant to a given entity type
b) Whether the existence of an entity depends on it being related to another entity via the relationship type.
c) The role that a participating entity from the entity type plays in each relationship instance.
d) The constraints applicable in granting access to tables, columns and views in a database schema.
Correct Answer:
The correct answer is 'b'.
Question No: 8
A collection of concepts that can be used to describe the structure of a database
a) Database
b) DBMS
c) Data model
d) Data
Correct Answer:
The correct answer is 'c'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 9
An entity can be logically connected to another by defining a .
a) Hyperlink
b) Common attribute
c) Primary key
d) Super key
Correct Answer:
The correct answer is 'b'.
Question No: 10
The ______ constraint specifies whether each entity super type occurrence must also be a member of at least one subtype.
a) Specialization
b) Uniqueness
c) Inheritance
d) Completeness
Correct Answer: