Menu

Question Discussion & Solution

MCQ

Q.

>B This can be combined as

A

A

B

A

C

B

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.

What is the best way to represent the attributes in a large database?

A

Relational

B

Concatenation

C

Dot representation

D

All of the mentioned

Discussion

MCQ

2.

If a relation is in BCNF, then it is also in

A

1 NF

B

2 NF

C

3 NF

D

All of the mentioned

Discussion

MCQ

3.

Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID?s?

A

Both I and II

B

I only

C

II only

D

Neither I nor I

Discussion

MCQ

4.

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

Discussion

MCQ

5.

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is

A

BCNF algorithm

B

2NF algorithm

C

3NF synthesis algorithm

D

1NF algorithm

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