Sunday, 3 January 2021

Worksheet on Database Management Systems - Class 10 / Class 11/Class 12 - Information Technology /Computer Science / Informatics Practices

Worksheet on Database Management Systems

Class 10 - Information Technology  

Class 11/Class 12 - Computer Science / Informatics Practices 

Worksheet on Database Management Systems - Class 10 / Class 11/Class 12 - Information Technology /Computer Science / Informatics Practices


Directions: Fill in the blanks with suitable words.


1 _______ is a collection of related information.


2 _______ are the basic building blocks of a database. 


3 Table is also known as ________


4 In a table, columns are also called ________ and rows are called _________.


5 A field in a table is also called as __________.


6 A set of related data item is called as _________.


7 ________ is the smallest part of a table in which one data item can be kept.


8 A ________ enables users to view, enter and change data directly in database objects such as tables.


9 The different objects supported by MS-Access are tables, queries _________ and reports.


10 The database is managed by a software package known as ________.


11 In database, all the data are stored in __________ location.


12. Software such as  ______, _______, _________ are three popular DBMS.


13 Primary key is used to _________ identify the ‘record in a table.


14 The candidate key, which is not used as primary key is called ________ key.


15 A foreign key is a reference of the __________ key in another table. 


16 ________ is a field which is used as a primary key and numbers each record sequentially.


17 To store object like image, you need to create a field in a table, having field type as ___________


18 In a Text type data field, we can enter a maximum of ______ characters.


19 A __________ is a language that enables users to access and manipulate data in a database.


20 TCL commands are used to manage _______ in database.


21 _______ SQL statement is used to add one or more records to a database. 


22 _______ SQL command is used to retrieve data from database tables. 



Answers:

1. Database

2. Tables

3. file

4. fields, records/tuples

5. column

6. record

7. Field

8. form

9. forms

10.  DBMS

11. centralised

12. MYSQL, MS-Access, Oracle

13. uniquely

14. alternate

15. primary

16. AutoNumber / AutoIncrement

17. OLE Object/ BLOB

18. 255

19. Data Manipulation Language (DML)

20. transactions

21.  Insert

22: SELECT


👉See Also: 

No comments:

Post a comment

We love to hear your thoughts about this post!