Data refers to raw,
unorganized facts or figures without context, such as numbers, names, or dates.
Information is processed, organized, or structured data that is meaningful and
useful, such as a report showing sales data.
2. What is a database?
List any four databases.
A database is a
collection of organized data that can be easily accessed, managed, and
updated.
Examples of
databases:
- MySQL
- PostgreSQL
- MongoDB
- Oracle
Database
3. What is DBMS? List
any four DBMS software.
DBMS (Database
Management System) is a software tool used to create, manage, and manipulate
databases.
Examples of DBMS
software:
- Microsoft
Access
- SQLite
- IBM Db2
- MariaDB
4. List any four
advantages of DBMS.
- Reduces data
redundancy
- Ensures data
consistency
- Facilitates easy data
retrieval
- Enhances data
security
5. What is RDBMS? List
any two RDBMS software.
RDBMS (Relational
Database Management System) stores data in tabular form, establishing
relationships between tables.
Examples of RDBMS
software:
- MySQL
- Microsoft SQL
Server
6. What is MS-Access?
List the four objects of MS-Access.
MS-Access is a database
management tool from Microsoft used for creating and managing
databases.
Four objects of
MS-Access:
- Tables
- Queries
- Forms
- Reports
7. What is a database
file? What is its extension?
A database file is a
file that stores data in an organized manner for a database. Its common
extension is `.accdb` for MS-Access or `.db` for SQLite.
8. What is a
table?
A table is a collection
of rows and columns in a database where data is stored in a structured format.
9. Define field and
record with a diagram.
A field is a single
column in a table that holds specific attributes of data, such as
"Name" or "Age." A record is a single row in a table,
containing data for one entity.
|
ID |
Name |
Age |
|
1 |
Sagar Sharma |
30 |
|
2 |
Kajal Thakur |
25 |
10. What is Field data
type? List the field data types along with their uses.
Field data type
specifies the type of data that can be stored in a field.
Examples:
- Text: For storing
alphanumeric characters
- Number: For numeric
values
- Date/Time: For date
and time entries
- Currency: For monetary
values
11. What is a primary
key? List any two uses of primary key.
A primary key is a
unique identifier for each record in a table.
Uses:
- Ensures data
uniqueness
- Establishes
relationships between tables
12. What is Field
Properties? What is the maximum number of characters in a caption?
Field Properties are
settings that define how a field behaves, such as its size or format. The
maximum number of characters in a caption is 255.
13. What is field size
property? What is the default size of number field data type?
Field size property
defines the maximum amount of data that a field can store. The default size of
a number field is 1 byte (Integer).
14. What are the uses of
format and Input Mask field properties?
- Format: Controls how
data is displayed, such as dates or numbers.
- Input Mask: Defines a
pattern for entering data, such as phone numbers or zip codes.
15. What is data
validation? Mention its importance in a database.
Data validation ensures
that the data entered into a database meets specific rules or criteria. It
prevents errors and maintains data integrity.
16. What is Indexed
property of a field? What is the indexed value of a primary key?
The Indexed property
determines whether a field's values are indexed for faster searching and sorting.
The indexed value of a primary key is "Yes (No Duplicates)."
17. What is meant by sorting records?
Sorting records means arranging the data in a specific order
(e.g., ascending or descending).
18. What is a query? List any four uses of
queries.
A query retrieves specific data from a
database by applying conditions.
Uses:
1. Filtering data based on criteria.
2. Calculating values.
3. Combining data from tables.
4. Updating or deleting records.
19. Define Select query and Update query.
- Select query: Retrieves specific data from
a database.
- Update query: Modifies existing data in a
table.
20. What is a form? List any two uses of a
form.
A form provides a user-friendly interface
for data entry and modification.
Uses:
1. Simplifies data entry.
2. Customizes data display.
21. What is a report? Write the importance of
a report.
A report organizes and presents data in a
printable format, helping in analysis and sharing.
True/False Statements
1. A collection of data related to any subject or purpose is
a database. True
2. MS-Access, dBase, and FoxPro are examples of
databases. True
3. A field of a table stores a particular
category of data. True
4. In the Table Datasheet view, a user can
change the data type of a field. True
5. A field name can be up to 40 characters long.
False
6. A user can store 125 characters in a text
data type. False
7. A user can change the value of an AutoNumber
field. False
8. The text data type is the default data type
of a field. True
9. The indexed field property speeds up
searching and sorting of records. True
10. The primary key is indexed as 'Yes
(Duplicates OK).' False
11. A primary key helps to identify records of a
table. True
12. A database file created in MS-Access has a
`.DBM` extension. False
13. A row of a table is known as a field in
MS-Access. False
14. A query can be created without tables. False
15. Forms can be used to enter, view, and modify
records. True
16. A report can be used to modify data of a
table. False
Multiple Choice Questions
1. An organized collection of related data of
a subject or purpose is...
a) Information
b) Database (Correct Answer)
c) DBMS
d) Table
2. Which is the database?
a) Phone Diary
b) Mark Ledger
c) Attendance Register
d) All of them (Correct Answer)
3. MS-Access is...
a) Utility
b) Application (Correct Answer)
c) System
d) None of the above
4. Which is DBMS?
a) Metabase
b) dBase (Correct Answer)
c) MS-Excel
d) Mark Ledger
5. Which of the following is not an MS-Access
database object?
a) Database
b) Table
c) dBase (Correct Answer)
d) Query
6. Which is not a DBMS?
a) Oracle
b) Table (Correct Answer)
c) Foxpro
d) Query
7. ... uniquely identifies records of a
table.
a) Foreign key
b) Primary key (Correct Answer)
c) Field Name
d) None of the above
8. The object of MS-Access that stores data
is known as...
a) Query
b) Table (Correct Answer)
c) Form
d) Report
9. Which component of MS-Access is used to
enter data?
a) Query
b) Form
c) Report
d) Both (i) and (ii) (Correct Answer)
10. Which of the following is not a data type used in MS-Access?
a) Date/Time
b) Currency
c) Yes/No
d) Caption (Correct Answer)
11. What is the suitable data type to store remarks or comments?
a) Text
b) OLE Object
c) Hyperlink
d) Memo (Correct Answer)
12. The object of MS-Access that is used to prepare a ready-to-print
document is...
a) Query
b) Table
c) Form
d) Report (Correct Answer)
13. A column in an MS-Access table is...
a) Field (Correct Answer)
b) Table
c) Database
d) Report
14. A row in a table is known as...
a) Field
b) Tuple
c) Record (Correct Answer)
d) Relation
15. A primary key does not accept...
a) Null
b) Duplicate
c) Both (i) and (ii) (Correct Answer)
d) None
16. The default field size value of the text field data type is...
a) 40
b) 50
c) 255 (Correct Answer)
d) 64
17. Which is the subtype of the number field data type?
a) Integer (Correct Answer)
b) Byte
c) Single
d) All of the above
18. The logical data type of Access is...
a) Yes/No (Correct Answer)
b) True/False
c) On/Off
d) All of them
19. Which of the following is not a field property?
a) Indexed
b) Size
c) Colour (Correct Answer)
d) Format
20. The Date/Time field data type occupies... Bytes of memory.
a) 4
b) 2
c) 8 (Correct Answer)
d) 16
21. A field property that limits the data to be entered in a field is...
a) Validation Rule (Correct Answer)
b) Format
c) Input Mask
d) Indexed
22. Which one of the following is not a data type?
a) Text
b) Number
c) True/False (Correct Answer)
d) Currency
23. What field type is used to store a picture in a table?
a) Memo
b) OLE Object (Correct Answer)
c) Hyperlink
d) None
24. Which is the subtype of the number data type?
a) Integer
b) Byte
c) Single
d) All of the above (Correct Answer)
25. ... allows MS-Access to query and sort records faster.
a) Sorting
b) Editing
c) Filtering
d) Indexing (Correct Answer)
26. The maximum number of characters that can be stored in a field is
determined by...
a) Field Type
b) Field Size (Correct Answer)
c) Field Length
d) Field Width