Question 1

---------- is a collection of logically related records and file
A)folder
B)application
C)database
D)field

Accepted Answer

A database is a collection of logically related records or files. It is designed to manage, store, and retrieve information efficiently.

Question 2

Which of the following is / are file organisation type?
A)pile
B)sequential
C)indexed
D)all the above

Accepted Answer

All the options listed, pile, sequential, and indexed, are types of file organization. Pile file organization involves storing records in no particular order. Sequential file organization stores records in a specific, sequential order based on a key field. Indexed file organization uses an index to maintain records in a specific order and allows for quicker searches.

Question 3

…………… is an interface between users and the various databases
A)application programmers
B)db administers
C)dbms
D)all of these

Accepted Answer

A Database Management System (DBMS) acts as an interface between users and databases, allowing for data management and interaction.

Question 4

Information currently stored in the database is called……….
A)instance
B)record
C)data
D)files

Accepted Answer

An instance in database terminology refers to the specific data stored in a database at a particular moment in time. This contrasts with the database schema, which is the structure or design of the database.

Question 5

Which of the following is not included in three level of data abstraction
A)physical
B)logical
C)view
D)data link

Accepted Answer

Data abstraction in databases is typically described at three levels: physical (how data is stored), logical (the structure of the database), and view (how data is seen by end users). The data link level is not part of this abstraction model; it relates to data transmission and networking.

Question 6

A system which record and report business transactions, flow of funds and generate financial statements is.....
A)management information system
B)financial information system
C)accounting information system
D)executive information system

Accepted Answer

An Accounting Information System (AIS) is specifically designed to record, report, and analyze financial and accounting data and transactions. This includes the generation of financial statements and tracking the flow of funds within an organization.

Question 7

The automatic transfer and positioning of work by machine without significant human intervention or operation is..........
A)updating
B)automation
C)computerisation
D)mechanisation

Accepted Answer

Automation refers to the technology by which a process or procedure is performed with minimal human assistance, which includes the automatic transfer and positioning of work by machines.

Question 8

An information system within a business organisations that support the traditional functions such as marketing, finance or production is.............
A)mis
B)bis
C)fis
D)eis

Accepted Answer

The answer of An information system within a business organisations...

Question 9

Restructuring and transforming a business process by a fundamental rethink and redesign to achieve dramatic improvement in cost, quality etc...........
A)automation
B)business process reengineering
C)erp
D)modernisation

Accepted Answer

Business process reengineering is a fundamental rethink and redesign of a business process to achieve dramatic improvement in cost, quality, etc.

Question 10

A system of creating, delivering and receiving electronic message is...........
A)information system
B)communication system
C)electronic system
D)any of the above

Accepted Answer

A system specifically designed for creating, delivering, and receiving electronic messages is best described as a communication system.

Question 11

A set of tools to help application developers to complete software development quickly and accurately is
A)cad
B)cam
C)case
D)cim

Accepted Answer

CASE, which stands for Computer-Aided Software Engineering, is a set of tools designed to help application developers complete software development more quickly and accurately by automating many of the tasks involved in the development process.

Question 12

CIM stands for
A)computerised information system
B)computer integrated manufacturing
C)common information system
D)commercial information system

Accepted Answer

CIM stands for Computer Integrated Manufacturing, which refers to the use of computer-controlled machinery and automation systems in manufacturing processes.

Question 13

A Business Information System planning technique that identify key business goal and strategies is
A)ais
B)csf
C)cad
D)cpm

Accepted Answer

CSF (Critical Success Factors) is the correct answer because it involves identifying the essential elements a business needs to achieve its goals and implement its strategies effectively. This technique focuses on the key areas that are critical for the success of the business.

Question 14

............ means "data about data"
A)processed data
B)mined data
C)meta data
D)mega data

Accepted Answer

Metadata is the term used to describe data that provides information about other data, essentially "data about data."

Question 15

......... gives information about information
A)schema
B)data dictionary
C)dml
D)ddl

Accepted Answer

A data dictionary provides metadata about database elements, essentially giving information about information, such as details about data types, structures, and constraints.

Question 16

Controls that are used to prevent incorrect data from being entered into database
A)data administration
B)data validation
C)data updating
D)data warehousing

Accepted Answer

Data validation controls are specifically designed to prevent incorrect or invalid data from being entered into a database by checking the data for errors before it is processed.

Question 17

A system that stores, retrieves, manages or otherwise manipulates a massive amounts of data from organisation's database and external sources.
A)data mining
B)data banking
C)dbms
D)data warehousing

Accepted Answer

Data warehousing is the process of storing, retrieving, managing, and analyzing large amounts of data from various sources, including an organization's database and external sources.

Question 18

An MIS professional responsible for planning ,designing and maintaining database is
A)application programmers
B)db manager
C)database administrator
D)all the above

Accepted Answer

The correct answer is C) database administrator. A database administrator (DBA) is responsible for the performance, integrity, and security of a database. They also plan, implement, and manage the overall database architecture, including the planning, design, and maintenance of the database.

Question 19

The activity of keeping a database up to date by adding, changing, or deleting data
A)data updating
B)data control
C)data banking
D)data maintenance

Accepted Answer

Data maintenance refers to the process of keeping a database up to date by adding, changing, or deleting data.

Question 20

DBMS is a collection of.....,.............
A)hardware and software
B)hardware only
C)software only
D)hardware, software, human ware

Accepted Answer

The answer of DBMS is a collection of.....,.............
A)hardware and software
B)hardware...

Quiz 6: Information Systems and Database Management: Part 1

---------- is a collection of logically related records and file

Which of the following is / are file organisation type?

…………… is an interface between users and the various databases

Information currently stored in the database is called……….

Which of the following is not included in three level of data abstraction

A system which record and report business transactions, flow of funds and generate financial statements is.....

The automatic transfer and positioning of work by machine without significant human intervention or operation is..........

An information system within a business organisations that support the traditional functions such as marketing, finance or production is.............

Restructuring and transforming a business process by a fundamental rethink and redesign to achieve dramatic improvement in cost, quality etc...........

A system of creating, delivering and receiving electronic message is...........

A set of tools to help application developers to complete software development quickly and accurately is

CIM stands for

A Business Information System planning technique that identify key business goal and strategies is

............ means "data about data"

......... gives information about information

Controls that are used to prevent incorrect data from being entered into database

A system that stores, retrieves, manages or otherwise manipulates a massive amounts of data from organisation's database and external sources.

An MIS professional responsible for planning ,designing and maintaining database is

The activity of keeping a database up to date by adding, changing, or deleting data

DBMS is a collection of.....,.............