0

System Analysis and Design Test

Description: Online Multiple Choice Test in System Analysis and Design for the Students to improve their skills
Number of Questions: 25
Created by:
Tags: IT Information Technology Computer SAD Business System Computer Analysis and Design Databases Programming Data Communication & Networks
Attempted 0/25 Correct 0 Score 0

Which one of the following is not a top management function?

  1. Planning

  2. Organising

  3. Decision making

  4. Day to day operations


Correct Option: D

Which one of the following is not a data security measure?

  1. Using password to access

  2. Using retention periods for all files

  3. Allowing only EDP personnel to access any file

  4. None of these


Correct Option: D

A data dictionary is

  1. a comprehensive integration collection of data about data

  2. a dictionary or algorithm for obtaining the address of logical records on a storage device

  3. the relationship among the different fields of data in a secondary storage

  4. none of these


Correct Option: A

A prototype

  1. is a working system which will be changed through several iterations

  2. helps in crystallising essential design requirements

  3. will provide preliminary information on the workability of the concept

  4. All of the above


Correct Option: D

The provident fund (PF) contribution rate for employees was hardly coded (made part of the program) in a payroll system. Whenever rate changes, it meant program modification. Which of the following is most appropriate?

  1. It would have been better to have designed PF rates to be input from the console

  2. It would have been more efficient to have designed PF rates as batch inputs

  3. Hard coding has helped in minimizing input errors and in faster execution time

  4. Data that changes rarely can be hardly coded


Correct Option: D

A parallel run involves

  1. firing two different applications from different terminals accessing a common database

  2. compiling programs with two different languages

  3. the concurrent operation of the existing and newly developed systems

  4. none of these


Correct Option: C

All of the following are examples of physical security, EXCEPT

  1. limited access to the computer complex

  2. using password to access a system

  3. CCTV camera

  4. storing tapes and disks not in use in a separate building


Correct Option: B

Loss of data integrity implies that data is

  1. not suitable for running in an integrated environment

  2. inconsistent

  3. repeated

  4. outdated


Correct Option: B

A menu driven software

  1. helps the user in reducing errors in data entry

  2. is developed for planning meals at a restaurant

  3. contains options for the user to indicate his/her choice

  4. all of the above


Correct Option: C

In a DBMS, two record types and their relationship is called

  1. schema

  2. segment

  3. set

  4. database record


Correct Option: A

Online data entry is preferable to batch data entry because

  1. it ensures better accuracy

  2. it is faster

  3. it reduces human efforts in checking control totals, check-list, etc.

  4. all of the above


Correct Option: B

An Automatic Teller Machine (ATM) represents

  1. an online banking system

  2. a dedicated PC based system

  3. a combination of batch-cum-on-line system

  4. none of these


Correct Option: A

Which of the following fact finding techniques is the most useful in collecting quantitative data?

  1. Interviews

  2. Old records

  3. Questionnaires

  4. All of the above


Correct Option: C

The primary function of a LAN is

  1. permitting access to certain files by every user

  2. extending electronic messaging facility

  3. optimizing resource sharing

  4. all of the above


Correct Option: D

In a hospital data base system, the data relationship between the entity “Patient” and the entity “ward” would be

  1. one-to-one

  2. one-to-many

  3. many-to-one

  4. many-to-many


Correct Option: D

Structured english is

  1. grammatically correct description of the system

  2. a tool for the system analyst to document the processing procedures using action oriented verbs and terms defined in the data dictionary

  3. a COBOL statement in the PROCEDURE DIVISION

  4. none of these


Correct Option: B

Steering committee

  1. sanctions budget to the EDP department

  2. is a forum for interaction between users and EDP personnel

  3. guides the EDP department what to do

  4. none of these


Correct Option: C

Which of the following characteristics is included in Structured systems development cycle approach?

  1. Top - down

  2. Data flow

  3. Data structure

  4. None of these


Correct Option: D

Which is the most critical phase of the SDLC?

  1. Feasibility study

  2. Systems analysis

  3. Systems design

  4. All of the above


Correct Option: D

Which of the following is not a part of MIS?

  1. Exception report for middle management

  2. Summary report for top management

  3. Action report for line management

  4. Payroll for workers


Correct Option: D

Data integrity stands for

  1. thoroughly validated data

  2. data stored in different files showing consistency

  3. data fields integrated to provide summary

  4. none of these


Correct Option: D

Which of the following statements is incorrect regarding DFDs?

  1. DFDs show the sequence of steps

  2. DFDs are different from flow charts

  3. DFDs are system's analyst tools

  4. None of these


Correct Option: D

Prototype is a

  1. mini model of the existing system

  2. mini model of the proposed system

  3. working model of the existing system

  4. none of these


Correct Option: B

The feasibility report of an existing system highlights

  1. data flow and processing

  2. information needs

  3. problem areas

  4. all of the above


Correct Option: C

Study the decision table below ||| |---|---| | A| B| ||||||| |---|---|---|---|---|---| | Is student female?| Y| N| -| -| -| | Is she taking > 10 crdt hrs?| N| -| Y| -| -| | Is she <100 cm tall?| N| -| -| Y| -| | Does she weigh>10 Kg?| Y| -| -| -| N| | C| | | | D| | | List her name and address| X| -| -| -| -| | Skip to next student| X| X| X| X| |

The decision table implies

  1. do not select the student weighing more than 45 Kg

  2. select the student if she is at least 160 cm tall even if she does not weigh 45 Kg

  3. do not select male student

  4. select the student who is taking more than 10 credits hours


Correct Option: A
- Hide questions