7.
Which database object is used to retrieve
Question Bank for Unit Test-1 specific data?
(a) Form (b) Query
1. What is the main purpose of normalization in (c) Report (d) Table
databases? Correct Answer: (b)
(a) Reduce data redundancy Explanation: Queries are used to extract data from
(b) Increase data redundancy one or more tables based on specified criteria.
(c) Create more tables 8. Which symbol represents “one-to-many”
(d) Delete unnecessary records relationship?
Correct Answer: (a) (a) ∞ (b) 1:N
Explanation: Normalization organizes data to (c) * (d) #
reduce redundancy and improve integrity by Correct Answer: (b)
dividing data into related tables. Explanation: 1:N denotes that one record in Table
2. Which field property makes a field compulsory? A can relate to many in Table B.
(a) Validation Rule (b) Required 9. What is the smallest unit of data in a database?
(c) Indexed (d) Default Value (a) Table (b) Field
Correct Answer: (b) (c) Record (d) File
Explanation: The 'Required' property ensures that a Correct Answer: (b)
field cannot be left blank during data entry. Explanation: A field is the smallest piece of
3. DBMS stands for ____________ information, like 'Name' or 'Age'.
(a) Database Migration System 10. What is the first step of Report Wizard?
(b) Data Management System (a) Selecting Table/Query (b) Field Selection
(c) Direct Base Management System (c) Labeling Fields (d) Grouping
(d) Database Management System Correct Answer: (a)
Correct Answer: (d) Explanation: The first step is to select the source
Explanation: DBMS stands for Database (table/query) for the report.
Management System, software used to store, 11. Which data type is used to store image in Base
retrieve, and manage data in databases. database?
4. The process of arranging data in a meaningful (a) Binary (b) Photo
order is called: (c) Long (d) Huge
(a) Sorting (b) Filtering Correct Answer: (a)
(c) Grouping (d) Indexing Explanation: The Binary data type is used to store
Correct Answer: (a) image files and other binary content in a database.
Explanation: Sorting arranges records based on 12. Which one is used to create summary reports?
one or more fields in ascending or descending (a) Tables (b) Queries
order. (c) Forms (d) Reports
5. In a table, each row is also called a: Correct Answer: (d)
(a) Field (b) Record Explanation: Reports are used to present and
(c) Column (d) Key summarize data in a printable format.
Correct Answer: (b) 13. Referential integrity ensures:
Explanation: Each row in a table represents a (a) Records are unique
record, which is a single data entry. (b) Tables are linked properly
6. Which of the following is NOT a data type in (c) Reports display data correctly
Base? (d) Data is encrypted
(a) Text (b) Integer Correct Answer: (b)
(c) Boolean (d) Chart Explanation: Referential integrity ensures
Correct Answer: (d) consistency between related tables by enforcing
Explanation: 'Chart' is not a data type; it's a visual rules on data entry.
representation tool, not a data storage format.
14. Which view allows entering new records Correct Answer: (b)
directly? Explanation: Clicking 'Print' sends the document to
(a) Design View (b) Datasheet View a printer for a hard copy.
(c) Form View (d) Print Preview 21. Which step of Form Wizard allows applying
Correct Answer: (b) different styles?
Explanation: Datasheet View allows users to (a) Third (b) Fifth
directly enter and edit data in rows and columns. (c) Sixth (d) Seventh
15. A report header is printed: Correct Answer: (c)
(a) At the start of each page Explanation: In the sixth step, styles and layouts
(b) At the end of each page are applied to enhance form appearance.
(c) Once at the start 22. A subform is:
(d) Once at the end (a) A smaller database
Correct Answer: (c) (b) A form within a form
Explanation: A report header is printed once at the (c) A query inside a form
beginning of the report to display titles or headings. (d) A report with tables
16. What does SQL stand for? Correct Answer: (b)
(a) Structured Query Language Explanation: A subform is embedded inside
(b) Simple Query Logic another form and typically shows related records.
(c) Sequential Query Language 23. Which view is in form of row and column?
(d) System Query Language (a) Datasheet (b) Report
Correct Answer: (a) (c) Form (d) None of them
Explanation: SQL stands for Structured Query Correct Answer: (a)
Language, used to manage and manipulate Explanation: Datasheet View displays data in rows
relational databases. and columns like a spreadsheet.
17. Which field property automatically fills in a 24. Which type of relationship links a single record
value when entering a new record? in one table to multiple records in another?
(a) Auto Value (b) Default Value (a) One-to-One
(c) Required (d) Entry Required (b) One-to-Many
Correct Answer: (b) (c) Many-to-Many
Explanation: The Default Value property pre-fills a (d) None
value unless the user changes it. Correct Answer: (b)
18. Which component helps in data validation in Explanation: One-to-Many relationships are
forms? common where one record relates to several in
(a) Text Box (b) Input Mask another table.
(c) Label (d) Button 25. To change field names in a table, use:
Correct Answer: (b) (a) Datasheet View (b) Design View
Explanation: Input masks enforce a pattern for (c) SQL View (d) Report View
data entry, ensuring correct format like phone Correct Answer: (b)
numbers or dates. Explanation: Design View allows modifying field
19. Which Base object is used to print formatted names, data types, and other structural properties.
data? 26. How many ways are there to create a Form?
(a) Table (b) Query (a) One (b) Two
(c) Report (d) Form (c) Three (d) Four
Correct Answer: (c) Correct Answer: (d)
Explanation: Reports are specifically designed for Explanation: Forms can be created via Wizard,
printing and displaying formatted data. Design View, drag-and-drop, and AutoForm tools.
20. To make a hard copy, click on ________ 27. A Form resembles the pen and paper style
(a) Print Preview (b) Print forms.
(c) Save (d) Export (a) Table
(b) Query 33. What is the main function of a report in a
(c) Form database?
(d) Report (a) Printing summarized info. (b) Displaying data
Correct Answer: (c) (c) Editing data (d) Data entry
Explanation: Forms are user-friendly interfaces Correct Answer: (a)
designed for data entry like traditional forms. Explanation: Reports are used to format and print
summarized data from queries or tables.
28. What does an index in a table do? 34. Which of the following will open Position and
(a) Prevents duplicate values Size dialog box?
(b) Speeds up searches (a) Single Click (b) Double Click
(c) Creates relationships (c) Right Click (d) None of them
(d) Encrypts data Correct Answer: (c)
Correct Answer: (b) Explanation: Right-clicking an element in Design
Explanation: Indexes improve the speed of data View gives access to position and size properties.
retrieval operations on a database table. 35. Which of the following best describes
29. Which of the following is NOT an object customer in Database?
maintained by Base? (a) Relationship (b) Attribute
(a) Tables (b) Queries (c) Entity (d) Data
(c) Charts (d) Forms Correct Answer: (c)
Correct Answer: (c) Explanation: A customer is an entity — a real-
Explanation: Charts are visual elements, not world object represented as a table row.
standard database objects like tables, queries, 36. Which of these is an example of a relational
forms, and reports. database?
30. The alphabet R in RDBMS stands for which of (a) MS Paint (b) MS Word
the following? (c) Oracle (d) Photoshop
(a) Rotational (b) Relational Correct Answer: (c)
(c) Random (d) Ring Explanation: Oracle is a relational database that
Correct Answer: (b) stores data in tables with relationships.
Explanation: RDBMS stands for Relational 37. Clicking on which button will delete current
Database Management System, where data is record displayed in the form?
stored in related tables. (a) Erase (b) Delete
31. What is the default extension of Base (c) Remove (d) Edit
Database file? Correct Answer: (b)
(a) .bdf (b) .odf Explanation: The Delete button removes the
(c) .odb (d) .dbf current record from the underlying table.
Correct Answer: (c) 38. A primary key is:
Explanation: LibreOffice Base database files are (a) Optional
saved with the .odb extension. (b) Must be unique and not null
32. Which data type is NOT used to store (c) Can have duplicates
numbers? (d) Always numeric
(a) Decimal (b) Integer Correct Answer: (b)
(c) Text (d) Date Explanation: A primary key ensures every record is
Correct Answer: (c) uniquely identified and cannot be left blank.
Explanation: ‘Text’ is used to store letters or 39. Processed data is known as ________
alphanumeric data, not numerical values. (a) Fact (b) Prepared data
(c) Information (d) Decision
Correct Answer: (c)
Explanation: Once raw data is processed and
structured, it becomes information.
40. The field that has unique importance in the Explanation: A Combo Box allows users to select
table is known as ____________ from a predefined list of options.
(a) Primary Key (b) Key Row 47. Which of the following is an advantage of
(c) Key Table (d) Main Field using forms?
Correct Answer: (a) (a) Direct printing (b) Easy data entry
Explanation: A primary key is a field that uniquely (c) Query creation (d) Data encryption
identifies each record in a table. Correct Answer: (b)
41. Which of the following will open Properties: Explanation: Forms provide a user-friendly way to
Label Field dialog box? enter and manage data.
(a) Right-click on Label & select Control Option 48. What is the main function of a subreport?
(b) Right-click on Label & select Properties Option (a) To enter data
(c) Double-click on Label (b) To view queries
(d) None of them (c) To display related data
Correct Answer: (b) (d) To edit forms
Explanation: Right-clicking a label and choosing Correct Answer: (c)
'Properties' opens the dialog to modify field Explanation: Subreports display related or detailed
attributes. data within a main report.
42. Which of the following is NOT DBMS 49. Which control type is commonly used in forms
software? for choosing one option from multiple?
(a) DB2 (b) Base (a) Text Box (b) Combo Box
(c) Open Office Suite (d) Spreadsheet (c) Radio Button (d) Check Box
Correct Answer: (c) Correct Answer: (c)
Explanation: OpenOffice Suite is a software suite, Explanation: Radio buttons allow users to choose
not specifically a DBMS. only one option from a group.
43. Which option is used to filter data in a report? 50. Report Wizard can be opened by:
(a) Sorting (b) Criteria (a) Right-click on the query or table
(c) Filter (d) Grouping (b) Click on Report icon
Correct Answer: (c) (c) Both (a) and (b)
Explanation: Filters are used to limit the data (d) None of them
shown in a report to meet certain criteria. Correct Answer: (c)
44. Which of the following is NOT an open source Explanation: The Report Wizard can be accessed by
DBMS? right-clicking or using the toolbar in Base.
(a) MySQL (b) Ingress 51. Which command in Base saves all changes?
(c) Base (d) Oracle (a) CTRL+S
Correct Answer: (d) (b) CTRL+C
Explanation: Oracle is a proprietary, paid DBMS, (c) CTRL+P
unlike open-source options like MySQL or Base. (d) CTRL+V
45. Which field type is best for storing long Correct Answer: (a)
descriptions? Explanation: CTRL+S is the universal shortcut to
(a) Memo (b) Text save changes in most applications, including
(c) Numeric (d) Boolean LibreOffice Base.
Correct Answer: (a) 52. Which of these is NOT a view type in Base?
Explanation: Memo fields are used to store large (a) Table View (b) Form View
text entries like comments or descriptions. (c) Print Layout View (d) Design View
46. A drop-down list in a form is created using: Correct Answer: (c)
(a) Text Box (b) Combo Box Explanation: ‘Print Layout View’ is available in
(c) Radio Button (d) Label Writer, not in Base.
Correct Answer: (b)
53. What is required to apply conditional 60. Which field is used to create relationships
formatting in reports? between tables?
(a) Styles (b) Conditional Styles (a) Primary Key (b) Foreign Key
(c) Filters (d) Grouping (c) Composite Key (d) Any key
Correct Answer: (b) Correct Answer: (b)
Explanation: Conditional Styles allow formatting Explanation: A foreign key connects one table to
based on certain criteria or field values. another by referencing a primary key.
54. Which step of Form Wizard consists of aligning 61. Which type of form allows editing multiple
various controls? records in a spreadsheet-style layout?
(a) Second (b) Fifth (a) Datasheet Form (b) Single Form
(c) Sixth (d) Seventh (c) Split Form (d) Continuous Form
Correct Answer: (c) Correct Answer: (a)
Explanation: The sixth step allows setting control Explanation: Datasheet Form displays data in grid
layouts for a clean and structured form. format similar to tables.
55. The last step in Form Wizard is: 62. In Base, a calculated field in a query is created
(a) Naming the form (b) Selecting layout using:
(c) Adding data (d) Saving data (a) Expression (b) Alias
Correct Answer: (a) (c) Syntax (d) Field Wizard
Explanation: The final step in Form Wizard is to Correct Answer: (a)
name the form before it is created. Explanation: Expressions use formulas and field
56. Which one of the following is used to enforce names to generate calculated results.
data accuracy between tables? 63. Which of the following provides a visual way
(a) Primary Key (b) Index to define relationships?
(c) Referential Integrity (d) Memo (a) Design View (b) Relationships Window
Correct Answer: (c) (c) Table Wizard (d) Query Builder
Explanation: Referential Integrity maintains Correct Answer: (b)
consistency between linked tables. Explanation: The Relationships Window visually
57. What does “filter by selection” do in Base? shows how tables are connected.
(a) Filters all records 64. Which option ensures consistent data entry
(b) Shows only selected records formats in a field?
(c) Deletes unselected records (a) Validation Rule (b) Input Mask
(d) Highlights selected fields (c) Default Value (d) Caption
Correct Answer: (b) Correct Answer: (b)
Explanation: Filter by selection displays only Explanation: Input masks control how data like
records that match the currently selected value. phone numbers or dates must be entered.
58. Which view allows editing the structure of a 65. Which of the following is not a valid relational
table? operation?
(a) Datasheet View (b) Design View (a) Select (b) Project
(c) Report View (d) Form View (c) Join (d) Print
Correct Answer: (b) Correct Answer: (d)
Explanation: Design View allows modifying field Explanation: Print is not a relational operation; it
types, names, and properties. refers to output, not query processing.
59. What is the default setting of Drop Down 66. Which tool helps to sort records in a specific
property? order?
(a) Yes (b) No (a) Grouping (b) Index
(c) Both (a) and (b) (d) None of them (c) Order By clause (d) Filter
Correct Answer: (b) Correct Answer: (c)
Explanation: By default, drop-down features are Explanation: ORDER BY clause is used in SQL to sort
set to “No” unless enabled manually. data results by specified fields.
67. The main purpose of queries is to: Explanation: A Text Area allows entry of multiple
(a) Store data (b) Display tables lines of text.
(c) Retrieve data (d) Set relationships 75. Which clause in SQL is used for conditional
Correct Answer: (c) selection?
Explanation: Queries are designed to retrieve and (a) FROM (b) WHERE
manipulate data from one or more tables. (c) ORDER (d) SELECT
68. Which object can be used to generate mailing Correct Answer: (b)
labels? Explanation: The WHERE clause sets conditions for
(a) Report (b) Form filtering data in SQL queries.
(c) Query (d) Label Wizard 76. Data redundancy can be avoided using:
Correct Answer: (d) (a) Reports (b) Tables
Explanation: Label Wizard helps design and print (c) Relationships (d) Indexes
mailing labels from table or query data. Correct Answer: (c)
69. Which part of a report shows data values? Explanation: Relationships reduce redundancy by
(a) Report Header (b) Detail Section linking related data instead of repeating it.
(c) Page Footer (d) Group Footer 77. Which layout in form wizard shows fields in a
Correct Answer: (b) grid format?
Explanation: The Detail Section repeats for every (a) Columnar (b) Tabular
record and shows the actual data. (c) Datasheet (d) Justified
70. A unique identifier for each record is called: Correct Answer: (b)
(a) Foreign Key (b) Primary Key Explanation: Tabular layout displays data in rows
(c) Memo Field (d) Join Key and columns similar to a table.
Correct Answer: (b) 78. What happens when you change a field’s data
Explanation: A primary key ensures that each type?
record in a table is unique. (a) Deletes all data (b) May cause data loss
71. Which of the following is used to ensure no (c) Locks table (d) Optimizes records
blank entry in a field? Correct Answer: (b)
(a) Input Mask (b) Validation Explanation: Changing a field’s data type can
(c) Required Property (d) Default Value cause data truncation or loss if incompatible.
Correct Answer: (c) 79. A collection of records is also known as a:
Explanation: The Required Property ensures a field (a) Table (b) Form
must contain a value before saving. (c) Report (d) File
72. Which data type supports Yes/No values? Correct Answer: (a)
(a) Boolean (b) Text Explanation: A table is made up of rows (records)
(c) Numeric (d) Binary and columns (fields).
Correct Answer: (a) 80. Which type of field stores numbers with
Explanation: Boolean stores logical values like decimals?
TRUE/FALSE or YES/NO. (a) Integer (b) Text
73. What is the role of the Report Footer section? (c) Decimal/Float (d) Boolean
(a) Title page (b) Print totals Correct Answer: (c)
(c) Repeat headers (d) Store layout Explanation: Decimal or Float data types allow
Correct Answer: (b) storage of numbers with fractional parts.
Explanation: The report footer is typically used to 81. What is used to define the formatting of data
show totals and summaries. in reports?
74. Which form control is best for accepting (a) Style Sheet (b) Conditional Formatting
multiline input? (c) Format Painter (d) Layout Grid
(a) Text Box (b) Memo Box Correct Answer: (b)
(c) Text Area (d) Input Field Explanation: Conditional formatting lets you apply
Correct Answer: (c) styles based on field values.
82. A group footer appears: Correct Answer: (c)
(a) After each record (b) After a group of records Explanation: Primary keys often use AutoValue to
(c) Only on first page (d) In query results only auto-generate unique IDs.
Correct Answer: (b) 90. What is the result of a SELECT query?
Explanation: A group footer summarizes or totals (a) Table (b) Form
values after a data group. (c) Report (d) Result Set
83. A field that stores large amounts of text is: Correct Answer: (d)
(a) Memo (b) Number Explanation: A SELECT query returns a result set —
(c) Text (d) Currency a temporary view of the data.
Correct Answer: (a) 91. Which type of form allows navigation across
Explanation: Memo fields are designed to hold multiple records?
long text entries like comments or notes. (a) Continuous Form (b) Tabular Form
84. The main screen in Base to manage database (c) Split Form (d) Datasheet Form
objects is called: Correct Answer: (a)
(a) Navigation Pane (b) Main Menu Explanation: A Continuous Form displays multiple
(c) Object Pane (d) Switchboard records at once and allows navigation between
Correct Answer: (a) them.
Explanation: The Navigation Pane displays tables, 92. What is the purpose of the ‘Group By’ clause
queries, forms, and reports in Base. in SQL?
85. The Design View of a form allows: (a) To delete duplicates
(a) Editing structure (b) Entering data (b) To group records based on fields
(c) Preview only (d) Running queries (c) To sort results
Correct Answer: (a) (d) To create forms
Explanation: Design View lets you build and Correct Answer: (b)
customize the layout and properties of a form. Explanation: GROUP BY organizes rows into groups
86. You can restrict duplicate values using: based on identical values in specified fields.
(a) Index (b) Validation 93. The field used to connect two tables is called:
(c) Unique Property (d) Format Mask (a) Lookup (b) Primary Key
Correct Answer: (c) (c) Foreign Key (d) Summary Key
Explanation: Unique Property ensures all field Correct Answer: (c)
values in a column are distinct. Explanation: A Foreign Key links records in one
87. The tool used to visually design queries is: table to the Primary Key in another table.
(a) Report Wizard (b) Query Designer 94. Which action query is used to add new records
(c) Table View (d) SQL Console from one table to another?
Correct Answer: (b) (a) Append Query (b) Delete Query
Explanation: Query Designer allows building (c) Update Query (d) Make-Table Query
queries graphically by selecting fields and setting Correct Answer: (a)
criteria. Explanation: Append queries insert records from a
88. Which Base feature allows calculated total in source table into a destination table.
reports? 95. Which form control allows users to select
(a) Function Field (b) Formula Tool multiple options?
(c) Group Summary (d) Aggregate Function (a) Check Box (b) Radio Button
Correct Answer: (d) (c) Combo Box (d) Option Group
Explanation: Aggregate functions like SUM(), Correct Answer: (a)
AVG(), and COUNT() help calculate totals in reports. Explanation: Checkboxes allow selecting multiple
89. Which of the following fields can be marked as independent options.
AutoValue?
(a) Text (b) Integer
(c) Primary Key (d) Memo
96. Which property ensures a field must have a Explanation: ORDER BY is used to sort the results of
value before saving a record? a query in ascending or descending order.
(a) Validation Rule (b) Default Value 103. Which form layout shows all fields
(c) Required (d) Indexed horizontally for one record?
Correct Answer: (c) (a) Columnar (b) Justified
Explanation: Setting the Required property to “Yes” (c) Tabular (d) Datasheet
prevents blank values. Correct Answer: (a)
97. Which function is used to count total records Explanation: Columnar layout displays fields
in a query? vertically for a single record at a time.
(a) SUM() (b) MAX() 104. Which operation removes all records from a
(c) COUNT() (d) AVG() table in one go?
Correct Answer: (c) (a) Erase (b) Truncate
Explanation: COUNT() returns the number of (c) Delete (d) Drop
records matching the query condition. Correct Answer: (b)
98. In Base, which object cannot be created using Explanation: TRUNCATE deletes all data from a
a wizard? table without removing the table itself.
(a) Form (b) Table 105. What does a checkbox in a form represent?
(c) Report (d) Relationship (a) Single choice (b) Multiple choice
Correct Answer: (d) (c) Text entry (d) Calculated field
Explanation: Relationships must be defined Correct Answer: (b)
manually in the Relationships window. Explanation: Checkboxes allow multiple selections
99. Which key combination refreshes data in a as each is independent.
Base form? 106. Which function finds the highest value in a
(a) F2 (b) Ctrl+R numeric field?
(c) Alt+F5 (d) Shift+F9 (a) SUM()
Correct Answer: (b) (b) COUNT()
Explanation: Ctrl+R refreshes the form's data (c) MAX()
display. (d) MIN()
100. Which field property defines default content Correct Answer: (c)
when a new record is added? Explanation: MAX() returns the highest value in a
(a) Caption (b) AutoValue column.
(c) Default Value (d) Input Mask 107. Which of the following is used to visually
Correct Answer: (c) align controls in a form?
Explanation: Default Value pre-fills a field with (a) Snap to Grid
specific content for new records. (b) Grid Lines
101. Which relationship type requires a junction (c) Align Toolbar
table? (d) Position Manager
(a) One-to-One (b) Many-to-Many Correct Answer: (a)
(c) One-to-Many (d) Self-Join Explanation: Snap to Grid helps maintain
Correct Answer: (b) alignment of form controls during design.
Explanation: Many-to-many relationships are 108. What is used to prevent users from entering
implemented through an intermediate/junction duplicate values?
table. (a) Index
102. Which of the following clauses is used to sort (b) Unique Constraint
output in SQL? (c) Not Null
(a) WHERE (b) HAVING (d) Filter
(c) ORDER BY (d) SELECT Correct Answer: (b)
Correct Answer: (c) Explanation: Unique constraints prevent repeated
values in a field.
109. Which object is used to organize data entry 116. Which part of Base interface contains links to
for end-users? all objects?
(a) Table (b) Query (a) Workspace (b) Navigation Pane
(c) Form (d) Report (c) Object Selector (d) Status Bar
Correct Answer: (c) Correct Answer: (b)
Explanation: Forms provide an interface for easy Explanation: Navigation Pane displays all objects
data entry. like tables, queries, and forms.
110. What does a relationship line between two 117. Which Base object allows formatting before
tables signify? printing?
(a) Field Types (b) Data Format (a) Table (b) Report
(c) Key Matching (d) Caption (c) Query (d) Form
Correct Answer: (c) Correct Answer: (b)
Explanation: A relationship line connects fields Explanation: Reports allow data to be formatted
(usually keys) that are related across tables. for presentation or printing.
111. Which of the following data types is used for 118. Which tool allows combining fields from
true/false values? multiple tables?
(a) Integer (b) Boolean (a) Form (b) Report
(c) Memo (d) Float (c) Query (d) Relationship
Correct Answer: (b) Correct Answer: (c)
Explanation: Boolean fields store binary choices Explanation: Queries can join tables and extract
like TRUE/FALSE or YES/NO. related data.
112. How can you remove a field from a form? 119. What do you use to give a label to a field in
(a) Delete in design (b) Press ESC queries?
(c) Disable (d) Lock (a) Caption (b) Alias
Correct Answer: (a) (c) Name (d) Key
Explanation: In Design View, fields can be manually Correct Answer: (b)
deleted from the layout. Explanation: Aliases rename fields in query results
113. What is the use of a Report Footer in Base? for clarity.
(a) Repeating title (b) Calculations or totals 120. Which SQL clause restricts rows returned?
(c) Page count (d) Table links (a) SELECT (b) FROM
Correct Answer: (b) (c) WHERE (d) ORDER
Explanation: Report footers are commonly used to Correct Answer: (c)
show grand totals or summaries. Explanation: WHERE filters which rows appear in
114. What does a form navigator help with? the result set.
(a) Edit queries (b) View relationships 121. Which view in Base is best for designing table
(c) Manage subforms (d) Track keyboard usage structure?
Correct Answer: (c) (a) Datasheet View (b) Table Wizard
Explanation: The form navigator helps manage (c) Design View (d) SQL View
components like subforms and controls. Correct Answer: (c)
115. Which component provides summary data in Explanation: Design View allows full control over
reports? fields, data types, and keys.
(a) Group Footer (b) Page Header 122. What does a subform typically display?
(c) Form View (d) Label Field (a) Summary data (b) Related records
Correct Answer: (a) (c) Totals (d) Reports only
Explanation: Group Footers display totals or Correct Answer: (b)
summaries for each group in a report. Explanation: Subforms show data related to the
main form’s current record.
123. Which report section repeats for every 130. Which clause in SQL groups rows with the
record? same values?
(a) Page Header (b) Report Footer (a) ORDER BY
(c) Detail Section (d) Report Header (b) GROUP BY
Correct Answer: (c) (c) HAVING
Explanation: Detail Section outputs one line for (d) JOIN
each record retrieved. Correct Answer: (b)
124. Which form property allows read-only Explanation: GROUP BY is used to combine rows
access? with matching values for aggregation.
(a) Data Mode (b) View Only
(c) Lock Form (d) Design Off
Correct Answer: (a)
Explanation: Data Mode can be set to read-only to
prevent editing in a form.
125. Which SQL keyword removes specific rows?
(a) REMOVE (b) DELETE
(c) DROP (d) ERASE
Correct Answer: (b)
Explanation: DELETE removes rows based on a
condition in SQL.
126. Which property defines alignment of text in a
field?
(a) Caption (b) Format
(c) Alignment (d) Input Mask
Correct Answer: (c)
Explanation: The Alignment property sets text to
left, right, or center.
127. Which field property allows limiting input to
specific patterns?
(a) Default Value (b) Validation Rule
(c) Input Mask (d) Indexed
Correct Answer: (c)
Explanation: Input masks define the format of
input (e.g., phone numbers).
128. Which data type would you assign for “Phone
Number”?
(a) Integer (b) Text
(c) Memo (d) Boolean
Correct Answer: (b)
Explanation: Phone numbers often include symbols
and leading zeros, so text type is preferred.
129. Which button in form navigation helps move
to the last record?
(a) >> (b) >|
(c) End (d) Down Arrow
Correct Answer: (b)
Explanation: >| navigates directly to the last
record in a form.