1. Attributes can be defined for ?

entity

switch board

macro

pages

Answer: entity

Explanation:

Attributes can be defined for an entity. Therefore, the correct option is (a) entity.


2. Forms that are used to organize business data into rows and columns are called __________ ?

transaction sheets

registers

business forms

spreadsheets

Answer: spreadsheets

Explanation:

(d) spreadsheets. Spreadsheets are computer programs that allow users to organize data into rows and columns, and perform calculations and analyses on that data. They are commonly used in business for tasks such as budgeting, financial analysis, and record-keeping. Transaction sheets and registers are types of forms used to record specific types of business transactions, while "business forms" and "sheet-spreads" are not commonly used terms in this context.


3. Grouping and processing all of a firm’s transactions at one time is called ?

a database management system

batch processing

a real-time system

an on-line system

Answer: batch processing

Explanation:

Batch processing is a technique in which a large volume of data or transactions is collected over a period of time and then processed all at once, usually overnight or during a period of low activity. This is in contrast to real-time or online systems, which process data immediately as it is entered or received. A database management system is a software system used to manage and organize data in a database.


4. _______ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorized access of data ?

DBMS

Tables

Database

Protection passwords

Answer: DBMS

Explanation:

(a) DBMS (Database Management System) provides total solutions to reduce data redundancy, inconsistency, dependence, and unauthorized access of data. DBMS is a software system that enables users to define, create, maintain, and control access to the database. It provides mechanisms for data integration, data sharing, data security, and data consistency. The DBMS manages the storage, retrieval, and modification of data in the database. It reduces data redundancy by eliminating duplicate data and ensures data consistency by enforcing data integrity constraints. It also provides tools for data backup and recovery in case of data loss or corruption.


5. ______ is one reason for problems of data integrity ?

Data availability constraints

Data inconsistency

Security constraints

Unauthorized access of data

Answer: Data inconsistency

Explanation:

Data inconsistency is one reason for problems of data integrity. Data inconsistency occurs when the same data is stored in different locations in the database and the data values do not match. This can happen due to errors in data entry, incomplete or outdated data, or software bugs. Data inconsistency can lead to incorrect and unreliable results when data is queried or processed. It can also make it difficult to maintain data quality and accuracy over time. Ensuring data consistency is an important aspect of maintaining data integrity in a database.


6. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as ?

ER model

Data base

Data Model

DBMS

Answer: Data Model

Explanation:

A collection of conceptual tools for describing data, relationships, semantics, and constraints is referred to as a Data Model. Therefore, the correct option is (c) Data Model.


7. The simultaneous execution of two or more instructions is called ?

sequential access

reduced instruction set computing

multiprocessing

disk mirroring

Answer: multiprocessing

Explanation:

The correct answer is (c) multiprocessing. The simultaneous execution of two or more instructions is called multiprocessing. Multiprocessing refers to the ability of a computer system to execute multiple processes or threads at the same time, using multiple CPUs or cores.


8. When data changes in multiple lists and all lists are not updated, this causes ?

data redundancy

information overload

duplicate data

data inconsistency

Answer: data inconsistency

Explanation:

The correct answer is (d) data inconsistency.


9. The software that is used to create text-based documents are referred to as ___________ ?

DBMS

suites

spreadsheets

word processors

Answer: word processors

Explanation:

The software that is used to create text-based documents are referred to as word processors. Therefore, the correct option is (d) word processors.


10. What refers to a set of characters of a particular design ?

keyface

formation

calligraph

typeface

Answer: typeface

Explanation:

A typeface refers to a set of characters, letters, and symbols that share a common design. Examples of typefaces include Times New Roman, Arial, and Helvetica. The term "keyface" is not commonly used in the context of typography, while "formation" and "calligraph" do not specifically refer to sets of characters. A stencil is a type of template used to create a repeated design.