Question Discussion & Solution

MCQ

The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

Union

Intersect

Difference

Projection

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Similar Questions

MCQ

Natural join is equal to?

Cartesian Product

Combination of Union and Cartesian product

Combination of selection and Cartesian product

Combination of projection and Cartesian product

Discussion

MCQ

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

strong entity set.

weak entity set.

simple entity set.

primary entity set.

Discussion

MCQ

In precedence of set operators, the expression is evaluated from

Left to left

Left to right

Right to left

From user specification

Discussion

MCQ

Which is a unary operation:

Selection operation

Primitive operation

Projection operation

Generalized selection

Discussion

MCQ

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

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

? t ? r (Q(t))

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

None of the mentioned

Discussion

Banking

Engineering

General

Medical

Question Discussion & Solution

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed

Banking

Engineering

General

Medical

Question Discussion & Solution

report Report Error

forum Community Discussion

auto_awesome Similar Questions

report Report Error

report Report Error

report Report Error

report Report Error

report Report Error

category More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics