DBMS MCQs - CSE MCQs Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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.

Where, having

Having, where

Group by, having

Group by, where

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Lateral

Having

With

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

With

From

Where

Select

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Subqueries cannot:

Use group by or group functions

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

Join tables

Appear in select, update, delete, insert statements.

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which of the following is not a aggregate function ?

Avg

Sum

With

Min

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

The EXISTS keyword will be true if:

Any row in the subquery meets the condition only.

All rows in the subquery fail the condition only.

Both of these two conditions are met.

Neither of these two conditions is met. View Answer

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

How can you find rows that do not match some specified condition?

EXISTS

Double use of NOT EXISTS

NOT EXISTS

None of the mentioned is correct.