Question 1

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

Accepted Answer

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

Question 2

Verification is the responsibility of

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

Management information systems (MIS)

Accepted Answer

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 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

The elements of control will consist of

Accepted Answer

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

Question 9

SELECT * FROM employee What type of statement is this?

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

Audit gives details about to Account Payable System

Accepted Answer

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

Question 12

The raw facts and figures are

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Entity is a _____________

Accepted Answer

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

Question 15

The back bone of any organization is

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

Which of the following is NOT an objective of MIS?

Accepted Answer

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 18

The flow of information through MIS is

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

Exam 1: Information Systems and Database Management