Menu

Question Discussion & Solution

MCQ

Q.

Which of the following should be used to find the mean of the salary ?

A

Mean

B

Avg

C

Sum

D

Count

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.

Using the ______ clause retains only one copy of such identical tuples.

A

Null

B

Unique

C

Not null

D

Distinct

Discussion

MCQ

2.

Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.

A

Where, having

B

Having, where

C

Group by, having

D

Group by, where

Discussion

MCQ

3.

The____condition allows a general predicate over the relations being joined.

A

On

B

Using

C

Set

D

Where

Discussion

MCQ

4.

negative which of the following should be used?

A

Check

B

Check

C

Alter

D

Alter

Discussion

MCQ

5.

A primary key if combined with a foreign key creates

A

Parent-Child relationship between the tables that connect them.

B

Many to many relationship between the tables that connect them.

C

Network model between the tables that connect them.

D

None of the above.

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