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

Accepted Answer

Management Information Systems (MIS) gather, process, and manage information from both internal and external sources to facilitate decision-making and problem-solving within an organization.

Question 2

The back bone of any organization is
A)information
B)employee
C)management
D)capital

Accepted Answer

A

Question 3

The flow of information through MIS is
A)Need dependent
B)Organization dependent
C)Information dependent
D)Management dependent

Accepted Answer

The flow of information through MIS is need dependent because the information that is needed by the management will be provided by the MIS.

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

Accepted Answer

The answer of Internal information for MIS may come from...

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

Accepted Answer

The primary objectives of a Management Information System (MIS) are to facilitate decision-making, provide necessary information at each level of management, and support the decision-making process. Recruiting people for the system is not an objective of MIS; it is more related to human resource management functions.

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

Accepted Answer

The sources of information in MIS (Management Information Systems) design are categorized as internal and external. Internal sources include data from within the organization, such as financial records, personnel records, and operational data. External sources refer to data from outside the organization, such as market trends, economic indicators, and information from competitors.

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

Accepted Answer

Management Information Systems (MIS) are designed to use transaction data to produce information that managers need to make decisions and run the organization effectively.

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

Accepted Answer

The answer of To improve the performance of a business...

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

Accepted Answer

Supercomputers are specifically designed for complex and rapid calculations, often used in scientific research, weather forecasting, and other computationally intensive tasks.

Question 10

The raw facts and figures are
A)Data
B)Information
C)Snapshot
D)Reports

Accepted Answer

Data refers to raw facts and figures that have not yet been processed or analyzed to derive meaning or conclusions. Information, on the other hand, is data that has been processed, organized, or structured in a way that adds context or meaning. Snapshots and reports typically represent information or data at a specific point in time or data that has been analyzed or summarized, respectively.

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

Accepted Answer

DML (Data Manipulation Language) is specifically designed for querying information from a database and for inserting, deleting, and modifying tuples in the database.

Question 12

SELECT * FROM employee What type of statement is this?
A)DML
B)DDL
C)View
D)Integrity Constraint

Accepted Answer

This is a Data Manipulation Language (DML) statement, specifically a SELECT query used to retrieve data from a database.

Question 13

To remove a relation from an SQL database, we use the command.
A)Delete
B)Purge
C)Remove
D)Drop table

Accepted Answer

The correct SQL command to remove a relation (or table) from a database is "DROP TABLE". This command deletes the table structure and its data permanently from the database.

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

Accepted Answer

The "Select" clause is used in SQL to specify the columns or attributes that should be returned in the result set of a query.

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

Accepted Answer

The correct keyword to complete the SQL INSERT INTO statement is "VALUES", which specifies the data that should be inserted into the table.

Question 16

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

Accepted Answer

An entity refers to a thing in the real world that can be distinctly identified. This could be a person, place, object, event, or concept.

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

Accepted Answer

Composite attributes are those that can be divided into smaller subparts, which represent more basic attributes with independent meanings. In the case of a full name that includes a first name, middle initial, and last name, it is considered a composite attribute because it can be broken down into these smaller components.

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

Accepted Answer

AGE is a derived attribute because it is calculated from another attribute, in this case, DATE_OF_BIRTH. Derived attributes are not stored directly but are derived from one or more stored attributes.

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

Accepted Answer

An entity set is a collection of similar types of entities. Each entity in an entity set has the same properties or attributes, which is why the correct answer is "Entity set."

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

Accepted Answer

Entity-relationship diagrams graphically represent the logical structure of databases, showing entities, attributes, and relationships.

Quiz 1: Information Systems and Database Management

The information of MIS comes from the

The back bone of any organization is

The flow of information through MIS is

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

Which of the following is NOT an objective of MIS?

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

Management information systems (MIS)

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

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

The raw facts and figures are

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?

SELECT * FROM employee What type of statement is this?

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

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

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

Entity is a _____________

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

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

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

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