Q71. How does a ‘Primary Key’ ensure uniqueness in a table?
a) It provides a unique identifier for each record
b) It sorts records in ascending order
c) It restricts data entry to numeric values
d) It formats the table for printing
Show Answer
Correct Answer: a) It provides a unique identifier for each record
Explanation: The Primary Key ensures that each record in a table has a unique identifier, preventing duplicate entries.
Q72. Which view allows you to input and edit data directly in a table?
a) Data View
b) Design View
c) Print View
d) Layout View
Show Answer
Correct Answer: a) Data View
Explanation: Data View allows users to directly input and edit data within the table.
Q73. What is a common use of the ‘Find and Replace’ feature in database management?
a) Updating specific values across multiple records
b) Designing new tables
c) Creating new queries
d) Formatting report headers
Show Answer
Correct Answer: a) Updating specific values across multiple records
Explanation: The Find and Replace feature is often used to update specific values across multiple records efficiently.
Q74. When designing a form, which feature helps to ensure that data is entered correctly?
a) Input Masks
b) Table Design View
c) Print Preview
d) Query Wizard
Show Answer
Correct Answer: a) Input Masks
Explanation: Input Masks define a format for data entry, helping to ensure that data is entered correctly and consistently.
Q75. Which of the following is NOT a typical feature of a DBMS?
a) Data integrity enforcement
b) Table creation
c) User interface design
d) Query processing
Show Answer
Correct Answer: c) User interface design
Explanation: While DBMSs handle data integrity, table creation, and query processing, user interface design is generally handled by separate applications or tools.
Q76. To view a report as it will appear when printed, which feature should you use?
a) Print Preview
b) Design View
c) Data View
d) Layout View
Show Answer
Correct Answer: a) Print Preview
Explanation: Print Preview allows you to see how the report will appear when printed, including its formatting and layout.
Q77. What is the main purpose of using a ‘Data Entry Form’ in a database?
a) To simplify data entry and editing
b) To create new queries
c) To design tables
d) To print reports
Show Answer
Correct Answer: a) To simplify data entry and editing
Explanation: Data Entry Forms are used to make data entry and editing tasks easier and more user-friendly.
Q78. How can you maintain the accuracy of data in a database?
a) Use validation rules and constraints
b) Regularly backup the database
c) Create multiple tables for redundancy
d) Use the Find and Replace feature
Show Answer
Correct Answer: a) Use validation rules and constraints
Explanation: Validation rules and constraints ensure that the data entered into the database adheres to specific standards and rules.
Q79. What is the function of the ‘Report Wizard’ in a database system?
a) To guide users in creating and formatting reports
b) To enter and modify data
c) To design new tables
d) To execute queries
Show Answer
Correct Answer: a) To guide users in creating and formatting reports
Explanation: The Report Wizard provides a step-by-step guide to help users create and format reports based on database data.
Q80. What is the main purpose of defining a ‘Primary Key’ in a table?
a) To ensure each record is uniquely identifiable
b) To sort records in a specific order
c) To set data entry constraints
d) To format data for printing
Show Answer
Correct Answer: a) To ensure each record is uniquely identifiable
Explanation: The Primary Key uniquely identifies each record in a table, ensuring that no two records have the same key value.