Important Questions of Database Management System Class 10 IT 402 RDBMS(Basic) Session 2

Share with others

Database Management System Class 10

Session 2 : Create and Edit Tables using Wizard and SQL Commands

Database Management System Class 10

Q1. What do you mean by RDBMS?

Q2. Define the following terms :

1 Table

2. Fields

3. Records

Database Management System Class 10

Q3. What are the two ways of creating table in OpenOffice Base.

Q4. What do you mean by Data type? Give example of two data type used in OpenOffice Base.

Database Management System Class 10

Q5. Identify the data type in which we can store the decimal value :

a. Boolean

b. TinyInt

c. Decimal

d. Real

e. Double

f. Smallint

Q6. What is the difference between Char and Varchar data type?

Database Management System Class 10

Q7. Write the data type suitable for the following fields.

a. DateofBirth

b. Name

c. Rollno

d. Class

e. Email

f. City

Q8. Write four data types available in Alphanumeric Data types.

Q9. Data in a (RDBMS) is organized in the form of __________________.

Database Management System Class 10

Q10. In RDBMS table is also known as ________________

Q11. Write four data types which are used to store numerical value.

Q12. Write four appropriate field names and their data types to store record of student.

Q13. Write four appropriate field names and their data types to store record of book.

Q14. What is the default data type of a field while creating table in design view?

Q15. _______________ are the basic building blocks of a database.

Q16. Write the expanded form of SQL

Q17. A table has __________________ (horizontal / Vertical) row and ____________________ columns (horizontal / Vertical).

Q18. OpenOffice Base is an open source _________________ (DBMS / RDBMS )

Q19. ________________ (Database / Table ) wizard helps you to create a new database.

Q20. Multiple tables can be created in a database. (T / F)


Disclaimer : I tried to give you the correct “Database Management System Class 10” Questions and Answers but if you feel that there is/are some errors in above questions or answers of “Database Management System Class 10” feel free to mail me directly at csiplearninghub@gmail.com


Important Links


Share with others

Leave a Reply

%d bloggers like this: