Menu

Question Discussion & Solution

MCQ

Q.

Using the ______ clause retains only one copy of such identical tuples.

A

Null

B

Unique

C

Not null

D

Distinct

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.

Using the ______ clause retains only one copy of such identical tuples.

A

Null

B

Unique

C

Not null

D

Distinct

Discussion

MCQ

2.

a)

A

Use group by or group functions

B

Retrieve data from a table different from the one in the outer query

C

Join tables

D

Appear in select, update, delete, insert statements.

Discussion

MCQ

3.

Ranking of queries is done by which of the following?

A

Group by

B

Order by

C

Having

D

Both Group by and Order by

Discussion

MCQ

4.

Which of the following is an advantage of view?

A

Data security

B

Derived columns

C

Hiding of complex queries

D

All of the above

Discussion

MCQ

5.

Foreign key is the one in which the ________ of one relation is referenced in another relation.

A

Foreign key

B

Primary key

C

References

D

Check constraint

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