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 
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 
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) 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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
A) Entity-relationship diagram 
B) Entity diagram 
C) Database diagram 
D) Architectural representation

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

Verification is the responsibility of

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

Management information systems (MIS)

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

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

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

The elements of control will consist of

SELECT * FROM employee What type of statement is this?

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

Audit gives details about to Account Payable System

The raw facts and figures are

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

Entity is a _____________

The back bone of any organization is

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

Which of the following is NOT an objective of MIS?

The flow of information through MIS is

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

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

Information Systems and Management Support Systems

Information Systems and Software Development Models

Filters

Exam 1: Information Systems and Database Management

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

Verification is the responsibility of

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

Management information systems (MIS)

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

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

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

The elements of control will consist of

SELECT * FROM employee What type of statement is this?

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

Audit gives details about to Account Payable System

The raw facts and figures are

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

Entity is a _____________

The back bone of any organization is

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

Which of the following is NOT an objective of MIS?

The flow of information through MIS is

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

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

Information Systems and Management Support Systems

Information Systems and Software Development Models

Filters