WorksheetsLONG QUIZ FOR INFO SYSTEM MNGT
Total questions: 50
Worksheet time: 50mins
Core activities in System Development Life Cycles consists of:
System Analysis - System Design - Programming - Testing - Conversion - Production Maintenance
System Design - System Analysis - Programming - Testing - Conversion - Production Maintenance
System Analysis - System Design - Programming - Conversion - Testing - Production Maintenance
System Design - System Analysis - Testing - Programming - Conversion - Production Maintenance
System analysis is the analysis of a problem that a firm tries to solve with an information system.
True
False
"identifying the information requirements that must be met by a system solution" is one of the activities in system analysis
True
False
System analysis process include all the following process, EXCEPT;
defining the code errors
identifying its causes
specifying the solution
identifying the information requirements that must be met by a system solution
Systems proposal report describes the costs and benefits, and the advantages and disadvantages, of each alternative.
True
False
Requirements analysis defines the objectives of the new or modified system and develops a detailed description of the functions that the new system must perform.
True
False
System design process describes system specifications that will deliver functions identified during systems analysis.
True
False
In system design specifications, which category and specification is NOT match?
Output - Origins, Flow, Data entry
User Interface - Simplicity, Efficiency, Logic, Feedback, Errors
Processing - Computations, Program modules, Required reports, Timing of outputs
Documentation - Operations documentation, Systems documents, User documentation
What is System Testing?
Testing each program separately in the system.
Tests the functioning of the information system as a whole.
Provides the final certification that the system is ready to be used in production setting where it evaluated by users and reviewed by management.
Test each sub systems by the programmers and end user who use the system.
What is Unit Testing?
Testing each program separately in the system.
Tests the functioning of the information system as a whole.
Provides the final certification that the system is ready to be used in production setting where it evaluated by users and reviewed by management.
Test each sub systems by the programmers and end user who use the system.
What is Acceptance Testing?
Testing each program separately in the system.
Tests the functioning of the information system as a whole.
Provides the final certification that the system is ready to be used in production setting where it evaluated by users and reviewed by management.
Test each sub systems by the programmers and end user who use the system.
Select the real software development methodologies.
(Select All That Apply)
Agile
Extreme Programming
XD
Spiral
Waterfall
Extreme Programming is a type of which software development methodology?
Agile
Rapid Application Development
Spiral
Waterfall
Identify the correct activities involve in the first phase of SDLC
review project request
conduct preliminary investigation
identify project development team
convert to new system
Which activities involve in analysis?
conduct feasibility studies
evaluate system security
convert to new system
perform detailed analysis of the old system
"My work is to go through the books of the company I am working for in order to establish what data is inputted into the system." In which phase is this activities perform?
During the Analysis phase.
During the Design phase.
During the Planning phase.
During the Maintenance phase.
There are several tools and techniques used for describing the system design of the system. These tools and techniques are: Flowchart, Data flow diagram (DFD), Data dictionary and others.
During the Analysis phase.
During the Design phase.
During the Planning phase.
During the Maintenance phase.
It deals with the coordination and use of three very important organizational resources - information, people and technology.
Maintenance Information Systems
Management Integrative Systems
Management Information Systems
Management Informative Systems
This is data that has a particular meaning within a specific context.
Data
Information
Business Intelligence
This is collective information about your customers, your competitors, your business partners, your competitive environment and your own internal operations that give you the ability to make effective, important and often strategic decisions.
Data
Information
Business Intelligence
This broad term includes the contextual explanation of business intelligence.
(a)
In defining information quality, this is how fast can you get access to the information as well as if the information is relevant to current period.
Timeliness
Location
Form
Validity
In defining information quality, this is a check if information is from a credible source.
Timeliness
Location
Form
Validity
Most important of all organizational/business resources as they set goals, carry out tasks, make decisions, serve customers, provide reliable tech environment so the org/business can run smoothly.
Information
People
Technology
A repository of data.
DATA
INFORMATION
DATABASE
DBMS
Software system that manages databases.
DATA
INFORMATION
DATABASE
DBMS
A collection of letters, numbers or facts, which by itself derive little or no value.
DATA
INFORMATION
DATABASE
DBMS
Process data that provides value.
DATA
INFORMATION
DATABASE
DBMS
The blueprint of any database system.
INFORMATION MODEL
DATA MODEL
NETWORK DATABASES
RELATIONAL DATABASES
Store data either in a parent record, called the owner, or in a child record called the member.
INFORMATION MODEL
DATA MODEL
NETWORK DATABASES
RELATIONAL DATABASES
Provides interface between data stored in database and application programs and queries.
FILE MANAGER
DATABASE MANAGER
DML PRECOMPILER
DDL COMPILER
The DBMS software together with the data itself.
DATABASE
DATA
MINI-WORLD
DATABASE SYSTEM
Procedure oriented Programming is also known as modular programming.
True
False
Which of the following is a limitation of procedure oriented programming paradigm.
Data/variables can be declared as global.
Data/variables can be declared as Local.
Main Program can be divided into sub programs.
Allow User defined functions.
What is data warehousing?
Data warehousing is the process of collecting, organizing, and storing large amounts of data from various sources to support business intelligence and reporting activities.
Data warehousing is the process of analyzing data to make predictions and forecasts.
Data warehousing is the process of securing and protecting data from unauthorized access.
Data warehousing is the process of transferring data between different systems.
What is data modeling?
Data modeling is the process of analyzing data to identify patterns and trends.
Data modeling is the process of creating a conceptual representation of data and its relationships to support business requirements.
Data modeling is the process of visualizing data using charts and graphs.
Data modeling is the process of organizing data in a database.
What are the benefits of data warehousing?
Decreased data integration capabilities, limited scalability, and reduced data accessibility.
Limited data analysis capabilities, decreased data processing speed, and reduced data governance.
Reduced data storage costs, faster data retrieval, and improved data security.
Improved data quality and consistency, enhanced decision-making capabilities, increased operational efficiency, and better customer insights.
What is data security?
Ensuring the physical security of data storage devices.
Preventing data loss due to hardware failure.
Protection of digital data from unauthorized access, use, disclosure, disruption, modification, or destruction.
Encrypting data during transmission.
What are some common data security threats?
ransomware attacks, denial of service attacks, password cracking, physical theft of devices
malware attacks, phishing scams, data breaches, insider threats, and social engineering
What is data quality?
Accuracy, completeness, consistency, and reliability
Efficiency, scalability, and flexibility.
Validity, timeliness, and relevance.
Precision, recall, and F1 score.
What are the dimensions of data quality?
accuracy, incompleteness, inconsistency, timeliness, and reliability.
accuracy, completeness, consistency, timeliness, and validity
relevance, reliability, inconsistency, timeliness, and validity.
accuracy, completeness, inconsistency, timeliness, and validity.
What is the purpose of data resource management?
To secure and protect data
To effectively and efficiently manage an organization's data resources.
To analyze and interpret data
To store and organize data
What is the difference between logical and physical database design?
Logical design focuses on the hardware components of the database, while physical design focuses on the software components.
Logical design involves creating tables and relationships, while physical design involves optimizing performance and storage.
Logical design is concerned with data modeling, while physical design is concerned with data manipulation.
The difference between logical and physical database design is that logical design focuses on the conceptual and functional aspects of the database, while physical design involves translating the logical design into a specific database management system.
