Ch-3 (DBMS)

1. Which of the following best defines "information"?

(a) Unprocessed raw facts such as names, marks, and addresses.
(b) Organized and processed data that provides meaningful insights.
(c) Audio, video, and graphics stored without any processing.
(d) A collection of unrelated raw facts.
2. What does referential integrity in a database ensure?
(a) All primary keys are unique across the database.
(b) All records in a table must have a value in every column.
(c) Every foreign key value must match a primary key in the referenced table or be null.
(d) Data can be freely deleted from any table without constraints.

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. Which of the following statements are true about primary key in a database?
(a) It is a field that can have duplicate values.
(b) It uniquely identifies each record in a table.
(c) It can have null values
(d) It is an optional field in a database table.
5. Which of the following dialog boxes appears when the Query Design window is opened for the
first time to design a query?
(a) Add Table (b) Add Query
(c) Add Query or Report (d) Add Table or Query
6. What feature in OpenOffice Base allows users to present retrieved data in a user-friendly and
formatted manner?
(a) Query (b) Form
(c) Report (d) Data view
7. It enables users to view, enter, and change data directly in database objects.
a. Report b. Query
c. Form d. Database
8. There are _______ types of Relationships in a table of a database.
a. One b. Three
c. Four d. Many
9. _________ means that the query uses criteria you provide to hide some data and display only
required data.
a. Filtering b. Report
c. Sorting d. Forms
10. Which of the following application is not appropriate to store data about ABC Bank customers?
a. Open Office Base c. Open Office Writer
c. MS Access d. MS Excel
11. Multiple copies of the same file leads to _________.
a. Data Inconsistency b. Data Redundancy
c. Data Consistency d. Foreign Key
12. Identify the property which help to set the number of characters in text/ varchar type field of a table
in DBMS.
a. Entry Required b. Size
c. Default Value d. length
13. The length of the field value of text data type is _____ characters by default in DBMS.
a. 10 b. 25
c. 20 d. 50
14. Identify the mode, where we can modify in the structure of table?
a. Datasheet view b. Design view
b. Structure view d. All of the above
15. __________ store data in a single table which is suitable to store less amount of Data.
a. Flat File b. Relational
c. Mini File d. Single File
16. ___________ database is a type of database that stores data in several tables.
a) Flat b) Relational
c) both (a) and (b) d) None of them
17. In database _________ helps us to retrieve the filtered data based upon some conditions.
a) Forms b) Reports
c) Queries d) Table

18. Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the
field property for this purpose.
a) Length b) Default
c) Entry Required d) Format
19. ___________ can be set for a field if the user doesn't provide any value while entering the values in
the table.
a) Required b) Default
c) Primary Key d) Format
20. Aadya wants to create a connection between two or more tables. Suggest her the option to
accomplish the task.
a) Table b) Form
c) Relationships d) Sorting
21. _____________ data type takes the values in the form of 0 and 1 in the database.
a) Integer b) Text
c) Boolean d) Memo
22. A Relational database uses _____________ commands which is a standard user application that
provides an easy programming interface for database interaction.
a. Access b. Python
c. SQL d. Protocol
23. Suraj wants to create a database for his clients. For this purpose, she needs to store the Email IDs of
his clients. Which datatype should he use to accomplish this purpose?
a. Numeric b. Varchar
c. Binary d. Boolean

24. A table can have only _________ primary key in a database.

a. 1 b. 2
c. 3 d. Many

Subjective Question Answers

1. In a database, why is it important to create relationships between the tables?
2. A health clinic is developing a patient management system to streamline patient intake,
appointments, and medical records. They need to implement forms for various purposes,
including new patient registration, appointment scheduling, and updating medical histories.
a) What is the use of form in DBMS?
b) What are the different ways to create forms in DBMS?
c) Where can we find various tools to add or edit controls on the form?
d) What is the use of the Records Toolbar in a form?
Ans. a) A form is an object of the database that has a user-friendly interface where data can be entered
and seen in an attractive and easy-to-read format. For any database, it is the front end for data
entry and data modification
b) There are two ways to create a form:
• Using a wizard
• Using the Design View
c) Forms Control Toolbar
d) The Records toolbar contains the navigation control buttons in the extreme left. With the
help of these buttons, we can traverse and view the records in the file
3. Your cousin runs a small bookstore and wants to maintain an inventory of books. He needs to
record information such as book titles, authors, ISBNs, publication dates, prices, and stock
levels. However, he is not familiar with database management systems. Explain the following
concepts to help him understand DBMS:
a) What is DBMS?
b) What are the advantages of using DBMS?
c) Name any two database programs that can be used to create a table and store the data
according to his requirements.
d) Which field can be set as a Primary Key?
Ans. a) A Database Management System (DBMS) is software that helps users create, manage, and
manipulate databases. It allows for efficient data storage, retrieval, and organization.
b) Advantages of using DBMS:
● Data Integrity: Ensures accuracy and consistency of data.
● Data Security: Provides access controls to protect sensitive information.
● Reduced Data Redundancy: Minimizes duplication of data across the database.
● Data Management: Simplifies data handling through structured query language (SQL).
c) Two database programs:
● MySQL
● Open Office Base
d) The ISBN (International Standard Book Number) can be set as a primary key, as it uniquely
identifies each book in the inventory.]
4. Explain the term “Referential Integrity”. Why is it important in a database?
Ans. Referential integrity ensures that relationships between database tables remain valid by requiring
that a foreign key in one table always references a valid, existing primary key in another table. For
example, in a "Customers" and "Orders" database, if a customer is deleted, referential integrity
 prevents an order from being left with no customer by either deleting the order or preventing the
