Important SQL Commands Class 10 IT Code 402 Questions and Answers Unit 3 RDBMS

Share with others

SQL commands Class 10
SQL commands Class 10

SQL Commands Class 10 IT Code 402

SESSION 4: RETRIEVE DATA USING QUERY

Q1. What do you mean by query in Open Office Base?

Q2. In how many ways you can create query in Open Office Base?

Q3. Name the Query language which is used in Base?

Q4. Which command is used to retrieve data from the table?

SQL Commands Class 10 IT Code 402

Q5. Name two categories of SQL Commands.

Q6. Differentiate between DDL and DML Commands.

Q7. Identify the DML Commands from the following :

  1. Create
  2. Alter
  3. Insert
  4. Delete

Q8. __________ is the most commonly used Data Manipulation Language(DML) command.

SQL Commands Class 10 IT Code 402

Q9. Name two clauses which can be used with Select Command.

Q10. Write the Select command to display all the records of table “book”.

Q11. Write the shortcut to execute query in “Create query in SQL view” of Base.

Q12. What is the purpose of Where clause in Select Command?

SQL Commands Class 10 IT Code 402

Q13. What is the purpose of Order by clause in Select Command?

Q14. Write the queries for the following table : Emp

Emp_idEnameSalary
1Suman20000
2Sanjay32000
3Ravi30000
SQL Commands Class 10

a. Display the salary of all the employees after incrementing by Rs 1000.

b. Display the Employee id and salary of all the employees after decreasing by Rs 500.

c. Display the Name and salary of all the employees after incrementing it as thrice the amount of present salary.

d. Display the Employee id, Name and salary of all the employees after decrementing it as half the amount of present salary.

e. Display the Employee id and Name of all the employees.

SQL Commands Class 10 IT Code 402

Q15. Write the queries for the following table : Student

AdmnoNameClassHouse
1001Sonam9Blue
1002Ravi10Yellow
1003Poonam10Green
SQL Commands Class 10

a. Display the entire table

b. Display the list of students whose house color is blue.

c. Display the admission number of students whose house color is green.

d. To view records in ascending order of Admission Number.

e. Display the records of Class 10 Students.

f. Display the class of ‘Ravi’

g. Insert the given record : 1004, “Aman”, 11, “Blue”

SQL Commands Class 10 IT Code 402

Q16. Which command is used for the following task in database?

  1. To insert a new record
  2. To modify the existing data.
  3. To delete a record
  4. To display record

Q17. Write the queries for the following table : Item

ItemnoInamePriceQty
12Pen1017
13Eraser515
14Notebook1520
SQL Commands Class 10

a. Write a query to insert a new record of following details

15, “Pencil”, 20, 10

b. Write a query to display detail of items whose quantity is more than 10.

c. Write a query to change the quantity of Item number 13 to 25.

d. Display the total amount of each item. The amount must be calculated as the price multiplied by quantity for each item

e. Display the name of item whose price is 10.

f. Display all the records in ascending order of price.

g. Identify the Primary key from table Item.

h. Write the suitable data type of field “Iname”.

i. Write a query to increase the price of all items by Rs2.

j. Write a query to decrease the price of all items by Rs2 whose price is less than 20.

Q18. By default, data is arranged in _________ order using ORDER BY clause.

Q19. Which clause is used for the following:

a. To display specific record.

b. To display records in a particular order.


SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT SYSTEM

SESSION 2: CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS

SESSION 3: PERFORM OPERATIONS ON TABLE

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD



SQL commands Class 10
SQL commands Class 10

SQL Commands Class 10 IT Code 402

Disclaimer : I tried to give you the correct answers of above SQL Commands Class 10 but if you feel that there is some mistake in above SQL Commands, feel free to contact me at csiplearninghub@gmail.com



Share with others

4 thoughts on “Important SQL Commands Class 10 IT Code 402 Questions and Answers Unit 3 RDBMS”

Leave a Reply

error: Content is protected !!
%d bloggers like this: