CS403 Midterm Solved Subjective and Quiz Mega File

File Version Update: Dated(14-May-2011) · This version of file contains: ·  Content of the Course (Done)

•  FAQ updated version.(These must be read once because some very basic definition and question are being answered) (Done) Glossary updated version.(These must be read once because some very basic terms are being explained which you even might not found in the book) (Done)

Solved Past Assignment Selected for MID Term. (Done) · Solved Question From Mid-Term Papers (Done) · Solved MCQs From Mid-Term Papers · (Done) · 2 Current (Spring 2011)Solved Mid-Term Papers · (Done)

The file contains more than 700 MCQs from past Quizzes and Papers. They are provided in the end . Check Content for Details and quick jump, Use bookmark option in the pdf file .

----:Table of Content:----

FILE VERSION UPDATE: ....................................................................................................1

QUESTION: WHAT ARE MAJOR DIFFERENCES BETWEEN TRADITIONAL FILE PROCESSING SYSTEM AND DATABASE? ..............................................................................................................................4 QUESTION: WHAT IS THE DIFFERENCE BETWEEN DATA AND INFORMATION? ..........................................4 QUESTION: WHAT IS DATA CONSISTENCY? ......................................................................................4

Give at least 02 benefits of Normalization (02 Marks) .................................................................. 9

What is Data Definition Language (DDL) ? (02 Marks).................................................................. 9 What is data type? (02 Marks) ..................................................................................................... 9

MID-TERM PAST PAPERS (SOLVED VERSION) ...................................................................9

Q15. Give types of relations (02 Marks) ...................................................................... 9 UNARY RELATIONSHIP ................................................................................................................9

Q16. Briefly explain what is Partial Dependency (02 Marks) .................................... 10 DEPENDENCIES ....................................................................................................................... 10 THE PARTIAL DEPENDENCY: ....................................................................................................... 10 THE EXISTENCE DEPENDENCY: .................................................................................................. 10

IDENTIFIER DEPENDENCY: ........................................................................................................ 10 REFERENTIAL DEPENDENCY: ..................................................................................................... 10

Q17. Give at least 03 types of Anomalies which Normalization handles (03 Marks). 11

Q18. What is Data Definition Language (DDL) ? (03 Marks)DDL ............................... 11

Q19. Briefly explain what is a primary key and give example. (05 Marks) ............... 12

Q20. What are the benefits of using default values? (05 Marks)............................... 12 DEFAULT VALUE ...................................................................................................................... 12 RANGE CONTROL ..................................................................................................................... 12 NULL VALUE CONTROL ............................................................................................................. 13 REFERENTIAL INTEGRITY ........................................................................................................... 13 What is the degree of relation? ................................................................................................... 13 Name three kind of basic binary operation on relational algebra ............................................... 13 What is the data type ................................................................................................................. 13 What is the Cartesian product operation algebra. What is the result of Cartesian result product. ................................................................................................................................................... 13 Shortly describe Procedural DML and Non procedural DML also give the alternate names. ....... 14 For which purpose do we use relational data model? ................................................................ 14 What major problem can occur if we do not normalize a relation into the first normal form? ...... 15

In which situation do a recursive relationship exist? .................................................................. 15 What is DML (Data Manipulation Language)? ............................................................................ 15 What are the three important objectives for using data types while specifying attributes? ........ 15 Briefly explain super key in relation with primary key. .............................................................. 16 When is a functional dependency F said to be minimal? ............................................................ 16 What major problem can occur if we do not normalize a relation into the first normal form? ...... 16

Define domain of an attribute. .................................................................................................... 17 Label the following diagram ....................................................................................................... 17

What is the intersection operation in relational algebra? ............................................................ 17 INTERSECTION EXAMPLE ....................................................................................................... 18 Considering the above diagram, which of the given statements are True and which are False. 18 How to implement one-to-many relationship while designing tables? ........................................ 19 In which condition a relation in first normal form, automatically turns into the second normal form? .......................................................................................................................................... 19 State one limitation of Data flow diagrams: ............................................................................... 19 What do you know about the conceptual view of database? ...................................................... 19 CONCEPTUAL OR LOGICAL VIEW: ................................................................................................ 19 Explain the purpose of defining processing rights for a database. ............................................. 20 Explain and differentiate between Context Level and Level 0 dataflow diagrams. .................... 20 O CONTEXT DIAGRAM: .............................................................................................................. 20