Monday, May 7, 2012

CS403 Mid Term Past Paper




CS403 Mid Term Past Paper
MIDTERM  EXAMINATION
Fall 2008
CS403- Database Management Systems (Session - 2)
Ref No: 101305
Time: 60 min
Marks: 38
Student Info
 StudentID:
 
 Center:

 ExamDate:
  12/13/2008 12:00:00 AM

For Teacher's Use Only
    Q No.
1
2
3
4
5
6
7
8
Total
Marks









Q No.
9
10
11
12
13
14
15
16

Marks









Q No.
17
18
19
20
21
22



Marks













    
Question No: 1    ( Marks: 1 )    - Please choose one
 Which of the following is not a benefit of normalization?
       Minimize insertion anomolies
       Minimize deletion anomolies
       Minimize updation anomolies
       Maximize redundancy
   
Question No: 2    ( Marks: 1 )    - Please choose one
 Which of the following is NOT a component of a DFD?

       Dataflow

       Datastore

       External entities

       Relationship between external entities

   
Question No: 3    ( Marks: 1 )    - Please choose one
 Which of the following is correct regarding Dataflow diagram?

       Single DFD is required to represent a system

       The dataflow must be bidirectional

       Created at increasing levels of detail

              Used to represent the relationships among the external entities
   
Question No: 4    ( Marks: 1 )    - Please choose one
 Which of the following is CORRECT about database management system's languages?
       Data definition languages are used to specify the conceptual schema only.
       Data manipulation languages are used to create the databases.
       Data manipulation languages are used for retrieval, insertion, deletion and modification of data.
       Data definition langauges are only used to update data in the DBMS.
   
Question No: 5    ( Marks: 1 )    - Please choose one
 Controlling redundancy in a database management system DOES NOT help to
       avoid duplication

       avoid unnecessary wastage of storage space

       avoid unauthorised access to data

       avoid inconsistency among data

   
Question No: 6    ( Marks: 1 )    - Please choose one
 Which of the following concepts is applicable with respect to 3NF?
       Full functional dependency
       Any kind of dependency

       Transitive dependency
       Partial functional dependency

   
Question No: 7    ( Marks: 1 )    - Please choose one
 Consider two sets A and B. A contains 3 elements and B contains 4. How many elements do their cartesian product contains?
       12
       9
       16
       7
   
Question No: 8    ( Marks: 1 )    - Please choose one
 Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product contains?
       6
       9
       4
       5
   
Question No: 9    ( Marks: 1 )    - Please choose one
 In a conceptual database model, which of the following most likely represents a valid identifier for a class grades?
       StudentID
       StudentID, CourseID
       StudentID, CourseID, InstructorID
       StudentID, CourseSectionID
   
Question No: 10    ( Marks: 1 )    - Please choose one
 Identify the correct statement with respect to normalization.

       Normalization is a formal technique that can be used only at the starting phase of the database design.
       Normalization can be used as a top-down standalone database design technique.
       The process of normalization through decomposition must achieve the lossless join
property at any cost whereas the dependency reservation property is sometimes
sacrificed.

       The process of normalization through decomposition must achieve the dependency
reservation property at any cost whereas the lossless join property is sometimes
sacrificed.

   
Question No: 11    ( Marks: 1 )    - Please choose one
 Consider the following relation and its sample data. (Consider that these are the only tuples for the given relation)

Which of the following statements is NOT correct?

       The functional dependency DeptNo -> ProjNo holds over R.
       The functional dependency EmpNo -> DeptNo holds over R.
       The functional dependency ProjNo -> DeptNo holds over R.
       The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.
   
Question No: 12    ( Marks: 1 )    - Please choose one
 Which of the following is not true about relational tables?
        Column values are of the same kind.

       Each row is unique.

       Each column must have a unique name.

       The sequence of rows is significant.

   
Question No: 13    ( Marks: 1 )    - Please choose one
 Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

       Join
       Union
       Cartesian Product
       Set Difference
   
Question No: 14    ( Marks: 1 )    - Please choose one
 Consider the following statements.

A. An entity integrity constraint states that no primary key value can be null.
B. A referential integrity constraint is specified between two relations.
C. A foreign key cannot be used to refer to its own relation.

Identify which of the above statements is/are correct.

       Only A

       Only B

       Only B and C

        Only A and B

   
Question No: 15    ( Marks: 1 )    - Please choose one
 If K is a foreign key in relation R1, then
       every tuple of R1 has a distinct value for K.
       K cannot have a null value for tuples in R1.
       K is a  key for some other relation.
       K is a primary key for R1.
   
Question No: 16    ( Marks: 1 )    - Please choose one
 Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

       Physical data independence.
       Concurrency control.

       Logical data independence.
       Functional dependency
   
Question No: 17    ( Marks: 1 )
 In which condition a relation in first normal form, automatically turns into the second normal form?

   
Question No: 18    ( Marks: 1 )
 State one limitation of Data flow diagrams
   
Question No: 19    ( Marks: 2 )
 What do you know about Insertion anomaly?

   
Question No: 20    ( Marks: 3 )
 What do you know about the conceptual view of database?
   
Question No: 21    ( Marks: 5 )
 Explain the purpose of defining processing rights for a database.
   
Question No: 22    ( Marks: 10 )
 Explain and differentiate between Context Level and Level 0 dataflow diagrams.

Contact Form

Name

Email *

Message *