Class 9 Computer Science Chapter 6 Database Question Answer, Computer Science Class 9 Solutions, NCERT Class 9 Computer Science Chapter 6 Database for each chapter is provided in the list so that you can easily browse throughout different chapters SCERT Class 9 Computer Science Chapter 6 Database and select needs one.
Class 9 Computer Science Chapter 6 Database
Also, you can read the SCERT book online in these sections Solutions by Expert Teachers as per SCERT (CBSE) Book guidelines. NCERT Solution of Class 9 Computer Science Chapter 6 Database is part of AHSEC All Subject Solutions. Here we have given Class 9 Computer Science Chapter 6 Database Notes for All Subjects, You can practice these here in SEBA Class 9 Computer Science.
Chapter – 6
OBJECTIVE TYPE QUESTIONS
1. Choose the correct option.
(a) DBMS is a
(1) Type of database
(2) Set of computer programs
Ans. (1) Type of database.
(b) Which of the following keys composed of additional fields?
Ans. (4) Alternate.
(c) Which option is used to change the appearance and size of various controls of a Form?
(1) Design View
(2) Form View
(3) Layout View
(4) None of these
Ans. (1) Design View.
(d) Which key defines a relationship between two tables?
(1) Primary key
(2) Candidate key
(3) Secondary key
(4) None of these
Ans. (1) Primary key.
(e) Which icon indicates the edit mode in Access?
(4) None of these
Ans. (3) Pencil.
2. Fill in the blanks.
(a) In ____ database data are stored in multiple tables to remove redundancy.
(b) A candidate key is called ___ key, if it is not designated as primary key.
(c) Microsoft Access is a _____ database.
(d) ____ view displays the table as grid.
(e) ____ allows you to add and update data in a table, one record at a time.
DESCRIPTIVE TYPE QUESTIONS
3. Short answer questions.
1. What is a Database? Give examples.
Ans. Databases often store information about people, such as customers or users.
For example, social media platforms use databases to store user information, such as names, email addresses, and user behavior.
2. What is the need for a database?
Ans. A database system has a set of programs through which users or other programs can access, modify, and retrieve the stored data.
(1) Manages large amounts of data: DBMS allows users to organize large amounts of data in a structured and systematic way. Data is organized into tables, fields, and records, making it easy to manage, store, and retrieve information.
(2) Accurate: A database is pretty accurate as it has all sorts of built-in constraints, checks, etc. This means that the information available in a database is guaranteed to be correct in most cases.
(3) Easy to update data: In a database, it is easy to update data using various Data Manipulation languages (DML) available. One of these languages is SQL.
(4) Data Security and Privacy: Database Management Systems (DBMS) provide a robust security framework that ensures the confidentiality, integrity, and availability of data.
3. Define primary key, Foreign key, Candidate key, Super key.
Ans. Primary key – Is the column or columns that contain values that uniquely identify each row in a table.
Foreign key – Is a column or combination of columns that is used to establish and enforce a link between the data in two tables to control the data that can be stored in the foreign key table.
Candidate key – Is a set of attributes that uniquely identify each row in a table. Candidate key is a super key with no repeated attributes.
Super key – Is a group of single or multiple keys which identifies rows in a table.
4. Differentiate between Flat file database and Relational database.
Ans. The difference between Flat file database and Relational database are:
|Sl. No.||Flat File Database||Relational Database|
|1||Data is stored in one table.||Data is stored in multiple tables and the tables are linked using a common field.|
|2||Flat file Database includes only one file with no structured relationship.||Relational Database includes multiple entities or say objects.|
|3||It is suitable for less amount of data||It is suitable for large amount of data|
|4||It is characterized by means of a data dictionary.||It is characterized by means of schema.|
5. What are data types? List the various types of data types used in Access 2007 and explain any four of them.
Ans. Data types are classifications that identify possible values for and operations that can be done on the data, as well as the way the data in that field is stored in the database.
The Various types of data types used in Access 2007 are as follows –
(1) Auto Number: AutoNumber is a type of data used in Microsoft Access tables to generate an automatically incremented numeric counter.
(2) Text: A Text field can contain values that are text, numeric, or a combination of both. A text field can contain a maximum length of 255 characters.
(3) Memo: Larger version of the text field, allowing storage of up to 2GB of data.
(4) Number: The Number field can store numeric values up to 16 bytes of data.
(5) Date/Time: Use for storing date and time values up to 8 bytes.
(6) Currency: Monetary data, stored with 4 decimal places of precision.
(7) Yes/No: Use for Boolean values: Yes/No, True/False, or On/Off. Size Up to 1 gigabyte
(8) OLE Object: Use for storing OLE objects from other Microsoft Windows programs.
6. What is a query? Explain the parts of a query window.
Ans. In general, a query is a request for data or information from a database table. In the context of queries in a database, it can be either a select query or an action query.
There are two major parts of the query –
(1) Design Area: also known as a top portion which displays tables, fields, or subqueries you may want to use in a query.
(2) Grid: also known as a lower portion which contains columns where the user can set up the fields.
7. What do you understand by criteria?
Ans. This property contains the condition on the basis of which the records will be filtered in the Query output.
Hi, I’m Dev Kirtonia, Founder & CEO of Dev Library. A website that provides all SCERT, NCERT 3 to 12, and BA, B.com, B.Sc, and Computer Science with Post Graduate Notes & Suggestions, Novel, eBooks, Biography, Quotes, Study Materials, and more.