Menu

Question Discussion & Solution

MCQ

Q.

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

A

Count

B

Count

C

Avg

D

Sum

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.

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

A

Not Null

B

Nulls last

C

Nulls first

D

Either Nulls last or first

Discussion

MCQ

2.

Which of the following creates a virtual relation for storing the query?

A

Function

B

View

C

Procedure

D

None of the mentioned

Discussion

MCQ

3.

Triggers ________ enabled or disabled

A

Can be

B

Cannot be

C

Ought to be

D

Always

Discussion

MCQ

4.

The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.

A

In

B

Lateral

C

Having

D

With

Discussion

MCQ

5.

a)

A

Any row in the subquery meets the condition only

B

All rows in the subquery fail the condition only

C

Both of these two conditions are met

D

Neither of these two conditions is met

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