Menu

Question Discussion & Solution

MCQ

Q.

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

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.

_________ joins are SQL server default

A

Outer

B

Inner

C

Equi

D

None of the mentioned

Discussion

MCQ

3.

A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

A

Rows

B

Key

C

Attribute

D

Fields

Discussion

MCQ

4.

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

A

Join

B

Projection

C

Select

D

Union

Discussion

MCQ

5.

Which of the following operation is used if we are interested in only certain columns of a table?

A

PROJECTION

B

SELECTION

C

UNION

D

JOIN

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