{"id":4970,"date":"2024-05-04T19:45:33","date_gmt":"2024-05-04T14:15:33","guid":{"rendered":"https:\/\/cbsepython.in\/?p=4970"},"modified":"2024-05-19T12:31:24","modified_gmt":"2024-05-19T07:01:24","slug":"database-management-system-question-answer-class-10","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/database-management-system-question-answer-class-10\/","title":{"rendered":"Chapter 8 Introduction to Database Management System Question Answer Class 10 IT using LibreOffice Base"},"content":{"rendered":"

Database Management System Question Answer Class 10<\/span><\/h2>\n

A. Multiple choice questions<\/strong><\/span><\/p>\n

1. Which of the following can be considered as an example of a database?<\/strong><\/span><\/p>\n

(a) Dictionary<\/span>
\n(b) Telephone directory<\/span>
\n(c) Marks Register<\/span>
\n(d) Newspaper<\/span><\/p>\n

Answer:(b) Telephone directory<\/strong><\/span><\/p>\n

 <\/p>\n

2. Which of the following is NOT a DBMS?<\/strong><\/span><\/p>\n

(a) MS Access<\/span>
\n(b) Open Office Base<\/span>
\n(c) MS Excel<\/span>
\n(d) MySQL<\/span><\/p>\n

Answer:(c) MS Excel<\/strong><\/span><\/p>\n

 <\/p>\n

3. DBMS stands for ______________________.<\/strong><\/span><\/p>\n

(a) Data and Books Management System<\/span>
\n(b) Database Management System<\/span>
\n(c) Duplicate Books Management System<\/span>
\n(d) Data Management Multi System<\/span><\/p>\n

Answer:(b) Database Management System<\/strong><\/span><\/p>\n

 <\/p>\n

4. Which of the following data models sets a relation between the two or more tables?<\/strong><\/span><\/p>\n

(a) Relational Data Model<\/span>
\n(b) Network Data Model<\/span>
\n(c) Hierarchical Data Model<\/span>
\n(d) Connection Data Model<\/span><\/p>\n

Answer:(a) Relational Data Model<\/strong><\/span><\/p>\n

 <\/p>\n

5. The details associated with an entity are called ____________.<\/strong><\/span><\/p>\n

(a) Table<\/span>
\n(b) Attributes<\/span>
\n(c) Records<\/span>
\n(d) Primary key<\/span><\/p>\n

Answer:(b) Attributes<\/strong><\/span><\/p>\n

Database Management System Question Answer Class 10 IT<\/span><\/h3>\n

6. A __________ is represented as rows in a table.<\/strong><\/span><\/p>\n

(a) field<\/span>
\n(b) attribute<\/span>
\n(c) record<\/span>
\n(d) candidate key<\/span><\/p>\n

Answer:(c) record<\/strong><\/span><\/p>\n

 <\/p>\n

7. In which of the following forms can a data value be represented?<\/strong><\/span><\/p>\n

(a) Numeric<\/span>
\n(b) Character<\/span>
\n(c) Alphanumeric<\/span>
\n(d) All of the above<\/span><\/p>\n

Answer:(d) All of the above<\/strong><\/span><\/p>\n

 <\/p>\n

8. Which of the following uniquely identifies a row in a table?<\/strong><\/span><\/p>\n

(a) Primary key<\/span>
\n(b) Alternate key<\/span>
\n(c) Foreign key<\/span>
\n(d) Candidate key<\/span><\/p>\n

Answer:(a) Primary key<\/strong><\/span><\/p>\n

 <\/p>\n

9. A ___________is a feature of a database using which we can enter data in a table in an easy and user friendly manner.<\/strong><\/span><\/p>\n

(a) query<\/span>
\n(b) report<\/span>
\n(c) form<\/span>
\n(d) field<\/span><\/p>\n

Answer:(c) form<\/strong><\/span><\/p>\n

 <\/p>\n

10. A _____________ is a question asked from a database.<\/strong><\/span><\/p>\n

(a) query<\/span>
\n(b) report<\/span>
\n(c) form<\/span>
\n(d) field<\/span><\/p>\n

Answer:(a) query<\/strong><\/span><\/p>\n

Database Management System Question Answer Class 10<\/strong><\/span><\/p>\n

B. State whether the following statements are True or False<\/strong><\/span><\/p>\n

1. A database cannot be organised. [False]<\/strong><\/span><\/p>\n

2. Data is the collection of raw facts. [True]<\/strong><\/span><\/p>\n

3. A table can be created without a primary key.[False]<\/strong><\/span><\/p>\n

4. Two tables can be related in a network data model.[False]<\/strong><\/span><\/p>\n

5. MS Access is an example of a database.[False]<\/strong><\/span><\/p>\n

Database Management System Question Answer Class 10 IT<\/span><\/h3>\n

C. Fill in the blanks<\/strong><\/span><\/p>\n

1. The raw facts constitutes _____________.<\/span><\/p>\n

Data <\/strong><\/span><\/p>\n

 <\/p>\n

2. An _____________ is a real world object about which information is to be stored in a database.<\/span><\/p>\n

Entity <\/strong><\/span><\/p>\n

 <\/p>\n

3. The output of a query may be displayed in the form of ________.<\/span><\/p>\n

Report <\/strong><\/span><\/p>\n

 <\/p>\n

4. The data values for all the fields related to a person or object is called a _________.<\/span><\/p>\n

Record <\/strong><\/span><\/p>\n

 <\/p>\n

5. All the field values that are eligible to be the primary key are the ___________ keys for that table.<\/span><\/p>\n

Candidate<\/strong><\/span><\/p>\n

Database Management System Question Answer Class 10<\/strong><\/span><\/p>\n

D. Answer the following questions<\/strong><\/span><\/p>\n

1. Define the terms<\/span><\/strong><\/p>\n

(a) Database<\/span><\/strong><\/p>\n

Answer:\u00a0 <\/strong>A database is an organized collection of structured data stored electronically in a computer system. It allows for efficient retrieval, insertion, and management of data.<\/span><\/p>\n

 <\/p>\n

(b) Data redundancy<\/span><\/strong><\/p>\n

Answer: <\/strong>Data redundancy refers to the unnecessary repetition of data within a database or data storage system. This can lead to inconsistencies and increased storage costs.<\/span><\/p>\n

(c) Report<\/span><\/strong><\/p>\n

Answer: <\/strong>A report is a formatted and organized presentation of data extracted from a database, typically used for analysis, decision-making, and communication of information.<\/span><\/p>\n

Database Management System Question Answer Class 10 IT<\/span><\/h3>\n

2. Give one point of difference between<\/span><\/strong><\/p>\n

(a) Data and Information<\/span><\/strong><\/p>\n

Answer:<\/strong><\/span><\/p>\n

Data:<\/strong> Raw, unprocessed facts and figures without context (e.g., numbers, dates).<\/span><\/p>\n

Information:<\/strong> Processed data that is meaningful and useful for decision-making (e.g., a sales report derived from raw sales data).<\/span><\/p>\n

 <\/p>\n

(b) Form and Query<\/span><\/strong><\/p>\n

Answer:<\/strong><\/span><\/p>\n

Form:<\/strong> A user interface in a database that allows users to enter and modify data easily.<\/span><\/p>\n

Query:<\/strong> A request to retrieve specific data from a database, often using a structured query language (SQL).<\/span><\/p>\n

 <\/p>\n

(c) Network and hierarchical data model<\/span><\/strong><\/p>\n

Answer:<\/strong><\/span><\/p>\n

Network Data Model:<\/strong> Data is organized in a graph, allowing many-to-many relationships. It is more flexible in representing complex relationships.<\/span><\/p>\n

Hierarchical Data Model:<\/strong> Data is organized in a tree-like structure, where each child record has only one parent, representing a one-to-many relationship.<\/span><\/p>\n

Database Management System Question Answer Class 10 IT<\/span><\/h3>\n

3. Give any four advantages of a DBMS.<\/span><\/strong><\/p>\n

Answer:<\/strong><\/span><\/p>\n

i) Data Integrity and Accuracy:<\/strong> Ensures data is accurate, consistent, and reliable by enforcing rules and constraints.<\/span><\/p>\n

ii) Data Security:<\/strong> Provides robust security features to control access and protect data from unauthorized access.<\/span><\/p>\n

