12-04-2010, 03:43 PM
MIDTERM EXAMINATION
Spring 2010
CS403- Database Management Systems (Session - 4)
Time: 60 min
Marks: 38
Question No: 1 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] A database system allows the following EXCEPT
► management and control of data towards an efficient working of an organisation.
► more critical functions in organisations to be computerised and the need to keep a large
volume of data available in an up to the minute current state increased.
► any user to access all its data.
► integration of data across multiple applications into a single application.
Question No: 2 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] User rights information is stored in
► Physical database
► Catalog
► Logical database
► Buffer
Question No: 3 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] The ER- data model is an example of:
► Physical database
► Logical database
► Relational database
► Conceptual database
Question No: 4 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Which of the following is true about NOT NULL constraint?
► enforce domain integrity
► limit the values that can be placed in a column.
► prevents any actions that would destroy links between tables with the
corresponding data values
► enforces the uniqueness of the values in a set of columns
Question No: 5 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo)
and the following functional dependencies.
FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo
FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo
FD3 : StaffNo, InterviewDate -> RoomNo
Which of the following is correct?
► The relation Interview is in BCNF.
► The FD3 violates 3NF.
► The FD3 violates BCNF.
► The FD2 violates 2NF.
Question No: 6 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Consider the following diagram depicting a kind of a relationship type where X and Z are entities and Y is a relationship type:
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image004.gif[/IMG]
Select the correct statement among the following on the above diagram.
► The relationship type Y is of cardinality ratio 1 : N.
► The diagram depicts existence dependencies.
► The participation of X in the Y relationship type is total.
► The participation of Z in the Y relationship type is partial.
Question No: 7 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Select the correct statement among the following.
► Role names are not technically necessary in relationship types when all the participating entity types are distinct.
► When different entity types participate only once in a single relationship type it is called a recursive relationship.
► Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by
using a diamond shape notation.
► Partial participation which is also called existence dependency is displayed as a double line
connecting the participating entity type to the relationship.
Question No: 8 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Which of the following is true about relational schema?
► The sequence of columns is significant
► The sequence of rows is significant.
► Contains only derived attributes.
► Values are atomic.
Question No: 9 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Consider the given relations Student and Instructor as given below.Please note that
Fname and Lname also denote the First Name and Last Name respectively.
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image006.gif[/IMG]
Which of the following statements is correct with respect to the two relations given above?
► The two relations are not union-compatible since their attribute names differ.
► The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these
two relations.
► To find out those students who work as instructors, it is necessary to perform the operation
Student ∩ Instructor.
► To find out the students who are not instructors, it is necessary to perform the operation
Student ÷ Instructor.
Question No: 10 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Consider the given relations Student and Instructor as given below. Please note that
Fname and Lname also denote the First Name and Last Name respectively.
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image006.gif[/IMG]
Which of the following statements is correct with respect to the two relations given above?
► The two relations are not union-compatible since their attribute names differ.
► The two relations are union-compatible since they have the same type of tuples.
► The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these
two relations.
► To find out the students who are not instructors, it is necessary to perform the operation
Student ÷ Instructor.
Question No: 11 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Consider the following relation R and its sample data. (Consider that these are the only tuples for the given relation)
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image008.gif[/IMG]
Which of the following statements is NOT correct?
► The functional dependency ProjNo -> DeptNo holds over R.
► The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.
► The functional dependency DeptNo -> ProjNo holds over R.
► The functional dependency EmpNo -> DeptNo holds over R.
Question No: 12 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] A collection of related data is
► Logical model
► Database
► Data
► Relational model
Question No: 13 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] A weak entity type
► must have total participation in an identifying relationship
► does not have a key attribute(s)
► both (a) and (b)
► none of the above
Question No: 14 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] A description on a particular collection of data using the given data model
► Database
► Schema
► None of the above.
► Relation
Question No: 15 ( Marks: 1 ) - Please choose one
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] 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
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] 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
► B and C
► A and B
Question No: 17 ( Marks: 2 )
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] If there is one super type and there are three subtypes, then how many relations should be created?
Question No: 18 ( Marks: 2 )
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Name the two types of unary operations on relational algebra.
Question No: 19 ( Marks: 2 )
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG]
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image010.jpg[/IMG]
Label the following diagram
1...
2...
Question No: 20 ( Marks: 3 )
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] What is DML (Data Manipulation Language)?
Question No: 21 ( Marks: 3 )
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] “Student CGPA (StdCGPA) is identified through student name (StdName)”
Represent the above statement into the functional dependency (FD) notation.
Question No: 22 ( Marks: 5 )
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Name the four basic operations (base operations) in relational algebra.
Question No: 23 ( Marks: 5 )
[IMG]file:///C:/DOCUME%7E1/rabnol/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG] Differentiate Total and Partial Completeness Constraints.