Menu

Question Discussion & Solution

MCQ

Q.

in terms of normalization, this table is in

A

1NF

B

2NF

C

3NF

D

None of the mentioned

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.

The normal form which satisfies multivalued dependencies and which is in BCNF is

A

4 NF

B

3 NF

C

2 NF

D

All of the mentioned

Discussion

MCQ

2.

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in

A

Fourth NF

B

BCNF

C

Third NF

D

Second NF

Discussion

MCQ

3.

A domain is ______ if elements of the domain are considered to be indivisible units.

A

Atomic

B

Subatomic

C

Substructure

D

Subset

Discussion

MCQ

4.

a)

A

1NF

B

2NF

C

3NF

D

4NF

Discussion

MCQ

5.

We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

A

Axioms

B

Armstrong?s axioms

C

Armstrong

D

Closure

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