Menu

Question Discussion & Solution

MCQ

Q.

A dependency exist between two columns when

A

Together they constitute a composite key for the table

B

Knowing the value in one column determines the value stored in another column

C

The table is in 3NF

D

Together they constitute a foreign key

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.

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

A

A many

B

A multivalued attribute of an entity set

C

A one

D

Both A many

Discussion

MCQ

2.

If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.

A

DKNF

B

BCNF

C

Fourth

D

Third

Discussion

MCQ

3.

What are the desirable properties of a decomposition

A

Partition constraint

B

Dependency preservation

C

Redundancy

D

Security

Discussion

MCQ

4.

Which normal form removes transitive dependencies?

A

1NF

B

2NF

C

3NF

D

BCNF

Discussion

MCQ

5.

a)

A

First

B

Second

C

Third

D

Fourth

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