Menu

Question Discussion & Solution

MCQ

Q.

Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by

A

Unique

B

Unique

C

Role intergral assignment

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.

Which of the normal form is based on multivalued dependencies?

A

First

B

Second

C

Third

D

Fourth

Discussion

MCQ

2.

The main task carried out in the __________ is to remove repeating attributes to separate tables.

A

First Normal Form

B

Second Normal Form

C

Third Normal Form

D

Fourth Normal Form

Discussion

MCQ

3.

Functional Dependencies are the types of constraints that are based on______

A

Key

B

Key revisited

C

Superset key

D

None of the mentioned

Discussion

MCQ

4.

critical operations?

A

Denormalization

B

Redundant optimization

C

Optimization

D

Realization

Discussion

MCQ

5.

For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

A

1 NF only

B

2 NF and hence also in 1 NF

C

3NF and hence also in 2NF and 1NF

D

BCNF and hence also in 3NF, 2NF and 1NF

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