Deck 1: Information Systems and Database Management

Question 1

The information of MIS comes from the

A)Internal source
B)External source
C)Both internal and external source
D)None of the above

Answer 1

Both internal and external source

Question 2

The back bone of any organization is

A)information
B)employee
C)management
D)capital

Answer 2

information

Question 3

The flow of information through MIS is

A)Need dependent
B)Organization dependent
C)Information dependent
D)Management dependent

Answer 3

Need dependent

Question 4

Internal information for MIS may come from any one of the following department.

A)Customers care department
B)HR department
C)Marketing department
D)Production department

Question 5

Which of the following is NOT an objective of MIS?

A)Facilitate the decisions-making process
B)Provide requisite information at each level of management
C)Support decision- making
D)Recruit people for system

Question 6

In MIS system design, the sources of information may be categorized as … and….

A)Internal, external
B)Personal, organizational
C)Useful, unuseful
D)Constructive, destructive

Question 7

Management information systems (MIS)

A)Create and share documents that support day-today office activities
B)Process business transactions (e.g., time cards, payments, orders, etc.)
C)Capture and reproduce the knowledge of an expert problem solver
D)Use the transaction data to produce information needed by managers to run

Question 8

To improve the performance of a business process, which of the following is most relevant?

A)Input
B)Processing
C)All of the above
D)Control and feedback

Question 9

What type of computer is specially designed and/or used for tasks that require extremely rapid and complex calculations?

A)PC
B)supercomputer
C)midrange computer
D)mainframe

Question 10

The raw facts and figures are

A)Data
B)Information
C)Snapshot
D)Reports

Question 11

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

A)DML
B)DDL
C)Query
D)Relational Schema

Question 12

SELECT * FROM employee What type of statement is this?

A)DML
B)DDL
C)View
D)Integrity Constraint

Question 13

To remove a relation from an SQL database, we use the command.

A)Delete
B)Purge
C)Remove
D)Drop table

Question 14

The clause is used to list the attributes desired in the result of a query.

A)Where
B)Select
C)From
D)Distinct

Question 15

In the given query which of the keyword has to be inserted?
INSERT INTO employee _____ (1002,Joey,2000);

A)Table
B)Values
C)Relation
D)Field

Question 16

Entity is a _____________  

A)Object of relation
B)Present working model
C)Thing in real world
D)Model of relation

Question 17

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

A)Simple attribute
B)Composite attribute
C)Multivalued attribute
D)Derived attribute

Question 18

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

A)Single valued
B)Multi valued
C)Composite
D)Derived

Question 19

An is a set of entities of the same type that share the same properties, or attributes.

A)Entity set
B)Attribute set
C)Relation set
D)Entity model

Question 20

Which of the following gives a logical structure of the database graphically?

A)Entity-relationship diagram
B)Entity diagram
C)Database diagram
D)Architectural representation

Question 21

Verification is the responsibility of

A)Developer
B)Designer
C)Tester
D)QA Team

Question 22

In a college,students are asked to develop a software. Which model would be preferable?

A)Waterfall model
B)Spiral model
C)Agile model
D)Code and fix model

Question 23

In waterfall model, output of one phase is input to next phase.

Question 24

The elements of control will consist of

A)Authority, Direction, Management
B)Authority, Direction, Information
C)Authority, Application, Management
D)Authority, Application, Information

Question 25

Audit gives details about to Account Payable System

A)ount balance
B)Transaction
C)Expenditure
D)All of the above