SQL Statements Quiz-II

0%

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

Click here for learning SQL

NameEmail

1 / 27

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

select max(fee),min(fee) from student;

select max(*),min(*) from student;

select max,min from student;

2 / 27

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

select name,class from student where gender='M'

select * from student where gender='M'

select name,class from student where gender!='M'

3 / 27

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

select * from student where name like 'e%';

select * from student where name like '%e';

select * from student where name like '%e%';

4 / 27

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

delete from student;

delete from student where gender!='F';

delete from student where gender='F';

5 / 27

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

select * from student where name='Mehul' OR name='Manisha'

select * from student where name='Mehul' and name='Manisha'

6 / 27

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

select sum(fees) from student where gender='M';

select sum(fee) from student where gender='M';

select sum(*) from student where gender='M';

7 / 27

What is the basic condition for a join?

Tables to be joined must have primary keys.

Tables to be joined must have a common field.

Tables to be joined may not have a common field.

8 / 27

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

select * from student where fee<1100;

select name from student where fee>1100;

select * from student where fee>1100;

9 / 27

Which of the following statement will display number of records ?

select count from student;

select sum(*) from student;

select count(*) from student;

10 / 27

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

alter table student modify phoneno int;

alter table student drop phoneno;

alter table student add phoneno int;

11 / 27

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

alter table student increase name varchar(40);

alter table student modify name varchar(40);

alter table student add name varchar(40);

12 / 27

Which of the following statement will delete table field gender?

alter table student drop fields gender;

alter table student delete column gender;

alter table student drop column gender;

13 / 27

Which of the following statement will display following output:
XII 2
XI 1

select class,count(*) from student;

select class from student group by class;

select class,count(*) from student group by class;

14 / 27

Which of the following statement will display average fee?

select avg(fee) from student;

select sum(fee) from student;

select average(fee) from student;

15 / 27

What will statement select * from student result into?

Display structure of table

Display all records from table

Display no records from table

16 / 27

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

select * from student where name like '%M';

select * from student where name like 'M%';

select * from student where name like '%M%';

17 / 27

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

select count(*) from student;

select count(class) from student;

select count(distinct class) from student;

18 / 27

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

select name from student where fee>1000 and <1100;

select * from student where fee> 1000 and fee<1100;

select * from student where fee between 1000 and 1100;

19 / 27

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

update student set fee=fee+100;

update student set fee+100;

update student set fee=fee-100;

20 / 27

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

select * from student order by fee asc;

select * from student order by fee;

select * from student order by fee desc;

21 / 27

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

select * from student where fee == null;

select * from student where fee is null;

select * from student where fee = null;

22 / 27

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

select * from student where fee =1100 and 1000;

select * from student where fee in (1100,1000);

select * from student where fee =1100 and fee=1000;

23 / 27

What will statement select name from student result into?

Display all names from table

Display all records from table

Display structure of table

24 / 27

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

select * from student where fee=1200;

select * from student where fee<=1200;

select name from student where fee>=1200;

25 / 27

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

delete table student;

Drop table student;

Delete from student;

26 / 27

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

update student set fee =1100;

update student set fee =1100 where class='XI';

update student set fee =1100 where class != 'XI';

27 / 27

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

Display no records from table

Display all records from table

Display records of male students

Your score is
0%

Exit

Spread the love

Lesson tags: class 12 computer science quizes, quiz of ddl statements, quiz of dml statements, sql quiz

Spread the love

Subscribe for Latest Updates