Menu

Question Discussion & Solution

MCQ

Q.

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

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.

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

A

Id

B

Register number

C

Dept_id

D

Street

Discussion

MCQ

3.

An expression in the domain relational calculus is of the form

A

{P(x1, x2, . . . , xn) | < x1, x2, . . . , xn > }

B

{x1, x2, . . . , xn | < x1, x2, . . . , xn > }

C

{ x1, x2, . . . , xn | x1, x2, . . . , xn}

D

{< x1, x2, . . . , xn > | P(x1, x2, . . . , xn)}

Discussion

MCQ

4.

Which is a unary operation:

A

Selection operation

B

Primitive operation

C

Projection operation

D

Generalized selection

Discussion

MCQ

5.

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

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