Menu

Question Discussion & Solution

MCQ

Q.

Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000 .

A

{t | t ? instructor ? t[salary] > 80000}

B

? t ? r (Q(t))

C

{t | ? s ? instructor (t[ID] = s[ID]? s[salary] > 80000)}

D

None of the mentioned

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.

Relational calculus is a

A

Procedural language.

B

Non- Procedural language.

C

Data definition language.

D

High level language.

Discussion

MCQ

2.

An entity set that does not have sufficient attributes to form a primary key is a

A

strong entity set.

B

weak entity set.

C

simple entity set.

D

primary entity set.

Discussion

MCQ

3.

An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

A

Candidate

B

Primary

C

Super

D

Sub

Discussion

MCQ

4.

The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called

A

Referential relation

B

Referencing relation

C

Referenced relation

D

Referred relation

Discussion

MCQ

5.

The union operation is represented by

A

?

B

U

D

*

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