System Analysis and Design (PL/SQL Progg)

System Analysis and Design (PL/SQL Progg)

Question 1

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE: Type TRUE if the given statement is correct and FALSE if it is incorrect.

Use Decision trees when there are many conditions to be tested.

Answer: 

Question 2

Complete

Mark 1.00 out of 1.00

Flag question

Question text

A _________________ DFD is similar to a document flow diagram.

Select one:

a.

None of the choices

b.

Logical

c.

Relational

d.

Physical

Question 3

Complete

Mark 0.00 out of 1.00

Flag question

Question text

Which of the following does NOT describe Structured English?

Select one:

a.

Structured English should be understandable to the user

b.

Structured English is similar to Pascal programming

c.

Structured English should be written or follow the programming syntax rules and convention

d.

Structured English shows decision structure

Question 4

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Logical operators are used in constructing a Structured English, which of the following is not a logical operator?

Select one:

a.

NOT

b.

AND

c.

OR

d.

IF

e.

None of the choices

Question 5

Complete

Mark 1.00 out of 1.00

Flag question

Question text

A category of a DFD that focuses on business activities.

Select one:

a.

Logical DFD

b.

Relational DFD

c.

Individual DFD

d.

Physical DFD

Question 6

Complete

Mark 1.00 out of 1.00

Flag question

Question text

The objective of using structured English is to

Select one:

a.

describe computational procedures reasonably precisely which can be understood by any user

b.

expand a DFD so that a user can understand it

c.

ease writing programs for DFDs

d.

develop algorithms corresponding to processes in a DFD

Question 7

Complete

Mark 1.00 out of 1.00

Flag question

Question text

If the process p is expanded, the process at the next level will be labeled as

Select one:

a.

None of the choices

b.

p.1, p.2, p.3

c.

1.0, 2.0, 3.0

d.

p.a, p.b, p.c

Question 8

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE: Type TRUE if the given statement is correct and FALSE if it is incorrect.

Two data stores cannot be connected by a data flow

Answer: 

Question 9

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE: Type TRUE if the given statement is correct and FALSE if it is incorrect.

Data cannot flow from store to external entity.

Answer: 

Question 10

Complete

Mark 0.00 out of 1.00

Flag question

Question text

The Student Grading Information System needs to compute for the average grade on 10 quizzes of a student. What is the correct Structured English?

Select one:

a.

for quiz = 1 to quiz = 10 do

                  {

                                    Total Score = + Score

                  }

end for

Average = Total Score / 10

b.

for quiz >= 1 to quiz <= 10 do

                  {

                                    Total Score = Total Score + Score

Average = Total Score / 10

 

                  }

end for

c.

for quiz = 1 to quiz = 10 do

                  {

                                    Total Score = Total Score + Score

                  }

end for

Average = Total Score / 10

d.

for quiz = 1 to quiz = 10 do

                  {

                                    Total Score = Total Score + Score

Average = Total Score / 10

                  }

end for

Question 1

Complete

Mark 0.00 out of 1.00

Flag question

Question text

TRUE or FALSE. Use Structured English when there are large number of conditions to check and logic is complex.

Select one:

True

False

Question 2

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE: Type TRUE if the given statement is correct and FALSE if it is incorrect.

External entities can process data.

Answer: 

Question 3

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Keep the number of processes at each level ____.

Select one:

a.

None in the choices

b.

Minimum of 7

c.

Zero

d.

Less than 7

e.

One

Question 4

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Provides overview of the system to be designed.

Select one:

a.

Context Diagram

b.

Procedural Diagram

c.

None of the choice

d.

Relational Diagram

Question 5

Complete

Mark 1.00 out of 1.00

Flag question

Question text

A ____ mark in the decision table means that an action must be taken.

Select one:

a.

–

b.

X

c.

Y

d.

Any character

e.

Check

Question 6

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following is BEST in sequencing conditions by priority?

Select one:

a.

Any of the choices

b.

Decision Table

c.

Decision Trees

d.

Structured English

Question 7

Complete

