SQL Statements Quiz-II

0%

Sql Statements Quiz-II (Class 12 Computer Science/IP)

1 / 27

Which of the following statement will display name and class of male students?

2 / 27

Which of the following statement will display names of students containing 'e' alphabet in their names?

3 / 27

Which of the following statement will display records of Mehul and Manisha?

4 / 27

What will statement select name from student result into?

5 / 27

Which of the following statement will display students having fee 1200?

6 / 27

Which of the following statement will display students having fee between 1000 and 1100?

7 / 27

Which of the following statement will display average fee?

8 / 27

Which of the following statement will display records where name starts with alphabet 'M'?

9 / 27

Which of the following statement will display sum of fees of male students?

10 / 27

Which of the following statement will increase the size of name field to 40 characters?

11 / 27

Which of the following statement will make fee of class XI as 1100?

12 / 27

Which of the following statement will display students having fee more than 1100?

13 / 27

Which of the following statement will delete table field gender?

14 / 27

Which of the following statement will permanently delete table data and structure?

15 / 27

What is the basic condition for a join?

16 / 27

Which of the following statement will increase fee of all students by 100?

17 / 27

Which of the following statement will display number of classes in the table (Unique values)?

18 / 27

Which of the following statement will display following output:

XII    2

XI     1

19 / 27

Which of the following statement will delete records of female students ?

20 / 27

Which of the following statement will display number of records ?

21 / 27

Which of the following statement will display those records where fee is null?

22 / 27

Which of the following statement will display records in descending order of fee?

23 / 27

Which of the following statement will display students having fee among values 1000 and 1100?

24 / 27

What will statement select * from student result into?

25 / 27

What will statement select * from student where gender='M' result into?

26 / 27

Which of the following statement will display maximum and minimum fee?

27 / 27

Which of the following statement will add a new field phoneno to table ?

Your score is

0%

Exit




Lesson tags: class 12 computer science quizes, quiz of ddl statements, quiz of dml statements, sql quiz
Back to: CBSE class 12 Computer Science notes