Question Discussion & Solution

MCQ

If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.

Distinct

Count

Avg

Primary key

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Similar Questions

MCQ

Updating the value of the view

Will affect the relation from which it is defined

Will not change the view definition

Will not affect the relation from which it is defined

Cannot determine

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

Which one of the following deletes all the entries but keeps the structure of the relation.

Delete from r where P

Delete from instructor where dept name

Delete from instructor where salary between 13000 and 15000

Delete from instructor

Discussion

MCQ

The____condition allows a general predicate over the relations being joined.

Using

Set

Where

Discussion

MCQ

In an employee table to include the attributes whose value always have some value which of the following constraint must be used?

Null

Not null

Unique

Distinct

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