Question details

An abstraction concept for building composite object from their component object is called
$ 10.00

Page:of 3

 

 

                                             Automatic Zoom                                             Actual Size                                             Page Fit                                             Page Width                                                                                          50%                                             75%                                             100%                                             125%                                             150%                                             200%                                             300%                                             400%                                         

 

 

DATABASE MANAGEMENT MULTIPLE CHOICE QUESTIONS & ANSWERS

1.

In an object

-

oriented model, one object can access

da

ta of another object by passing

:

a.

Instance variabl

e

b.

Messag

e

c.

Variabl

e

d.

None of thes

e

2.

A view of database that appears to an

application

program is known as

:

a.

S

chem

a

b.

S

ubschem

a

c.

virtual tabl

e

d.

none of the abov

e

3.

An abstraction concept for building composite

object from their component object is called

:

a.

Specializatio

n

b.

Normalizatio

n

c.

Generalizatio

n

d.

Aggregatio

n

4.

A set of objects that share a common structure

and

a common behavior is called

:

a.

Objec

t

b.

Clas

s

c.

Entit

y

d.

None of thes

e

5.

Every weak entity set can be conver

ted into a

strong entity set by

:

a.

using generalizatio

n

b.

addin

g appropriate attribute

s

c.

using aggregatio

n

d.

none of the abov

e

6.

The number of entities to which another entity can

be associated via a r

elationship set is expressed

as

:

a.

Entit

y

b.

Cardinalit

y

c.

Schem

a

d.

Attribute

s

7.

Relations produced from

an E

-

R model will always be

in

:

a.

First normal for

m

 

Thanks for rating! You should receive an unlock shortly.

 

 

b.

Second normal for

m

c.

Third normal for

m

d.

Fourth normal for

m

8.

In ER model the details of the entities are hidden

from the user. This

process is called

:

a.

G

eneralizatio

n

b.

S

pecializatio

n

c.

A

bstractio

n

d.

none of these abov

e

9.

The file organization that provides very fast

access to an

y arbitrary record of a file is

:

a.

Ordered fil

e

b.

Unordered fil

e

c.

Hashed fil

e

d.

B

-

tre

e

10.

What is not true about a view

?

a.

It is a definition of a restricted portion of

the databas

e

b.

It is a security mechanis

m

c.

It is always updatable like any other tabl

e

d.

All are tru

e

11.

In a relational database a referential integrity

constraint can be specified with the help of

a.

primary ke

y

b.

foreign ke

y

c.

secondary ke

y

d.

none of the abov

e

12.

A super key is a set of one or more attributes

that, taken collectively, allow us

a.

to identify uniquely an entity in the entity

se

t

b.

to make the key most powerful for faster

retrieva

l

c.

to increase effectiveness of database acces

s

d.

none of the abov

e

13.

4NF is designed to cope with

:

a.

Transitive dependenc

y

b.

Join dependenc

y

c.

Multi valued dependenc

y

d.

None of thes

e

14.

Every Boyee

-

Codd normal form is i

n

a.

First normal for

m

 

Available solutions