Information Technology
Class-10
Unit- 3(B) Database Management System (Basic)
A. Multiple Choice Questions:
1. Full form of RDBMS is:
a. Relation Disadvantages Based Management System
b. Relational Database Management System
c. Random Data By Management System
d. Relational Data by Managing System
Answer: Relational Database Management System
2. Information is the collection of;
a. Facts b. Records c. Tables d. Database
Answer: Records
3. The Database Management System is a:
a. Collection of Data b. Software c. Hardware d. File
Answer: Software
4. Which of the following term is not related to DBMS?
a. Table b. Record c. HTML d. Field
Answer: HTML
5. Which of the following is not included in Microsoft office suite?
a. Microsoft word b. Microsoft access c. Microsoft Excel d. Dynamics ERP
Answer: Dynamics ERP
6. Duplication of data is called______________.
a. Consistency b. Inconsistency c. Redundancy d. Foreign key
Answer: Redundancy
7. Which of the following will help to maintain unique record in the table?
a. Foreign key b. Primary key c. Composite key d. Null key
Answer: Primary key
8. A foreign key is a reference of the _________ key in another table.
a. Alternate b. Primary c. Candidate d. Composite
Answer: Primary
9. Primary key cannot accept__________ values.
a. Binary b. Duplicate c. Text d. Numeric
Answer: Duplicate
10. When primary key is made up of two or more columns, then it is called____ primary key.
a. Mixed b. Foreign c. Composite d. Combined
Answer: Composite
11. Which of the following is not a good naming field for the table "Student"?
a. Roll number b. Name c. Fees d. Salary
Answer: Salary
12. A field which is ______________ for each and every record is called Primary key.
a. Common b. Same c. Unique d. Candidate
Answer: Unique
13. Which of the following key define a relationship between two tables?
a. Foreign key b. Primary key c. Composite key d. Alternate key
Answer: Foreign key
B. State T for true or F for false:
1. A Database can have only one Table.
Answer: F
2. DML compiler is a part of DBMS which stands for Data Manipulation Language compiler.
Answer: T
3. A database management system is a software that is used to create and manage database.
Answer: T
4. Primary key can be repeated in table.
Answer: F
5. Column in a table are called records and rows in a table are called fields.
Answer: F
C. Fill in the blanks:
1. _______________ is the information stored in a table in the database.
Answer: Fields and Records
2. Data is stored in a _______________.
Answer: Table
3. ____________ is a set of programs that enables the user to store, retrieve and manage data in a database.
Answer: DBMS
4. MS Access, SQL server and Oracle are examples of ______________.
Answer: DBMS
5. The collection of logically related data is called __________________.
Answer: Database
D. Short Answer Type Questions:
1. What are the advantages of using a database management system?
Answer: The main advantages of DBMS are:
* Processing queries and object management
* Controlling data redundancy
* Sharing of data
* Data consistency
* Integration of data
* Integration constraints
* User friendly
* Control over concurrency
* Backup and recovery procedures
* Data independence
2. What are the disadvantages of using a database management system?
Answer:
* Increased costs
* Management complexity
* Maintaining currency
* Frequent upgrade/replacement cycles.
3. Differentiate between fields and records.
Answer:
Field: A table consists of several records(row), each record can be broken into several smaller entities known as fields. The above employee's table consists of four fields-ID, Name, Age and Salary.
Record: A single entry in a table is called a record or row. A record in a table represents a set of related data.
4. What do you understand by information processing?
Answer: Information processing can refer to the process of analyzing and interpreting information, or the process of acquiring, recording, and using information.
5. What is relational database?
Answer: A relational database refers to a database that stores data in a structured format, using rows and columns. This makes it easy to locate and access specific values within the database. It is relational because the values within each table are related to each other.
6. Define Record and Field.
Answer:
Field: A table consists of several records(row), each record can be broken into several smaller entities known as fields. The above employee's table consists of four fields-ID, Name, Age and Salary.
Record: A single entry in a table is called a record or row. A record in a table represents a set of related data.
7. Distinguish between data and information.
Answer:
Data:
* Data are text and numerical values.
* Data can be collected in un-sequentail manner.
* Data is an input form.
* Data does not help in decision making.
Information:
* Information is the output of processed data.
* Information is presented in a meaningful form.
* Information is an output form.
* Information helps in decision making.
8. List some widely used Relational Database Management Systems.
Answer: Some RDBMS systems are:
* Oracle database
* IBM DB2
* Microsoft SQL
* MySQL
* PostgreSQL
9. What is a primary key?
Answer: The primary key is the most important key in the database. There can be only one primary key in a table. It will not allow duplicate or null values. The primary key contains unique values.
10. What is a foreign key?
Answer: A foreign key can be a common key in two database tables.
11. What is the difference between foreign and primary keys?
Answer:
Primary key: There can be only one primary key in a table. It will not allow duplicate or null values. The primary key contains unique values.
Foreign key: A foreign key can be a common key in two database tables.
12. What is an alternate key?
Answer: The alternate key can be an alternative or a candidate for the primary key when needed, but it is not the primary key. An alternate key is a function of all candidate keys except the primary key.
13. What is the use of super key?
Answer: A super key is a set of one or more keys that are used to identify data or records uniquely in a database table. It includes only those fields that have unique values.
14. What is a flat file?
Answer: A flat file database is a database that stores data in a plain text file. It is the simple but most important type of database that is used to store data in a plain text file.
15. What is the difference between a flat and a database file?
Answer:
Flat File: A flat file database is a database that stores data in a plain text file. It is the simple but most important type of database that is used to store data in a plain text file.
Database File: Database is a data structure that stores data and provides tools to derive organized information. Most database contain multiple tables, which include several different fields.
E. Long Answer Type Questions:
1. What is Database Management System and why do we need it?
Answer: DBMS: Database is a data structure that stores data and provides tools to derive organized information. Most database contain multiple tables, which include several different fields.
The goal of many information systems is to transform data into information in order to generate knowledge that can be used for decision making.
Why do I need Database:
* Excel is great at storing and organizing numbers, RDMS is far stronger at handling non-numerical data, like names and descriptions.
* Relation among the data is not possible to set in excel while RDMS allows it, without relation, getting information from data is not possible.
* A relational database is able to understand how lists and the objects within them relate to one another and can derive information from two or more lists.
2. What are the components of a Database Management System?
Answer: Components of Database Management System:
Users: Users may be of various types such as DB administrator, system developer and End users.
Database application: Database application may be personal, departmental, enterprise and internal.
DBMS: Software that allows users to define, create and manage database access, for example: MS Access, MySql, Oracle, etc.
Database: Collection of logical data.
3. Write a note on information processing.
Answer: Information processing can refer to the process of analyzing and interpreting information, or the process of acquiring, recording, and using information.
Information processing is the way people analyze and interpret information to make decisions or take actions. This process can be automatic or deliberate, and it involves using assumptions, expectancies, and vigilance.
4. What is Relational Database Management System? Define table, record, field, column.
Answer: A relational database refers to a database that stores data in a structured format, using rows and columns. This makes it easy to locate and access specific values within the database. It is relational because the values within each table are related to each other.
Table: A table is a collection of row and column.
Field: A table consists of several records(row), each record can be broken into several smaller entities known as fields. The above employee's table consists of four fields-ID, Name, Age and Salary.
Record: A single entry in a table is called a record or row. A record in a table represents a set of related data.
5. What are the benefits of Relational Database Management System? Explain any three benefits.
Answer: Benefits of Relational Databases:
* Simple Model
* Data Accuracy
* Easy Access to data
* Data integrity
* Flexibility
* High Security
* Future Modifications:
1. Simple Model: A Relational Database system is the simplest model. It does not require any complex structure or querying processes. Due to its simple structure, it can be handled with simple SQL queries and does not require complex queries to be designed.
2. Data Accuracy: In the relational database system, there can be multiple tables related to one another with the use of a primary key and foreign key concepts. This makes the data to be non-repetitive.
3. Flexibility: A Relational Database System is flexible. It can be expanded or reduced as per the requirements. This helps in increasing incoming amount of data, as well as update and deletes wherever required.
6. What is the use of keys in databases? Mention any four types of keys by giving a suitable example for each key.
Answer: A key in DBMS is an attribute or a set of attributes that help to uniquely identify a tuple in a relation. Keys are also used to establish relationships among different tables and columns of a relational database.
Use of Keys in the database:
* Keys are crucial for the arrangement of tables in the database.
* Keys uniquely identify records or a combination of record from huge database tables.
* Database keys are also useful in establishing a relationship between one table with other tables.
These are the following types of keys in DBMS:
1. Primary Key: For example: In the student table, roll number is one such element that can never be the same for two students. Roll number will be the primary key for the student table.
2. Unique Key: For example: Phone number is another unique field and can be used to extract records.
3. Super Key : For example: To form a super key, you can combine any table column with the primary key. In the given example, are super keys.
4. Alternate Key
5. Candidate Key
6. Composite Key
7. Foreign Key
Some other links:
.jpg)
No comments:
Post a Comment