Mark 0.00 out of 1.00

Flag question

Question text

A rectangle represents

Select one:

a.

An input or output of the system

b.

An external entity

c.

A data storage

d.

Start of the DFD

Question 8

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following is BEST for checking for completeness?

Select one:

a.

Decision Table

b.

Decision Trees

c.

Structured English

d.

Any of the choices

Question 9

Complete

Mark 0.00 out of 1.00

Flag question

Question text

A data flow diagram

Select one:

a.

Starts from a broad overview and expand it to a hierarchy of detailed diagrams

b.

Is a good communication tool between Systems Analyst and Head of the company requesting for the systems development.

c.

All of the choices

d.

None of the choices

e.

Provides attributes of the external entities

Question 10

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE: Type TRUE if the given statement is correct and FALSE if it is incorrect.

Structured English and Decision Table are procedural.

Answer: 

Question 1

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Which of the following is NOT included in the SRS document?

Select one:

a.

Project scope

b.

Non Functional requirements

c.

Functional requirements

d.

Programming Codes

e.

Project limitations

Question 2

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

Large detailed reports are highly structured.

Select one:

a.

The statement is FALSE. Replace large detailed reports with moderately structured.

b.

The statement is FALSE. Replace highly structured with structured.

c.

The statement is incomplete to identify if it is TRUE or FALSE.

d.

The statement is TRUE.

Question 3

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE. The “cost of delay in data processing” is an intangible cost.

Answer: 

Question 4

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

The ______ requires the operational information.

Select one:

a.

Line Manager

b.

All workers

c.

Top Manager

d.

Middle Manager

Question 5

Complete

Mark 1.00 out of 1.00

Flag question

Question text

The Answer feasibility examines whether the proposed method can fit in with existing organizational processes.

Question 6

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

What is the most important role of a systems analyst in business?

Select one:

a.

Specialized in programming technology

b.

Problem solving

c.

Knowing what data needs to be collected

d.

Technical understanding of information systems

Question 7

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

Questionnaires can be useful in information gathering when users ____.

Select one:

a.

Are widely distributed geographically

b.

Are not well informed

c.

Do not have time for interviews

d.

All of the choices

Question 8

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

During data gathering, interviews are conducted for the purpose of _____.

Select one:

a.

Familiarization of the data processing

b.

Initial introduction of the system requirements

c.

Gathering of input and output forms

d.

Presentation of the proposed information system

Question 9

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Write the letter that corresponds to the correct answer
This system is unstructured and difficult to obtain precise information.

Select one:

a.

Management Information System

b.

None of the choices

c.

Decision Support System

Question 10

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Given the goal, “Processed data at the fastest time within the working hours.”

Select one:

a.

The goal is quantified.

b.

The goal is not quantified.

Question 11

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE. The “cost of database migration service” is an intangible cost.

Answer: 

Question 12

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE. The “the cost of a hi-end server for application software” a tangible cost.

Answer: 

Question 13

Complete

Mark 1.00 out of 1.00

Remove flag

Question text

Choose the letter that corresponds to the correct answer:

Who among the following should be interviewed at the start of the project?

Select one:

a.

Rank in File Staff

b.

Supervisors

c.

Senior Manager

Question 14

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Identify whether the type of information is Strategic, Tactical, Operational or Statutory:

Marketing techniques of school branches and providing incentives to the best performing branch.
AnswerStrategicTacticalOperationalStatutory

Question 15

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE:

Develop a long questionnaire to capture all the issues and concerns on the system.

Select one:

True

False

Question 16

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

Middle Managers use

Select one:

a.

Strategic

b.

Tactical

c.

Operational

d.

Statutory

Question 17

Complete

Mark 1.00 out of 1.00

Flag question

Question text

__________ may include increased sales due to improved customer services or to managers having better information on which to base decisions.

Select one:

a.

Tangible savings

b.

Tangible benefits

c.

Intangible benefits

d.

Cost/Benefit Analysis

Question 18

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Identify whether the type of information is Strategic, Tactical, Operational or Statutory:

