Advanced SQL Questions

MCQ bookmark_border

21.

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

A

1

C

Null

D

Unknown

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

22.

The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.

A

Or, in

B

Not in, in

C

In, not in

D

In, or

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

23.

SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.

A

Group by

B

With

C

Where

D

Having

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

24.

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

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

25.

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

A

In

B

Lateral

C

Having

D

With

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

26.

Which of the following creates a temporary relation for the query on which it is defined?

A

With

B

From

C

Where

D

Select

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

27.

In the query given above which one of the following is a temporary relation?

A

Budget

B

Department

C

Value

D

Max_budget

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

28.

a)

A

Use group by or group functions

B

Retrieve data from a table different from the one in the outer query

C

Join tables

D

Appear in select, update, delete, insert statements.

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

29.

Which of the following is not an aggregate function?

A

Avg

B

Sum

C

With

D

Min

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

30.

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

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion