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)
SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT SYSTEM
SESSION 3: PERFORM OPERATIONS ON TABLE
SESSION 4: RETRIEVE DATA USING QUERY
SESSION 5: CREATE FORMS AND REPORTS USING WIZARD
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
