Menu

Question Discussion & Solution

MCQ

Q.

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.

A

Schematic representation

B

Relational algebra

C

Scheme diagram

D

Relation flow

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.

Which of the following symbol is used in the place of except?

A

^

B

V

D

~

Discussion

MCQ

2.

. Which of the following operations need the participating relations to be union compatible?

A

UNION

B

INTERSECTION

C

DIFFERENCEqq

D

All of the above

Discussion

MCQ

3.

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

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.

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

A

Select

B

Group-by

C

Having

D

Order by

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