CS403 Mid term Paper 2008

MIDTERM EXAMINATION
Fall 2008
CS403- Database Management Systems (Session - 2)
Time: 60 min
M a r k s: 38

Question No: 1    ( M a r k s: 1 )    http://vuzs.net
 Which of the following is not a benefit of normalization?
       ► Minimize insertion anomolies
       ► Minimize deletion anomolies
       ► Minimize updation anomolies
       ► Maximize redundancy
   
Question No: 2    ( M a r k s: 1 )    http://vuzs.net
 Which of the following is NOT a component of a DFD?
 
       ► Dataflow
 
       ► Datastore
 
       ► External entities
 
       ► Relationship between external entities
 
   
Question No: 3    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )    http://vuzs.net
 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    ( M a r k s: 1 )
 In which condition a relation in first normal form, automatically turns into the second normal form?
 
   
Question No: 18    ( M a r k s: 1 )
 State one limitation of Data flow diagrams
   
Question No: 19    ( M a r k s: 2 )
 What do you know about Insertion anomaly?
 
   
Question No: 20    ( M a r k s: 3 )
 What do you know about the conceptual view of database?
   
Question No: 21    ( M a r k s: 5 )
 Explain the purpose of defining processing rights for a database.
   
Question No: 22    ( M a r k s: 10 )
 Explain and differentiate between Context Level and Level 0 dataflow diagrams.

Leave a Reply

Related Posts Plugin for WordPress, Blogger...