CS403 Quiz 1 and Midterm by MCS

StuDocu is not sponsored or endorsed by any college or university

CS403 MCQs+Short + Improtant Topic BY Junaid

Database Management Systems (Virtual University of Pakistan)

StuDocu is not sponsored or endorsed by any college or university

CS403 MCQs+Short + Improtant Topic BY Junaid

Database Management Systems (Virtual University of Pakistan)

All MCQS are Correct If u found than correct by yourself

1. Hash partitioning is applied on-------

•  Rows GOOGLE
•  Columns
•  Constrains
•  Attributes

Q1. At which stage of database development process, the schema rules are defined and indentified?

•  Mapping of conceptual model to the logical model pg54
•  Analyzing user requirements
•  Development of the conceptual
•  Development of the physical design

2. Which of the following is INCORRECT about “Materialized Views”? rep

•  There are suitable in “Data warehouses”.
•  These are schema object which can be use to summaries the data
•  They cannot be partitioned Pg290
•  Their existence is transparent to SQL applications and users

3. Identify the incorrect statement among the given rep

•  An entity may be an object with physical existences like a car.
•  Age can be considered as a single values attributes of a person
•  The attribute Data_of_birth can be considered as a derived attribute
•  Skill is a multivalve attribute

4. ------ is used to manage the database and its Users

•  DBMS pg11
•  File processing system
•  DFD

5. A student has five courses at max registered in a semester and there are many student as well in a course .Student and entities have-----cardinality

•  One to One
•  One to Many
•  Many to One
•  Many to Many Pg94

6. Attributes on which we do not need to access the unique instances of an entity type is called.

pg84

•  Alternate key
•  Foreign key

7. In which of the following situations, Clustering is suitable.rep

•  Frequently up dating
•  Relatively static pg 192
•  Frequently deletion
•  Relatively dynamic

8. ----- is not a feature of hash access REP

•  Indexes to search or maintain
•  Very fast direct access
•  Inefficient sequential access
•  Use when direct access in needed ,but sequential access is not

Ye sare hash feature hai to VU walo ne ye MCQS wrong diya h to correct ansewer D hi hoga Phir

9. Minimal super key can also be named as pg82

•  Alternate key
•  Foreign key

10. Which of the following command shows from PRODUCT-VIEW rep

•  SELECT*FROM PRODUCT-VIEW
•  SELECT PRODUCT-VIEW
•  SHOW ALL PRODUCT-VIEW
•  PRODUCT-VIEW SELECT