NEW
Font size
WorksheetsMultipletables, functions, sub-queries
Total questions: 10
Worksheet time: 7mins
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()
