Question:

If a multivalued dependency holds and is not implied by the corresponding functionaldependency, it usually arises from one of the following sources.

A.

A many-to-many relationship set

B.

A multivalued attribute of an entity set

C.

A one-to-many relationship set

D.

Both A many-to-many relationship set and A multivalued attribute of an entity set

Answer» d. Both A many-to-many relationship set and A multivalued attribute of an entity set

Question:

Entity Relationship model consists of collection of basic objects called _________ andrelationship among these objects.

A.

functions

B.

models

C.

None of these

D.

entities

Answer» d. entities

Question:

In which of the following, a separate schema is created consisting of that attribute and theprimary key of the entity set.

A.

A many-to-many relationship set

B.

A multivalued attribute of an entity set

C.

A one-to-many relationship set

D.

All of the mentioned

Answer» b. A multivalued attribute of an entity set

Question:

Consider a directed line(->) from the relationship set advisor to both entity sets instructorand student. This indicates _________ cardinality

A.

One to many

B.

One to one

C.

Many to many

D.

Many to one

Answer» b. One to one

Question:

Data Models in DBMS are classified into ______ categories.

A.

3

B.

2

C.

5

D.

4

Answer» c. 5

Question:

Object based logical model(s) are used to describe data at – [Select Appropriate Option(s)]

A.

View Level

B.

Logical Level

C.

Physical Level

D.

None of these

Answer» c. Physical Level

Question:

What do data warehouses support?

A.

olap

B.

oltp

C.

olap and oltp

D.

operational databases

Answer» a. olap

Question:

The operation of moving from finer- granularity data to a coarser granularity (by means of aggregation) is called a                  

A.

rollup

B.

drill down

C.

dicing

D.

pivoting

Answer» a. rollup

Question:

What are the different in triggers?

A.

define, create

B.

drop, comment

C.

insert, update, delete

D.

all of the mentioned

Answer» c. insert, update, delete

Question:

If there are n tuples in the partition and the rank of the tuple is r, then its                  is defined as (r −1)/(n−1).

A.

ntil()

B.

cum_rank

C.

percent_rank

D.

rank()

Answer» c. percent_rank