MYSQL QUIZ - SELECT queries BRS GR11

1. To display all the records from the table which option is used in mysql queries ?

• full

• alls

• *

• **

2.Which Clause is used for display unique data in the select query ?

• unique

• no repeat

• distinct

• null

Write the output :

Select sname from stud where fees > 2000;

(a)  

Which query will display sorted records in descending order of sname?

• select * from stud order by sname;

• Select * from stud order by sname desc;

• select sname from stud where order by desc;

• select * from stud where sname order by desc;

What is the cardinality of the table ?

• 9

• 8

• 7

• 4