Menu

Question Discussion & Solution

MCQ

Q.

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

A

Select

B

Join

C

Union

D

Intersection

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 relational database developer refers to a record as

A

a criteria.

B

a relation.

C

a tuple.

D

an attribute.

Discussion

MCQ

2.

_____ clause is an additional filter that is applied to the result.

A

Select

B

Group-by

C

Having

D

Order by

Discussion

MCQ

3.

The _______operation performs a set union of two

A

Union

B

Join

C

Product

D

Intersect

Discussion

MCQ

4.

If we want to retain all duplicates, we must write ________ in place of union.

A

Union all

B

Union some

C

Intersect all

D

Intersect some

Discussion

MCQ

5.

In a relational model, relations are termed as

A

Tuples

B

Attributes

C

Tables

D

Rows

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