Available stocks in the every warehouse.
AnswerStrategicTacticalOperationalStatutory

Question 19

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

Which of the following is NOT a recommended technique during interview?

Select one:

a.

Allot a whole data interview

b.

In order that the client understand the proposed system, use IT/jargon terms.

c.

All of the choices

d.

Gather only quantitative data

Question 20

Complete

Mark 1.00 out of 1.00

Flag question

Question text

The software development team of TRA Global Software Company is understanding the existing system. The team is now in stage ________________________.

Select one:

a.

Requirements Specifications

b.

Requirements Determinations

c.

System Design

d.

System Implementation

Question 21

Complete

Mark 1.00 out of 1.00

Flag question

Question text

UML stands for

Select one:

a.

User interface Multi Language

b.

Unified Modelling Language

c.

Universal Management Library

d.

Utility Modelling Matrix

Question 22

Complete

Mark 1.00 out of 1.00

Flag question

Question text

John is estimating the cost and benefit of the proposed procurement system. At what stage of the software development cycle is this activity?

Select one:

a.

Systems Design

b.

Requirements Specifications

c.

System Implementation

d.

Requirements Determinations

e.

Feasibility Analysis

Question 23

Complete

Mark 0.00 out of 1.00

Remove flag

Question text

TRUE or FALSE:

Let the interviewee do most of the talking.

Select one:

True

False

Question 24

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

TRA Global Software Company was contracted to develop a system that would track the procurement process of XYZ Corporation. The Procurement Manager of XYZ Corp had identified several applications encompassing the proposed procurement system to TRA Global Software Company. At what stage of the software development cycle is this activity?

Select one:

a.

Feasibility Analysis

b.

Requirements Determinations

c.

System Implementation

d.

Systems Design

e.

Requirements Specifications

Question 25

Complete

Mark 1.00 out of 1.00

Flag question

Question text

At the end of the feasibility analysis,

Select one:

a.

a meeting should be set to discuss the hardware component of the system

b.

a document consisting of an executive summary on the feasibility of the project is submitted to the management which requested the study.

c.

systems development will start

d.

a prototype of the system will be presented to the management which requested the study

Question 26

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

John is one of the System Analysts of TRA Global Software Corporation. Which of the following manners should he observe during the interview?

Select one:

a.

Set a time limit for the interview

b.

Request to record the interview

c.

Ask questions to the interviewee after every topic

d.

All of the choices

Question 27

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

What is the most important and difficult task of a Systems Analyst?

Select one:

a.

Interview the end user of the system

b.

SRS development

c.

Interview the top management

d.

Data Gathering

Question 28

Complete

Mark 0.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

Aldrin is the Sr. Programmer of TRA Global Software Company. He received the list of modules to be fixed. He is now debugging the system. The software development is in ___________________.

Select one:

a.

System Implementation

b.

Systems Design

c.

System evaluation

d.

Systems modification

Question 29

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer.
This is the stage wherein user testing is being conducted.

Select one:

a.

System Implementation

b.

Systems Maintenance

c.

Systems programming

d.

System evaluation

e.

Systems Design

Question 30

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

SRS is developed by ________.

Select one:

a.

the systems analyst

b.

All of the choices

c.

the top and midlevel managers where it discusses information management.

d.

the end user or the system owner

Question 1

Complete

Mark 1.00 out of 1.00

Flag question

Question text

UML stands for

Select one:

a.

Universal Management Library

b.

Utility Modelling Matrix

c.

User interface Multi Language

d.

Unified Modelling Language

Question 2

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

John is one of the System Analysts of TRA Global Software Corporation. Which of the following manners should he observe during the interview?

Select one:

a.

Set a time limit for the interview

b.

All of the choices

c.

Ask questions to the interviewee after every topic

d.

Request to record the interview

Question 3

Complete

Mark 1.00 out of 1.00

Flag question

Question text

TRUE or FALSE:

Develop a long questionnaire to capture all the issues and concerns on the system.

Select one:

True

False

Question 4

Complete

Mark 1.00 out of 1.00

Flag question

