Deck 6: Information Systems and Database Management: Part 2

Question 1

In.............. models data are conceived in the form of table

A)hierarchical database
B)network database
C)relational database
D)none of these

Answer 1

relational database

Question 2

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

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

Answer 2

eucs

Question 3

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

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

Answer 3

end user computing system

Question 4

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

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

Question 5

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

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

Question 6

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

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

Question 7

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

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

Question 8

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

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

Question 9

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

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

Question 10

A database that stores and manages objects

A)oodb
B)olap
C)oltp
D)oss

Question 11

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

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

Question 12

What displays the content of the active cell?

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

Question 13

A table in a relational database is known as

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

Question 14

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

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

Question 15

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

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

Question 16

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

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

Question 17

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

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

Question 18

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

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

Question 19

Which of the following is/are components of DBMS

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

Question 20

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

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

Question 21

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

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

Question 22

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

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