SQL Statements Quiz- I 0% Sql Statements Quiz Click here for learning SQL NameEmail 1 / 20 Which of the following command creates a table having three fields rollno, name and class create table s1(rollno int, name varchar(20),fee float); create table s1(rollno, name,fee); 2 / 20 Which of the following statement will insert (101 null,450) record into table student? insert into student values(101,' ',450); insert into student (regno,fee) values(101,450); insert into student (101,null,450); 3 / 20 Which clause of Alter table statement is used to delete a column from a table? Delete column Remove column Drop Column 4 / 20 Which SQL statement is used to modify records? Modify Insert Update 5 / 20 What will following statement do? Update student set fees=fees+100; Fee will be increased by 100 for all records from student table Fee will not be increased by 100 for all records from student table Nothing will happen. 6 / 20 Which SQL statement is used to create a table? Create table Create view Create Database 7 / 20 Which command is used to modify structure of a table? Alter table Update table Modify Table 8 / 20 Which statement is used to view structure of a table? show <table_name> select <table_name> Describe <table_name> 9 / 20 Which statement can be used to display records from a table? View Display Select 10 / 20 Which clause of alter table statement is used to increase or decrease field width. drop modify add 11 / 20 Which of the following statements will insert record (101 Lovejot 450) in table student. insert into student values(101,Lovejot,450); insert into student values(101,'Lovejot',450); insert into student (101,'Lovejot',450); 12 / 20 Which SQL statement is used to delete table permanently? Remove table Drop table Delete Table 13 / 20 What will following statement do? delete from student where fee>500; Delete all records having fee less than 500 Nothing will happen. Delete all records having fee more than 500 14 / 20 What does * specify in given statement:select * from student; All Records All Fields Specific Fields 15 / 20 What will following statement do? Update student set fees=fees-100 where fee<500; Nothing will happen. Fee will be decreased by 100 for all records having fee less than 500 Fee will be increased by 100 for all records having fee less than 500 16 / 20 Which statement can be used to delete records from a table? Drop Delete Remove 17 / 20 Can we use Alter table to delete a table field. No Yes 18 / 20 Which of the following statements will insert (101 NULL 450) record into table student? insert into student values(101,NULL,450); insert into student values(101,' ',450); insert into student (101,null,450); 19 / 20 What will statement Update student set roll=106 do? Roll field will be updated with value 106 for all records in student table Roll field will not be updated with value 106 for all records in student table 20 / 20 Which statement is used to insert a new record in a table? Add sum Insert Your score is 0% Restart quiz Exit Spread the love Lesson tags: class 12 computer science quizes, quiz of ddl statements, quiz of dml statements, sql quiz Output based SQL queries with answers SQL Statements Quiz-II Back to: CBSE class 12 Computer Science notesSpread the love