Menu

Question Discussion & Solution

MCQ

Q.

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

A

Delete from r where P

B

Delete from instructor where dept name

C

Delete from instructor where salary between 13000 and 15000

D

Delete from instructor

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.

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

A

The rank order continues as counting numbers

B

The rank order continues by leaving one rank in the middle

C

The user specifies the order

D

The order does not change

Discussion

MCQ

2.

Inorder to give only 10 rank on the whole we should use

A

Limit 10

B

Upto 10

C

Only 10

D

Max 10

Discussion

MCQ

3.

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 _____

A

Unknown, unknown, false

B

True, false, unknown

C

True, unknown, unknown

D

Unknown, false, unknown

Discussion

MCQ

4.

Materialised views make sure that

A

View definition is kept stable

B

View definition is kept up

C

View definition is verified for error

D

View is deleted after specified time

Discussion

MCQ

5.

All aggregate functions except _____ ignore null values in their input collection.

A

Count

B

Count

C

Avg

D

Sum

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