Multipletables, functions, sub-queries

Which SQL function is used to find the average value of any column?

• Mean()

• Avg()

• Average()

• Sum()

Query to delete all record of table without deleting the table:

• DELETE TABLE TABLE_NAME

• DELETE FROM TABLE_NAME

• DROP TABLE TABLE_NAME

• DELETE TABLE FROM TABLE_NAME

Which function will be used to find largest value from the column?

• max()

• large()

• least()

• all

Fill in the blank:

___________________ this clause is used to apply condition on all the rows of table.

• Where

• Having

• Order By

• Sort By

Use figure for data.

table name = order

What will be the output of following query:

select * from order where oederID = 10248;

• all data

• only one row which has orderID = 10248

• it will return only 10248

• error

Which clause is used when we want to use aggregate functions in conditions?

• Where

• Group By

• Having

• Both 2 and 3

Which function has been used for convert your letter into uppercase?

• Upercase()

• Uconvert()

• Ucase()

• Uletter

True / False : Select * from OrderDetails where Quantity <  AVG(Quantity);

• True

• False

Primary key must consist unique values where foreign key must includes different values.

• True

• False

Which function is useful to find year from the given date?

• Ydate()

• Date()

• Day()

• Year()