SQL MCQ : Query Solving (Multiple Choice Questions)
Consider the following table “STUDENT” and answer the following questions -
[table border="1"]
Roll,SName,City,Marks
1,Rajesh,Pune,90
2,Sanjay,Mumbai,90
3,Raj,Pune,95
4,Prakash,Delhi,91
5,Vikki,Pune,98
[/table]
Question 1 |
How many rows will be selected if we ran following query -
Select * from STUDENT;
2 | |
1 | |
4 | |
5 |
Question 2 |
Which of the following query is used to select count of students from "STUDENT" table.
Select COUNT(ALL) from STUDENT; | |
Select COUNT(*) from STUDENT;
| |
Select COUNT() from STUDENT; | |
None of these |
Question 3 |
Which of the Query is used to Select all the Students from City = "Pune".
Select * from STUDENT where city == "Pune"; | |
None of these | |
Select * from STUDENT where city="Pune"; | |
Select * from STUDENT where city is "Pune"; |
Question 4 |
Which of the command is used to insert record in the table ?
INSERT TO STUDENT VALUES (6,Salman,Mumbai,90); | |
INSERT IN TO STUDENT VALUES (6,Salman,Mumbai,90); | |
None of these | |
INSERT INTO STUDENT VALUES (6,Salman,Mumbai,90); |
Question 5 |
SELECT SName,City FROM Customers WHERE Roll=8;will return how many rows ?
2 | |
1 | |
3 | |
0 |
There are 5 questions to complete.