1. The main purpose(s) of a database management program is to ?

allow users to retrieve and analyze stored records.

provide a way to store information about specified entities.

make it possible for users to store information as interrelated records.

a, b, and c above

Answer: a, b, and c above

Explanation:

The correct answer is (d) a, b, and c above. A database management program is designed to help users store, retrieve, and manage information in a structured and organized way. The main purpose of a database management program is to provide a way to store information about specified entities as interrelated records, and to allow users to retrieve and analyze stored records. This is typically done by using a database management system (DBMS), which provides tools and features for creating, managing, and querying databases.


2. __________ increase the accuracy of a search by fine-tuning the keywords in the search ?

Indexes

Italics

Compounds

Links

Answer: Indexes

Explanation:

Indexes increase the accuracy of a search by fine-tuning the keywords in the search.


3. Distributed processing involves ?

solving computer component problems from a different computer

solving computing problems by breaking them into smaller parts that are separately processed by different computers

allowing users to share files on a network

allowing users to access network resources away from the office

Answer: solving computing problems by breaking them into smaller parts that are separately processed by different computers

Explanation:

The correct answer is (b) solving computing problems by breaking them into smaller parts that are separately processed by different computers. Distributed processing involves the use of multiple computers or processing units to work together to solve a problem or complete a task. In this approach, a large computing problem is broken down into smaller sub-problems, each of which can be solved by a separate computer or processing unit. By distributing the processing workload across multiple computers, distributed processing can provide several benefits, including faster processing times, increased reliability and fault tolerance, and the ability to scale up or down processing power as needed.


4. Files are organised by storing them in ?

tables

databases

folders

graphs

Answer: folders

Explanation:

Answer: (c) folders. Files are organized by storing them in folders. Folders are used to group related files together and provide a hierarchical structure for organizing and storing files on a computer or network. Folders can contain files and other folders, allowing for a nested organization system.


5. A prescribed set of well-defined instructions for solving mathematical problems is called __________ ?

a compiler

a code

a description

an algorithm

Answer: an algorithm

Explanation:

The correct answer is (d) an algorithm. In computing, an algorithm is a set of well-defined instructions for performing a specific task or solving a problem, typically expressed in a structured or formal language. Algorithms are used in a wide range of applications, from simple calculations to complex data analysis and machine learning tasks. They are a fundamental tool for computer science and programming, and are essential for designing efficient and effective software systems.


6. Numbers in table columns are usually ?

right-aligned

left-aligned

justified

centered

Answer: right-aligned

Explanation:

The correct answer is (a) right-aligned. Numbers in table columns are usually right-aligned. This is because numbers are often used in tables for calculations, and aligning them to the right allows for easier comparison and calculation of values.


7. The first step in the transaction processing cycle is __________ ?

database operations

audit

data entry

user inquiry

Answer: data entry

Explanation:

The correct answer is (c) data entry. The first step in the transaction processing cycle is typically data entry, where data is collected and entered into a system for processing. This may involve manually entering data into a computer system, scanning barcodes or other identifiers, or receiving data from other systems or sources.


8. A telephone number, a birth date, and a customer name are all examples of ?

a record

data

a file

a database

Answer: a database

Explanation:

The correct answer is (b) data. A telephone number, a birth date, and a customer name are all examples of data, which is any piece of information that can be stored and processed by a computer. A record is a collection of related fields in a database that represent a single instance of an entity, such as a customer or an order. So, the customer name, birth date, and telephone number could be fields within a customer record in a database. A file is a collection of data that is stored as a unit on a computer, such as a text file or an image file. A database is a collection of structured data that is organized and stored in a way that allows for efficient retrieval and manipulation of that data. So, while the customer name, birth date, and telephone number could be part of a record in a database, they are more generally examples of data that can be stored in various ways, such as in a file or within a database.


9. An ad hoc query is a __________ ?

pre-planned question

pre-scheduled question

spur-of-the-moment question

question that will not return any results

Answer: spur-of-the-moment question

Explanation:

An ad hoc query is a spur-of-the-moment question.


10. Example of non-numeric data is ?

Employee address

Examination score

Bank balance

All of these

Answer: Employee address

Explanation:

Example of non-numeric data is Employee address.