1. | What is the meaning of “SELECT” clause in Mysql? |
Answer: (a).Show me all Columns and rows
|
2. | Which of the following clause is evaluated in the last by database server? |
Answer: (a).SELECT
|
3. | What will be the output of the following SQL statement?
|
Answer: (a).Show all rows and columns of table “person”
|
4. | What will be the output of of the following SQL statement?
|
Answer: (a).Show only columns (person_id, Fname, lname) and rows related to these columns
|
5. | Can “SELECT” clause be used without the clause “FROM”? |
Answer: (b).No
|
6. | Find the error in the following SQL statement?
|
Answer: (b).No table mentioned
|
7. | What will be the output of the following SQL statement?
|
Answer: (a).Show all columns but only those rows which belongs to person_id=1
|
8. | What will be the output of the following SQL statement?
|
Answer: (a).Show only columns(person_id, fname, lname) but only those rows which belongs to person_id=1
|
9. | Which clause is mandatory with clause “SELECT” in Mysql? |
Answer: (a).FROM
|
10. | Which among the following can also be included with “SELECT” clause while writing query in Mysql? |
Answer: (d).All of the mentioned
|