Mid Term Question
CS201 MID TERM SOLVED MCQs || PAST PAPERS || GROUP-1 || INTRODUCTION TO PROGRAMMING || VuTech Visit Website For More Solutions www.vutechofficial.blogspot.com …
______________________________
______________________________
User rights information is stored in
a) Physical database
b) Catalog
c) Logical database
d) Buffer
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
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)
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
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
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.
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.
A collection of concepts that can be used to describe the structure of a database
a) Database
b) DBMS
c) Data model
d) Data
An entity can be logically connected to another by defining a .
a) Hyperlink
b) Common attribute
c) Primary key
d) Super key
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
About VuTech
Soratemplates is a blogger resources site is a provider of high quality blogger template with premium looking layout and robust design. The main mission of soratemplates is to provide the best quality blogger templates which are professionally designed and perfectlly seo optimized to deliver best result for your blog.
We provide Virtual University of Pakistan Study Materials such as Solution of Assignments, GDBs, Mid Term Solved Papers, Final Term Solved Papers, Mid Term Solved MCQs, and Final Term Solved MCQs. We also provide regular Semester Quizzes, Updated Handouts, and Short Questions and Answers. We help you with your research and many other educational-related topics, as far as we know. Furthermore, Share your problem with us and Please feel free to ask any related questions.