Question text

This tool uses a simple stick figure. The simple stick figure is used to represent an actor and is given a name that characterizes the role that the actor is playing.

Select one:

a.

DFD

b.

Use Case

c.

UML

d.

OD

Question 5

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

Ronnie is the IT Engineer of the TRA Global Software Company. He identified the type of server, desktop computers needed to implement the proposed information system. What stage is the software development in?

Select one:

a.

System Implementation

b.

Hardware Study

c.

Server inventory Stage

d.

Server installation and implementation

Question 6

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

When designing a system, the following are good sources of information EXCEPT ____.

Select one:

a.

Business process

b.

Electronic forms

c.

Paper based forms

d.

Existing application system

e.

User experiences

f.

None of choices

Question 7

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

TRA Global Software Company was contracted to develop a system that would track the procurement process of XYZ Corporation. The Procurement Manager of XYZ Corp had identified several applications encompassing the proposed procurement system to TRA Global Software Company. At what stage of the software development cycle is this activity?

Select one:

a.

System Implementation

b.

Requirements Determinations

c.

Feasibility Analysis

d.

Systems Design

e.

Requirements Specifications

Question 8

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

In DFD, a pair of parallel lines represents ______.

Select one:

a.

Start of the process

b.

A process

c.

An entity

d.

A storage

Question 9

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

What is the most important role of a systems analyst in business?

Select one:

a.

Problem solving

b.

Specialized in programming technology

c.

Knowing what data needs to be collected

d.

Technical understanding of information systems

Question 10

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

The goal of this stage is to assess if it is possible to meet the requirements specified, subjected to constraints of budget, human resource and hardware.

Select one:

a.

Systems Design

b.

Feasibility Analysis

c.

System Implementation

d.

Requirements Determinations

e.

Requirements Specifications

Question 1

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

In a cigarette manufacturing, which of the following information is statutory?

Select one:

a.

List of supplies of raw materials

b.

The total defective machines for repair.

c.

The sales tax collected.

d.

Total number of cigarette ream produced in a year.

Question 2

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

Large detailed reports are highly structured.

Select one:

a.

The statement is FALSE. Replace large detailed reports with moderately structured.

b.

The statement is TRUE.

c.

The statement is FALSE. Replace highly structured with structured.

d.

The statement is incomplete to identify if it is TRUE or FALSE.

Question 3

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Identify whether the type of information is Strategic, Tactical, Operational or Statutory:

List of allocated and transferred budget to project sites.
AnswerStrategicTacticalOperationalStatutory

Question 4

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Identify whether the type of information is Strategic, Tactical, Operational or Statutory:

Report showing the completed, on-going and not yet started projects.
AnswerStrategicTacticalOperationalStatutory

Question 5

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Choose the letter that corresponds to the correct answer:

In a hotel information system, this type of information is strategic.

Select one:

a.

Putting up a restaurant and bar

b.

Increase number of hotel staff

c.

Approved license permit on health sanitation

d.

Data on hotel reservations

Question 6

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Identify whether the type of information is Strategic, Tactical, Operational or Statutory:
A matrix showing the attended and needed trainings of every employee per work category.
AnswerStrategicTacticalOperationalStatutory

Question 7

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Write the letter that corresponds to the correct answer
Processing the college entrance exam in a university every year is an example of

Select one:

a.

Batch Processing

b.

Real time processing

c.

OLTP

d.

None of the choices

Question 8

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Write the letter that corresponds to the correct answer
This system is unstructured and difficult to obtain precise information.

Select one:

a.

None of the choices

b.

Management Information System

c.

Decision Support System

Question 9

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Identify whether the type of information is Strategic, Tactical, Operational or Statutory:

List of existing projects and the number of beneficiaries per project.
AnswerStrategicTacticalOperationalStatutory

Question 10

Complete

Mark 1.00 out of 1.00

Flag question

Question text

Identify whether the type of information is Strategic, Tactical, Operational or Statutory
Corrective maintenance plan or schedule
AnswerStrategicTacticalOperationalStatutory