CLICK HERE FOR VARIOUS NEW JOBS 
CLICK HERE FOR VARIOUS EDUCATIONAL NEWS 
CLICK HERE FOR NEW SCHOLARSHIPS 
CLICK HERE FOR ADMISSION NOTICES 
Click And Follow On Google+ To Get Updates
Please Wait 10 Seconds... OR You CanSkip

ADMISSION NOTICES
Scholarships

Scholarship-300x291

BUDGET 2014-15
budget_2014-2015
New Date Sheets
VU SOLVED ASSIGNMENTS
Recent Posts

Posts Tagged ‘VU. CS403-. Database .Management .Systems .(Session – 4). MIDTERM .EXAMINATION. Spring .2010’

VU CS403- Database Management Systems (Session – 4) MIDTERM EXAMINATION Spring 2010

.

MIDTERM EXAMINATION

Spring 2010

CS403- Database Management Systems (Session – 4)

Ref No: 1356458

Time: 60 min

Marks: 38

Student Info

StudentID: BC080402322

Center: OPKST

ExamDate: 5/28/2010 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 23

Marks

.

Question No: 1 ( Marks: 1 ) – Please choose one

User rights information is stored in

► Physical database

► Catalog

► Logical database

► Buffer

Question No: 2 ( 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: 3 ( Marks: 1 ) – Please choose one

Which of the following is NOT a feature of Context DFD?

► one process (which represents the entire system)

► all sources/sinks (external entities)

► data flows linking the process to the sources and sinks (external

entities)

sub-processes (which explain and decomposed the major process

into small processes)

Question No: 4 ( Marks: 1 ) – Please choose one

A relation (from the relational database model) consists of a set of tuples, which implies that

all tuples in a relation must be distinct.

relational model supports multi-valued attributes whose values can be

represented in sets.

for any two tuples, the values associated with all of their attributes may be the

same.

all tuples in a particular relation may have different attributes.

.

Question No: 5 ( Marks: 1 ) – Please choose one

Choose the symbol that corresponds to a discriminator attributes.

Question No: 6 ( Marks: 1 ) – Please choose one

Identify the constraint that limits the values that can be placed in a column.

NOT NULL

► CHECK No Idea

► FOREIGN KEY

► UNIQUE

Question No: 7 ( Marks: 1 ) – Please choose one

Given are the relations of student and Instructor

Consider the following table obtained using Student and Instructor relations.

.

Which relational algebra operation could have been applied on the pair of relations Student and

Instructor to obtain the above data?

Instructor – Student

► Student ∩ Instructor

► Instructor ÷ Student

► Student – Instructor

Question No: 8 ( 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: 9 ( Marks: 1 ) – Please choose one

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 3NF

► The relation Interview is in BCNF.

► The FD3 violates 3NF.

► The FD2 violates 2NF.

Question No: 10 ( Marks: 1 ) – Please choose one

Identify the INCORRECT statement among the given.

► An entity may be an object with a physical existence like a car, a house or an Employee.

One cannot consider something which has conceptual existence like a course in a degree

.

program as an entity.

► Age can be considered as a single value attribute of a person.

► An entity type describes the schema or intension for a set of entities which share the same

structure.

Question No: 11 ( Marks: 1 ) – Please choose one

Structural constraints of a relationship type refer to

► identifying the owner entity type relevant to a given entity type

whether the existence of an entity depends on it being related to another entity via the

relationship type.

► the role that a participating entity from the entity type plays in each relationship instance.

► the constraints applicable in granting access to tables, columns and views in a database

schema.

Question No: 12 ( Marks: 1 ) – Please choose one

A collection of concepts that can be used to describe the structure of a database

► Database

► DBMS

Data model

► Data

Question No: 13 ( Marks: 1 ) – Please choose one

An entity can be logically connected to another by defining a ____.

► hyperlink

common attribute

► primary key

► superkey

Question No: 14 ( Marks: 1 ) – Please choose one

The ____ constraint specifies whether each entity supertype occurrence must also be a

member of at least one subtype.

► specialization

► uniqueness

► inheritance

completeness

Question No: 15 ( Marks: 1 ) – Please choose one

Database management systems, operating systems, applications and utilities are all

examples of ____.

► hardware

.

software

► computer infrastructure

► input and output

Question No: 16 ( Marks: 1 ) – Please choose one

Which of the following concepts is applicable with respect to 2NF?

Full functional dependency

► Any kind of dependency

► Transitive dependency

► Non-transitive dependency

Question No: 17 ( Marks: 2 )

What do you know about Insertion anomaly?

Insertion anomaly indicates that we cannot insert a fact about one entity until we have an

additional fact about another entity.

Question No: 18 ( Marks: 2 )

Define domain of an attribute.

In computing, the attribute domain is the set of values allowed in an attribute. For the relational

model it is a requirement that each part of a tuple be atomic. The consequence is that each value

in the tuple must be of some basic type, like a string or an integer. For the elementary type to be

atomic it cannot be broken into more pieces.

Question No: 19 ( Marks: 2 )

Label the following diagram

1…

2…

Question No: 20 ( Marks: 3 )

Why do the relational data model considered as simple?

The relational model for database management is a database model based on first-order

predicate logic The relational model provide a declarative method for specifying data and

queries: we directly state what information the database contains and what information we want

from it, and let the database management system software take care of describing data

structures for storing the data and retrieval procedures for getting queries answered

Question No: 21 ( Marks: 3 )

What is the intersection operation in relational algebra?

.

The intersection operation also has the requirement that both the relations should be union

compatible, which means they are of same degree and same domains. It is represented by. If R

and S are two relations and we take intersection of these two

relations then the resulting relation would be the set of tuples, which are in both R and

S. Just like union intersection is also commutative.

R _ S = S _ R

INTERSECTION Example

Question No: 22 ( Marks: 5 )

The following diagram describes a part of an ER diagram.

Considering the above diagram, which of the given statements are True and which are

False.

i-Entity2 is a weak entity. True

.

ii-Cardinality ratio for Entity1:Entity2 in Rel1 is 1:N. True

iii-Attrib6 represents an attribute which is having composite nature. False

iv-Attrib3 is a kind of a derived attributes. True

v-Entity2 is participating totally in the Rel1 relationship.

Question No: 23 ( Marks: 5 )

How to implement one-to-many relationship while designing tables?

If the primary key in a parent table matches multiple foreign keys in a child table, then

the relationship is one-to-many. This relationship is common in database applications.

For example, an application for a sports league might access a team table and a

player table. Each team has multiple players, and each player belongs to a single

team. Every row in the child table (player) has a foreign key identifying the player’s

team. This foreign key matches the team table’s primary key.

When designing such entity beans, you must decide whether both tables are

represented by entity beans, or just one.

VU CS403- Database Management Systems (Session – 4) MIDTERM EXAMINATION Spring 2010

.

MIDTERM

EXAMINATION Spring

2010

CS403- Database Management Systems (Session -

4)

Time: 60 min

Marks: 38

Question No: 1 ( Marks: 1 ) – Please choose one

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

User rights information is stored in

► Physical database

► Catalog

► Logical database

► Buffer

Question No: 3 ( Marks: 1 ) – Please choose one

The ER- data model is an example of:

► Physical database

► Logical database

► Relational database

► Conceptual database

Question No: 4 ( Marks: 1 ) – Please choose one

.

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

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

Consider the following diagram depicting a kind of a relationship type

where X and Z are entities and

Y is a

relationship type:

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

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

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

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.

Which of the following statements is correct with respect to the two

relations given above?

thes

e

► 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

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

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.

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

Consider the following relation R 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 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

A collection of related data is

► Logical model

► Database

► Data

► Relational model

Question No: 13 ( Marks: 1 ) – Please choose one

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

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

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

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 )

If there is one super type and there are three subtypes, then how many

relations should be created?

Question No: 18 ( Marks: 2 )

Name the two types of unary operations on relational algebra.

Question No: 19 ( Marks: 2 )

1..

.

2..

.

Label the following diagram

Question No: 20 ( Marks: 3 )

What is DML (Data Manipulation Language)?

Question No: 21 ( Marks: 3 )

“Student CGPA (StdCGPA) is identified through

student name (StdName)” Represent the above

statement into the functional dependency (FD)

notation.

Question No: 22 ( Marks: 5 )

Name the four basic operations (base operations) in relational algebra.

Question No: 23 ( Marks: 5 )

Differentiate Total and Partial Completeness Constraints.

ALL NEW RESULTS
Educational News

Updated Educational News

Categories
POSTS BY DATE
December 2016
M T W T F S S
« Sep    
 1234
567891011
12131415161718
19202122232425
262728293031