Menu

Question Discussion & Solution

MCQ

Q.

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

A

A

B

A

C

AB

D

A

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

a)

A

2NF

B

3NF

C

4NF

D

5NF

Discussion

MCQ

2.

in terms of normalization, this table is in

A

1NF

B

2NF

C

3NF

D

None of the mentioned

Discussion

MCQ

3.

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

A

Zero

B

More than zero but less than that of an equivalent 3NF decomposition

C

Proportional to the size of F+

D

Indeterminate

Discussion

MCQ

4.

a)

A

First

B

Second

C

Third

D

Fourth

Discussion

MCQ

5.

Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.

A

Cross

B

Snapshot

C

Both Cross

D

All of the mentioned

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs