Page 328 - IT 402 v2.0 class 10
P. 328
2. Command to display all the data in the table “emp” is ............................. .
i. Select * from emp ii. Select * from emp;
iii. Select all from emp iv. Select all from emp;
3. Which command is used to modify data in table?
i. delete ii. select
iii. modify iv. update
4. Select " emp name" , " salar y " * 3 f r om emp ;
i. will increase the salary three times of all employees in table
ii. display name and three times salary
iii. give error
iv. None of the above
5. ommand to increase the salary of all employees by 5 . table name emp and column name sal
i. update emp set sal = sal + 15000; ii. update emp set sal = 15000;
iii. update set sal = sal + 15000; iv. None of the above
6. Which command is used to delete data from table?
i. select ii. delete
iii. insert iv. remove
Fill in t e lan s
1. ............................. is the most commonly used ata Manipulation anguage M command.
2. ............................. are used to identify which type of data we are going to store in the database.
3. ............................. command is used to create a table.
4. A ............................. is a language that enables users to access and manipulate data in a database.
5. A ............................. is a standard for commands that define the different structures in a database.
6. ............................. statement retrieves zero or more rows from one or more database tables or database views.
7. ............................. statement is used to remove one or more records in a Database.
Section
Su ecti e T e uestions
ns er t e follo ing uestions:
. Name two categories of S commands.
. ifferentiate between and M commands.
3. Explain the following commands:
i. Create ii. Update
iii. Insert iv. Delete
4. What are the ways to create a table?
5. rite S command to insert a student record in a student table. he fields are rollno name birthplace contactno
and previousschool.
6. State the purpose of Update Command with the help of an example.
7. Explain SQL Comparison Operators.
8. Consider the following table: Sales [CBSE Sample Paper 2023]
Sale Id Prod ame Price iscount
1101 Laptop 65000 2500
1103 Pen tab 29500 1000
1105 Desktop 50000 1550
1106 Printer 12000 2000
326 Touchpad Information Technology-X