customer's deletion. This is managed using foreign keys, which are like "bridges" that link records
in different tables, and their values must match a corresponding primary key in the linked table.
5. Your friend owns a chemist shop, he needs to keep records of the medicines with their id’s,
date of purchase, expiry date, price, etc. in a database program. But he does not have any
knowledge about the database. Explain to him the following to get a better understanding
of the DBMS concepts.
1. What is DBMS? Explain in brief.
2. Name any two database programs which can be used to create a table and store the data as
per the requirement.
3. Which field can be set as a Primary Key?
4. Is it possible to make more than one field as a primary key in your table? (Yes/No). Justify
your
Ans.
1. A database management system is a software package with computer programs that controls the
creation, maintenance, and use of a database. It allows organizations to conveniently develop
databases for various applications.
2. Two databases are: i. Microsoft Access ii. MySQL iii. OpenOffice Base
3. Id field will be suitable for Primary Key.
4. Yes, we can make more than one column as a primary key in a table and it is known as
Composite Primary Key.
6. List Numeric and Alphanumeric Datatypes in OpenOffice Base.
Ans.
Numeric datatypes are: TinyInt, SmallInt, Integer, BigInt, Decimal, Real, Float, Double and Boolean.
Alphanumeric Datatypes are: Char(fix), Varchar, Varchar_ignorecase and Longvarchar(Memo).

7. What is Referential Integrity? Explain its two(any) purposes.

Ans. Referential integrity is a database concept that ensures relationships between tables remain valid
and consistent by requiring that foreign key values match existing primary key values in the related
table. Its purposes include preventing orphan records, which are records that reference non-existent
data, and ensuring data accuracy, which means all data in the database is reliable and trustworthy.
8. How Entry Required and Default Value properties of a table field in a database are different
from each other?
Ans. Entry Required (or Required Field):
This property dictates whether a value must be provided for a specific field when a new record is
created or an existing record is updated.
If "Entry Required" is set to "Yes" (or equivalent), the field cannot be left blank or null. The database
system will enforce this rule and prevent the record from being saved if the required field is empty.
Default Value properties:-This property specifies a value that will be automatically inserted into a field
if no explicit value is provided during data entry for a new record.

9. What is DBMS? Explain any two advantages of DBMS.

Ans. A database management system is a software package with computer programs that controls the
creation, maintenance, and use of an integrated collection of data records, files, and other objects.
It allows organizations to conveniently develop databases for various applications.
Advantages:
i) Data Integrity: means the data is accurate and consistent in the database. It is very important as
there are multiple databases in a DBMS so it helps to produce the correct result.
ii) Data Sharing: In a database, the users can share the data among themselves. Data can be shared
for multiple purposes with the users located at different geographical locations then remote users
can also access the database simultaneously.
10. Differentiate between Primary key and Foreign key.
Ans. A primary key is a unique value that identifies a row in a table whereas a foreign key identifies a
column or set of columns in one (referencing) table that refers to a column or set of columns in
another (referenced) table. A table can have only one primary Key but a table can have multiple
foreign keys.
11. Differentiate between one to one relationship and one to may relationship. Give
suitable examples to explain your answer.
Ans. A one-to-one relationship represents a situation in which one data value can have only one
associated element. A one-to-many relationship, on the other hand, can have any
number of associated elements. For example, suppose a database has the following
fields specific to people in the database: Social Security Number.
12. Explain many to many relationship with an example.
Ans. A many-to-many relationship exists when one or more items in one table can have a
relationship to one or more items in another table. For example: Your Order table contains
orders placed by multiple customers (who are listed in the Customers table), and a
customer may place more than one order.
13. What is the use of Alias row in the Design grid of the query Design window?
Ans. In the query design grid, the alias row is used to give an alternate name to a field, which
appears as the column heading in the query output.
14. Name the two ways to create a form in OpenOffice Base.
Ans. 1. Create Form in Design View with [Link] BASE.
2. Use the Wizard to Create Forms with [Link] BASE.
15. How can we define a primary key in a table?
Ans. Step 1: Open a table in Design view.
Step 2: Select the field or fields you want to define as the primary key or click the row
selector for the desired field.
Step 3: Click Primary Key on the toolbar.
[Link] between- (a) Memo and Varchar datatype:
Memo: Used for storing large text data, typically more than 255 characters. Common in
databases like Microsoft Access.
Varchar: Variable character data type used in SQL databases to store text strings of varying
lengths, up to a specified limit (e.g. varchar(255))
(b) Number and Decimal data type- NUMERIC will only go to the specified number of
decimals,while DECIMAL will be at least that exact, if not more so. For example, if the
number of decimals indicated was 2, and your data point was 5.323, NUMERIC would
call that 5.32,while DECIMAL would go to 5.323.
(c) Design View and Datasheet View of a table:- A design view provides access to create or
modify tables, forms, or any other database objects. Whereas in datasheet view all these
functions cannot be seen easily.