Competitive Exams : Computer Awareness - Microsoft Access and LibreOffice Base (Set 3)

Question 1

Which of the following default file extensions is used for database files created in Microsoft Access 2007 and all subsequent newer versions?

Accepted Answer

B) .accdb

Answer

A) .mdb

Answer

C) .odb

Answer

D) .dbf

Question 2

What is the default file extension for a database document generated using LibreOffice Base?

Accepted Answer

C) .odb

Answer

A) .accdb

Answer

B) .dbx

Answer

D) .ods

Question 3

In Microsoft Access, which data type should be selected for storing alphanumeric text longer than 255 characters?

Accepted Answer

A) Long Text (or Memo)

Answer

B) Short Text

Answer

C) Hyperlink

Answer

D) OLE Object

Question 4

Which basic database object in MS Access and LibreOffice Base is specifically designed to present summarized data in a formatted, printable layout?

Accepted Answer

C) Report

Answer

A) Table

Answer

B) Form

Answer

D) Query

Question 5

In relational databases like LibreOffice Base and MS Access, what guarantees that a field uniquely identifies each record in a table without null values?

Accepted Answer

D) Primary Key

Answer

A) Foreign Key

Answer

B) Composite Index

Answer

C) Candidate Key

Question 6

Which view in Microsoft Access or LibreOffice Base allows users to manually modify the structure, data types, and properties of table fields?

Accepted Answer

B) Design View

Answer

A) Datasheet View

Answer

C) Layout View

Answer

D) Structure Preview

Question 7

In LibreOffice Base, what is the default relational database engine embedded directly within the application for local storage?

Accepted Answer

A) HSQLDB / Firebird

Answer

B) SQLite

Answer

C) Jet Engine

Answer

D) PostgreSQL

Question 8

What type of query in MS Access modifies data in bulk by adding, updating, or deleting records across tables?

Accepted Answer

C) Action Query

Answer

A) Select Query

Answer

B) Crosstab Query

Answer

D) Parameter Query

Question 9

Which table field property in MS Access prevents users from entering invalid data by checking entries against a set condition?

Accepted Answer

B) Validation Rule

Answer

A) Input Mask

Answer

C) Default Value

Answer

D) Required Field

Question 10

To establish a many-to-many relationship between two tables in MS Access or LibreOffice Base, what structural element must be introduced?

Accepted Answer

D) A junction (or bridge) table

Answer

A) A primary key index on both tables

Answer

B) A lookup wizard column

Answer

C) An auto-number trigger

Question 11

In MS Access, which built-in feature reduces file size and resolves potential database corruption issues?

Accepted Answer

A) Compact and Repair Database

Answer

B) Database Defragmenter

Answer

C) Index Optimizer

Answer

D) Encrypt and Clean

Question 12

What happens when Enforce Referential Integrity is enabled between a primary table and a related table in MS Access?

Accepted Answer

C) Records cannot be added to a related table if there is no corresponding record in the primary table.

Answer

A) Duplicate values in the primary key field are automatically allowed.

Answer

B) Child records can be added even if no matching parent record exists.

Answer

D) Primary key fields are automatically converted to AutoNumber.

Question 13

In LibreOffice Base, which query creation method allows users to visually drag and drop fields and tables without manually writing SQL statements?

Accepted Answer

B) Design View (GUI Query Builder)

Answer

A) SQL Command Window

Answer

C) Script Editor

Answer

D) Table Wizard

Question 14

Which data type automatically generates a sequential numeric value every time a new record is added to an MS Access table?

Accepted Answer

D) AutoNumber

Answer

A) Number

Answer

B) Large Integer

Answer

C) Calculated

Question 15

When writing a query criteria in MS Access to prompt the user for input at runtime, which syntax must surround the prompt text?

Accepted Answer

A) Square brackets [ Enter City: ]

Answer

B) Parentheses ( Enter City: )

Answer

C) Curly braces { Enter City: }

Answer

D) Double quotes "Enter City:"

Question 16

Which standard SQL keyword is automatically generated by MS Access or LibreOffice Base when retrieving data from tables?

Accepted Answer

C) SELECT

Answer

A) EXTRACT

Answer

B) GET

Answer

D) OPEN

Question 17

What error message text property is displayed to the end user in MS Access when entered data violates a Validation Rule?

Accepted Answer

B) Validation Text

Answer

A) Validation Error

Answer

C) Error Alert

Answer

D) Input Mask Text

Question 18

In LibreOffice Base, which wizard option allows easy creation of interactive user interfaces for record entry without manual control placement?

Accepted Answer

D) Form Wizard

Answer

A) Query Wizard

Answer

B) Report Wizard

Answer

C) Table Builder

Question 19

Which MS Access field property formats how data is entered by requiring placeholders like phone numbers (___) ___-____?

Accepted Answer

A) Input Mask

Answer

B) Format

Answer

C) Default Value

Answer

D) Validation Rule

Question 20

In a Relational Database Management System (RDBMS) like MS Access or LibreOffice Base, a single row in a table is formally referred to as a:

Accepted Answer

C) Record (or Tuple)

Answer

A) Attribute

Answer

B) Field

Answer

D) Entity Type