Question Discussion & Solution

MCQ

Which of the join operations do not preserve non matched tuples?

Left outer join

Right outer join

Inner join

Natural join

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Similar Questions

MCQ

In rank() function if one value is shared by two tuples then

The rank order continues as counting numbers

The rank order continues by leaving one rank in the middle

The user specifies the order

The order does not change

Discussion

MCQ

A Boolean data type that can take values true, false, and________

Null

Unknown

Discussion

MCQ

The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is_______ false and unknown is _____ while unknown and unknown is _____

Unknown, unknown, false

True, false, unknown

True, unknown, unknown

Unknown, false, unknown

Discussion

MCQ

Find the error in the the above statement.

Return type missing

Dept_name is mismatched

Reference relation is not mentioned

All of the mentioned

Discussion

MCQ

Inorder to simplify the null value confusion in the rank function we can specify

Not Null

Nulls last

Nulls first

Either Nulls last or first

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