Worksheet on Database Management Systems
Class 10 - Information Technology
Class 11/Class 12 - 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
No comments:
Post a Comment
We love to hear your thoughts about this post!
Note: only a member of this blog may post a comment.