Menu

Question Discussion & Solution

MCQ

Q.

Which one of the following cannot be taken as a primary key?

A

Id

B

Register number

C

Dept_id

D

Street

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 _______ operator takes the results of two queries and returns only rows that appear in both result sets.

A

Union

B

Intersect

C

Difference

D

Projection

Discussion

MCQ

2.

A

? t ? r (Q(t))

B

? t ? r (Q(t))

D

~ t ? r (Q(t))

Discussion

MCQ

3.

The _____________ is essentially used to search for patterns in target string.

A

Like Predicate

B

Null Predicate

C

In Predicate

D

Out Predicate

Discussion

MCQ

4.

This query displays

A

Only tuples from second part

B

Only tuples from the first part which has the tuples from second part

C

Tuples from both the parts

D

Tuples from first part which do not have second part

Discussion

MCQ

5.

The ___________ operation, denoted by -, allows us to find tuples that are in one relation but are not in another.

A

Union

B

Set difference

C

Difference

D

Intersection

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