SQL Statements Quiz- I

0%

Sql Statements Quiz

1 / 20

What will following statement do? Update student set fees=fees+100;

2 / 20

Which statement is used to view structure of a table?

3 / 20

What will following statement do? delete from student where fee>500;

4 / 20

Which of the following command creates a table having three fields rollno, name and class

5 / 20

Which SQL statement is used to create a table?

6 / 20

Which clause of alter table statement is used to increase or decrease field width.

7 / 20

Which statement can be used to delete records from a table?

8 / 20

Which SQL statement is used to modify records?

9 / 20

Which statement can be used to display records from a table?

10 / 20

Which of the following statement will insert (101  null,450) record into table student?

11 / 20

Which of the following statements will insert (101    NULL  450) record  into table student?

12 / 20

Can we use Alter table to delete a table field.

13 / 20

Which SQL statement is used to delete table permanently?

14 / 20

What does * specify in given statement:select * from student;

15 / 20

Which of the following statements will insert record (101   Lovejot  450) in table student.

16 / 20

What will following statement do? Update student set fees=fees-100 where fee<500;

17 / 20

Which clause of Alter table statement is used to delete a column from a table?

18 / 20

Which statement is used to insert a new record in a table?

19 / 20

What will statement Update student set roll=106 do?

20 / 20

Which command is used to modify structure of a table?

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
Back to: CBSE class 12 Computer Science notes
Spread the love