CS403 Short Notes

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

Q11. If W,X,Y and Z are attributes of a relation, which of the following inference rules for functional dependencies is correct?

•  If(X,Z)->Y then X->Y and Z-> Y
•  If X->Y and X->Z then X-> Y,Z

Q12. While recovering data, which of the following files does a recovery manager examines at first?

•  A system file
•  Log file pg303
•  Data dictionary
•  Metadata

13. The purpose of--- is to maintain the consistency of database during concurrent access.REP

•  Outer join
•  Inner join
•  Clustered index
•  Concurrency control pg310

14. Which of the following is the correct syntax for SELECT statement rep

•  SELECT column-name (s) FROM table name
•  SELECT FROM table-name column-name
•  FROM SELECT column-name table –name
•  FROM table-name SELECT column-name

15. -------- must identify a records in the table, uniquely REP

•  Hash Algorithm
•  Key pg260
•  SQL Statement
•  Index

16. ---- is an example of volatile memory REP

•  RAM
•  ROM
•  CPU