Home > CBSE IT 402 > Quizzes > IT 402 Unit 3 RDBMS Class 10 Practice Test
IT 402 Unit 3 RDBMS Class 10 Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 20% Most missed: “Which of the following is not the category of Open Office data type?”

A relational database management system (RDBMS) is a program used to create, update, and manage relational databases. Some of the most well-known RDBMSs include MySQL, PostgreSQL, MariaDB, Microsoft SQL Server, and Oracle Database.

IT 402 Unit 3 RDBMS Class 10 Practice Test
Time left 00:00
25 Questions

1. Can we insert records in table using Form.
2. ______________statement is used to remove one or more records in a Database.
3. In which mode we can change the structure of table?
4. A _____________helps to display the data in a summarized data.
5. Which of the following column has sorted data?
Rollno          Name              Salary
3                 Amit              2500
5                  Ashu              3200
9                 Anil              3000
6. Which command is used to create table?
7. A _______helps to collect specific information from the pool of data.
8. DBMS stands for _________
9. Which of the following is not a numeric data type?
10. Database Management System automatically takes care of backup and recovery.
11. Which of the following clauses can be used with SELECT statement?
12. In tables, data is organized in the form of rows and columns.
13. Which command is used to delete data from table?
14. select * from Stud order by “Rollno” ASC;
15. By default the length of Varchar data type is __
16. There can be multiple primary key in a table.
17. Steps to delete a record from table are given below. Arrange them in order.1. Select the delete option.
2. Open the table.
3. Right click on selected data.
4. Select the data.
18. Dhriti wants to store the details of students as well as their pictures in a table named “school”. She is confused about the data type used to store pictures. Suggest her the suitable data types from the following.
19. Parth is a student of class X. He is working in Open Office Base. He created a table but forgot to create the primary key. Does Open Office Base automatically create the primary key. If yes then what would be the default name of primary key?
20. In the RDBMS data can be integrated using ________
21. Queries are commands that are used to define the structure and modify the data in a table.
22. What is the default value of field property ‘Entry Required’?
23. Which toolbar help us to move from one record to another in a form?
24. In Base data can be linked between two or more tables with the help of _________________
25. Which of the following act as an interface to view, enter and change data in database?