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

Question 1

Which of the following best describes the primary role of a Primary Key in Microsoft Access and LibreOffice Base tables?

Accepted Answer

A) Uniquely identifies each record in a database table without duplicate or null values

Answer

B) Automatically encrypts the entire database file for user security

Answer

C) Formats text fields into uppercase automatically during data entry

Answer

D) Establishes a temporary sorting order that resets after closing the application

Question 2

What is the default file extension for database files created in Microsoft Access 2007 and later versions?

Accepted Answer

B) .accdb

Answer

A) .mdb

Answer

C) .odb

Answer

D) .dbf

Question 3

What default file extension is used to save relational database files created in LibreOffice Base?

Accepted Answer

C) .odb

Answer

A) .ods

Answer

B) .odt

Answer

D) .odp

Question 4

In Microsoft Access, which data type should be used for a field designed to store large blocks of descriptive text exceeding 255 characters?

Accepted Answer

B) Long Text (Memo)

Answer

A) Short Text

Answer

C) OLE Object

Answer

D) Hyperlink

Question 5

Which action query type in Microsoft Access modifies data in existing records based on specified criteria?

Accepted Answer

D) Update Query

Answer

A) Append Query

Answer

B) Make-Table Query

Answer

C) Delete Query

Question 6

In LibreOffice Base, which menu option allows users to visually define relationships between database tables?

Accepted Answer

A) Tools -> Relationships

Answer

B) Edit -> Links

Answer

C) Insert -> Connection

Answer

D) View -> Table Design

Question 7

What is the primary function of a Foreign Key in a relational database table?

Accepted Answer

C) Reference the Primary Key of another table to link related data

Answer

A) Automatically sort database records alphabetically

Answer

B) Guarantee that a field value is positive

Answer

D) Store encrypted user account login information

Question 8

Which database object is specifically designed to provide a user-friendly interface for entering, editing, and displaying individual records?

Accepted Answer

B) Form

Answer

A) Table

Answer

C) Query

Answer

D) Module

Question 9

In MS Access and LibreOffice Base, which database object is best suited for formatting and printing structured data summaries?

Accepted Answer

D) Report

Answer

A) Table

Answer

B) Form

Answer

C) Macro

Question 10

In Microsoft Access, which data type automatically generates a unique sequential integer whenever a new record is added?

Accepted Answer

A) AutoNumber

Answer

B) Number

Answer

C) Calculated Field

Answer

D) Indexer

Question 11

Which SQL language category does the 'CREATE TABLE' command belong to?

Accepted Answer

B) DDL (Data Definition Language)

Answer

A) DML (Data Manipulation Language)

Answer

C) DCL (Data Control Language)

Answer

D) TCL (Transaction Control Language)

Question 12

What database integrity rule ensures that a record cannot exist in a child table without a valid corresponding parent record?

Accepted Answer

C) Referential Integrity

Answer

A) Domain Integrity

Answer

B) Entity Integrity

Answer

D) User-Defined Integrity

Question 13

Which MS Access table view allows developers to specify field names, data types, description, and properties?

Accepted Answer

A) Design View

Answer

B) Datasheet View

Answer

C) Layout View

Answer

D) Structure Preview View

Question 14

What embedded relational database engine has traditionally served as the default engine in LibreOffice Base?

Accepted Answer

B) HSQLDB

Answer

A) SQLite

Answer

C) PostgreSQL

Answer

D) Microsoft SQL Server

Question 15

In database queries, which relational operator combines rows from two tables only when there is a matching key in both tables?

Accepted Answer

D) INNER JOIN

Answer

A) FULL OUTER JOIN

Answer

B) LEFT JOIN

Answer

C) RIGHT JOIN

Question 16

In MS Access, which field data type allows attaching external documents, images, or files directly inside database records?

Accepted Answer

A) Attachment

Answer

B) Hyperlink

Answer

C) Lookup Wizard

Answer

D) Text

Question 17

Which field property in MS Access mandates that users must enter data into the field before saving the record?

Accepted Answer

C) Required

Answer

A) Input Mask

Answer

B) Validation Text

Answer

D) Indexed

Question 18

In an Access Query grid criteria row, which wild-card pattern matches all text entries that start with the letter 'A'?

Accepted Answer

B) Like "A*"

Answer

A) Like "?A"

Answer

C) Like "#A"

Answer

D) Like "[A]"

Question 19

Which specialized query type in MS Access calculates and reorganizes data into a compact, matrix-style table with row and column headings?

Accepted Answer

A) Crosstab Query

Answer

B) Parameter Query

Answer

C) Union Query

Answer

D) Pass-Through Query

Question 20

In LibreOffice Base, which feature permits users to write and execute custom SQL statements directly against the database engine?

Accepted Answer

C) Tools -> SQL

Answer

A) Form Wizard

Answer

B) Query Design View

Answer

D) Table Import Wizard