Menu

Question Discussion & Solution

MCQ

Q.

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

A

A many

B

A multivalued attribute of an entity set

C

A one

D

All 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.

in terms of normalization, this table is in

A

1NF

B

2NF

C

3NF

D

None of the mentioned

Discussion

MCQ

2.

The relation schema R is

A

in BCNF

B

in 3NF, but not in BCNF

C

in 2NF, but not in 3NF

D

not in 2NF

Discussion

MCQ

3.

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

4.

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

MCQ

5.

The functional dependency can be tested easily on the materialized view, using the constraints ____________.

A

Primary key

B

Null

C

Unique

D

Both Null and Unique

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