Unit 3: Database Management System using LibreOffice Base
Chapter-8: Introduction to Database Management System
A. Multiple choice questions
1. Which of the following is NOT a DBMS?
(a) MS Access
(b) Open Office Base
(c) MS Excel
(d) MySQL
2. DBMS stands for ______________________.
(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi System
3. Which of the following data models sets a relation between the two or more
tables?
(a) Relational Data Model (b) Network Data Model
(c) Hierarchical Data Model (d) Connection Data Model
4. The details associated with an entity are called ____________ .
(a) Table (b) Attributes
(c) Records (d) Primary key
5. In which of the following forms can a data value be represented?
(a) Numeric (b) Character
(c) Alphanumeric (d) All of the above
6. Which of the following uniquely identifies a row in a table?
(a) Primary key (b) Alternate key
(c) Foreign key (d) Candidate key
7. A ___________is a feature of a database using which we can enter data in a
table in an easy and user friendly manner.
(a) query (b) report
(c) form (d) field
8. A _____________ is a question asked from a database.
(a) query (b) report
(c) form (d) field
B. State whether the given statements are True or False
1. A database cannot be organised. FALSE
2. Data is the collection of raw facts. TRUE
3. A table can be created without a primary key. FALSE
4. Two tables can be related in a network data model. FALSE
5. MS Access is an example of a database. FALSE
C. Fill in the blanks
1. The raw facts constitutes Data.
2. An Entity is a real world object about which information is to be stored in a
database.
3. The output of a query may be displayed in the form of Report.
4. The data values for all the fields related to a person or object is called a
Record.
5. All the field values that are eligible to be the primary key are the candidate
keys for that table.
D. Short answer type questions
1. Define the terms
(a) Database
(b) Data redundancy
(c) Report
Ans. (a) Database: A database is a collection of logically related data items
stored in an organized manner.
.
(b) Data redundancy: Duplication of record is called data redundancy.
(c) Report: A report is the formatted result of query which contain data
required for decision making and analysis.
2. Give one point of difference between
(a) Data and Information
(b) Form and Query
(c) Network and hierarchical data model
Ans.
(a)
Data Information
Raw facts and figures is called Processed data is called information
data
(b)
Form Query
A form is a feature of a database A query is used to retrieve the desired
using which we can enter data in information from the database.
a table in an easy and user
friendly manner.
(c)
Network data model Hierarchical data model
To organize records, it uses graphs. To organize records, it uses tree
structure.
Searching for a record is easy When you are searching for a record
because of the availability of then firstly you need to visit parent
multiple access paths to reach data record before retrieving a child
item. record.
3. Give any four advantages of a DBMS.
Ans. Advantages of DBMS are:
4. Consider the table given below and answer the questions that follow
Ans.
(a) Fields in the table are:
1) Book_Id
2) Book Name
3) Author Name
4) Price
5) Publisher
(b) Book_Id
(c) Book Name
(d)
Primary Key Foreign Key
It is a field which uniquely identifies the The foreign key identifies a column or
records. set of columns in one (referencing) table
that refers to a column or set of columns
in another (referenced) table.
It can not have NULL values It can have NULL values
For example,
