database management system CBSE class 10 IT notes (2MCQ SET & 1 DESCRIPTIVES SET)
database management system CBSE class 10 IT notes (2MCQ SET & 1 DESCRIPTIVES SET) OBJECTIVE QUESTIONS (SET 01) 1. What is the purpose of a form in a database? a. Form is systematic way of storing information into the table. b. Form is used to display information. c. Both a) and b) d. None of the above. Ans: a. Form is systematic way of storing information into the table. 2. Which SQL command will increase the salary of all employees by 5000? (Table name is emp and column name is salary). a. UPDATE emp SET sal = salary + 5000; b. UPDATE SET sal = salary + 5000; c. UPDATE emp SET salary = 5000; d. None of the above. Ans: a. UPDATE emp SET sal = salary + 5000; 3. What is the purpose of the SQL query: “SELECT * FROM Stud ORDER BY Rollno ASC;”? a. Display all record in ascending order followed by Rollno b. To display all the records of the table. c. Both of the above. d. None of the above. Ans: a. Display all record in ascending order followed by Rollno 4. W