Menu

Question Discussion & Solution

MCQ

Q.

The subset of a super key is a candidate key under what condition?

A

No proper subset is a super key

B

All subsets are super keys

C

Subset is a super key

D

Each subset is a super 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.

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.

A

Schema diagram

B

Relational algebra

C

Database diagram

D

Schema flow

Discussion

MCQ

2.

Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000 .

A

{t | t ? instructor ? t[salary] > 80000}

B

? t ? r (Q(t))

C

{t | ? s ? instructor (t[ID] = s[ID]? s[salary] > 80000)}

D

None of the mentioned

Discussion

MCQ

3.

In a relational model, relations are termed as

A

Tuples

B

Attributes

C

Tables

D

Rows

Discussion

MCQ

4.

A query in the tuple relational calculus is expressed as:

A

{t | P() | t}

B

{P(t) | t }

C

{t | P(t)}

D

All of the mentioned

Discussion

MCQ

5.

The assignment operator is denoted by

A

->

B

<-

C

==

D

=

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