Chapter-8
Introduction to Database Management System
Question 5:
Ms Access is an example of a database.
Answer: True
Chapter-9
Starting with LibreOffice Base
D. Answer the given questions
1. Differentiate between:
a) Memo and Varchar data type:
Ans: Memo: i) Stores up to the maximum length indicated by user.
ii) It is used to store long alphanumeric data.for example summary of a book,
review of a movie etc
iii) It is used to store some descriptive data having more than 255 characters.
iv) Memo data type allows to store text data up to 64,000 characters.
Varchar: i) Stores up to the specified length.
ii) It is used to store small alphanumeric data. for example name, address etc.
iii) The number of bytes allocated depends on the number of characters entered
by the user.
iv) It can store text data up to 255 character.
b) Number and Decimal data type:
Number: i) Used for general numeric values, including both signed and unsigned
values.
ii) Can handle a wide range of values.
Decimal data type: i) Designed for precise numeric values with a fixed number of
decimal Place, including both signed and unsigned values.
ii) Can handle a wide range of values.
c) Design View: i) Design view provides access to create or modify tables, forms, or any
other database objects.
ii) Whereas in Datasheet view all these functions cannot be seen easily
Datasheet View: i) Used to enter, edit, and view data in the table, displaying data in a
grid format similar to a spreadsheet.
ii) The format of the data cannot be changed.
2. Name the menu items present on the Base User Interface.
Ans: The various components of the Base User Interface are as follows:
i)Title Bar
ii)Menu Bar ( File,Edit,View,Insert,Tools,Window and Help)
iii)Standard Toolbar
iv) Status Bar
Chapter 10
Working with Multiple Tables
Q 6. Consider the following tables. Which type of relationship can be
established between the two tables?
Ans. (c ) Many-to-many
Chapter 11
Queries in Base
Chapter 12
Forms and Reports