iii) Data Redundancy Elimination:<\/strong> Minimizes data redundancy by ensuring data is stored only once, reducing storage costs and inconsistencies.<\/span><\/p>\n

iv) Efficient Data Management:<\/strong> Facilitates efficient data retrieval, updates, and management through optimized query processing and indexing techniques.<\/span><\/p>\n

 <\/p>\n

4. Consider the table given below and answer the questions that follow<\/span><\/strong><\/p>\n

Table: Library<\/strong><\/span><\/p>\n

\"Database<\/span>
\n(a) Name the fields in the given table.<\/span><\/strong><\/p>\n

Answer: <\/span><\/strong><\/p>\n

– Book_Id
\n– Book Name
\n– Author Name
\n– Price
\n– Publisher<\/span><\/p>\n

(b) Which field should be made the primary key?<\/span><\/strong><\/p>\n

Answer: <\/span><\/strong>The Book_Id field should be made the primary key because it uniquely identifies each record in the table.<\/span><\/p>\n

 <\/p>\n

(c) Is there any alternate key in the table?<\/span><\/strong><\/p>\n

Answer:\u00a0 <\/span><\/strong>An alternate key is a field (or combination of fields) that can be used to uniquely identify records but is not chosen as the primary key. In this case, Book Name could serve as an alternate key if every book has a unique name.<\/span><\/p>\n

