Question 1

What displays the content of the active cell?

Accepted Answer

A)  name box
B)  row headings
C)  formula bar
D)  task pane C

Question 2

In Excel each work book will consists of............. work sheets by default

Accepted Answer

A)  5
B)  10
C)  2
D)  3 D

Question 3

A primary key which is appeared in related tables is known as.............of related or secondary table

Accepted Answer

A)  super key
B)  candidate key
C)  foreign key
D)  alternate key C

Question 4

............... is simply speaking a spread sheet application.

Accepted Answer

A)  ms excel
B)  qpro
C)  lotus 123
D)  all of these

Question 5

Which of the following is/are components of DBMS

Accepted Answer

A)  dml
B)  ddl
C)  data dictionary
D)  all of these

Question 6

An information system that process data arising from occurrence of business transactions

Accepted Answer

A)  business information system
B)  transaction processing system
C)  transaction support system
D)  business support system

Question 7

An information system that directly support both the operational and managerial applications of end users

Accepted Answer

A)  eucs
B)  eis
C)  es
D)  dss

Question 8

The software that extends a production information system to other functional areas like finance, marketing, HR etc.

Accepted Answer

A)  material requirements planning
B)  manufacturing resource planning
C)  business information system
D)  management information system

Question 9

A set of programmes that uses data from master production schedule, inventory files and bill of materials to help and manage production and inventory

Accepted Answer

A)  material requirements planning
B)  manufacturing resource planning
C)  computer aided manufacturing
D)  pareto analysis

Question 10

............. is a facility in MS Word to create multiple letters and mails

Accepted Answer

A)  form letters
B)  mail merge
C)  dsd
D)  goal seek

Question 11

An executive information system with additional capabilities including data analysis, decision support, electronic mail, and personal productivity tools

Accepted Answer

A)  executive support system
B)  expert system
C)  decision support system
D)  management information system

Question 12

............ is the process of manipulation text using computer

Accepted Answer

A)  powerpoint
B)  access
C)  word processing
D)  animation

Question 13

A computer based information system that uses its knowledge about specific complex application area to act as an expert consultant to users.

Accepted Answer

A)  executive support system
B)  expert system
C)  decision support system
D)  management information system

Question 14

EUCS stands for.............

Accepted Answer

A)  executive uniform communication system
B)  end user computing system
C)  end user communication system
D)  executive usage computing system

Question 15

In DBMS ... is a field or combination of fields that uniquely identify each record in a table.

Accepted Answer

A)  referential integrity
B)  primary key
C)  relation
D)  tuple

Question 16

In DBMS ... ensures the validity of the relationship between two table remain intact.

Accepted Answer

A)  referential integrity
B)  primary key
C)  relation
D)  tuple

Question 17

Spread sheet type document is also known as..........

Accepted Answer

A)  draft document
B)  data source document
C)  work book
D)  tuples

Question 18

A table in a relational database is known as

Accepted Answer

A)  field
B)  record
C)  entity
D)  relation

Question 19

In Excel, What do you use to create a chart?

Accepted Answer

A)  pie wizard
B)  excel wizard
C)  data wizard
D)  chart wizard

Question 20

An information system that provides strategic information tailored to the needs of top management.

Accepted Answer

A)  executive information system
B)  expert system
C)  decision support system
D)  business information system

Exam 6: Information Systems and Database Management: Part 2

What displays the content of the active cell?

In Excel each work book will consists of............. work sheets by default

A primary key which is appeared in related tables is known as.............of related or secondary table

............... is simply speaking a spread sheet application.

Which of the following is/are components of DBMS

An information system that process data arising from occurrence of business transactions

An information system that directly support both the operational and managerial applications of end users

The software that extends a production information system to other functional areas like finance, marketing, HR etc.

A set of programmes that uses data from master production schedule, inventory files and bill of materials to help and manage production and inventory

............. is a facility in MS Word to create multiple letters and mails

An executive information system with additional capabilities including data analysis, decision support, electronic mail, and personal productivity tools

............ is the process of manipulation text using computer

A computer based information system that uses its knowledge about specific complex application area to act as an expert consultant to users.

EUCS stands for.............

In DBMS ... is a field or combination of fields that uniquely identify each record in a table.

In DBMS ... ensures the validity of the relationship between two table remain intact.

Spread sheet type document is also known as..........

A table in a relational database is known as

In Excel, What do you use to create a chart?

An information system that provides strategic information tailored to the needs of top management.