(d) How is primary key different from foreign key? Explain with example.<\/span><\/strong><\/p>\n

 <\/p>\n

You May also Check:<\/span><\/h2>\n

Class 10 IT 402 Chapter wise Important Questions<\/span><\/h3>\n

Unit 1: Digital Documentation (Advanced) using LibreOffice Writer<\/span><\/h3>\n

Chapter 1:<\/strong><\/span>\u00a0Introduction to Styles<\/a><\/p>\n

Chapter 2:<\/strong><\/span>\u00a0Working with Images<\/a><\/p>\n

Chapter 3:<\/strong><\/span>\u00a0Advanced Features of Writer<\/a><\/p>\n

 <\/p>\n

Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc<\/span><\/h3>\n

Chapter 4:<\/strong><\/span>\u00a0Analyse Data using Scenarios and Goal Seek<\/a><\/p>\n

Chapter 5:<\/strong><\/span>\u00a0Using Macros in Spreadsheet<\/a><\/p>\n

Chapter 6:<\/strong><\/span>\u00a0Linking Spreadsheet Data<\/a><\/p>\n

Chapter 7:<\/strong><\/span>\u00a0Share and Review a Spreadsheet<\/a><\/p>\n

 <\/p>\n

Unit 3: Database Management System using LibreOffice Base<\/span><\/h3>\n

Chapter 9:<\/strong><\/span>\u00a0Starting with LibreOffice Base<\/a><\/p>\n

Chapter 10:<\/strong><\/span>\u00a0Working with Multiple Tables<\/a><\/p>\n

Chapter 11:<\/strong><\/span>\u00a0Queries in Base<\/a><\/p>\n

Chapter 12:<\/strong><\/span>\u00a0Forms and Reports<\/a><\/p>\n

 <\/p>\n

Unit 4: Maintain Healthy, Safe and Secure Working Environment<\/span><\/h3>\n

Chapter 13:<\/strong><\/span>\u00a0Health, Safety and Security at Workplace<\/a><\/p>\n

Chapter 14:<\/strong><\/span>\u00a0Workplace Quality Measures<\/a><\/p>\n

Chapter 15:<\/strong><\/span>\u00a0Prevent Accidents and Emergencies<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Database Management System Question Answer Class 10 A. Multiple choice questions 1. Which of the following can be considered as an example of a database? (a) Dictionary (b) Telephone directory (c) Marks Register (d) Newspaper Answer:(b) Telephone directory   2. Which of the following is NOT a DBMS? (a) MS Access (b) Open Office Base […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-4970","post","type-post","status-publish","format-standard","hentry","category-information-technology-for-cbse-class-10"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/4970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=4970"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/4970\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=4970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=4970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=4970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}