MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 48 Mcqs, each offering curated multiple-choice questions to sharpen your Systems Analysis and Design knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following does not describe a rule of correctness for drawing a physical DFD? |
| A. | a system that fulfills user requirements |
| B. | a system that works |
| C. | a system that provides adequate performance (throughput and response time) |
| D. | a system that is not cost effective |
| Answer» E. | |
| 2. |
Which of the following is(are) data distribution option(s)? |
| A. | replicate specific tables or subsets on different servers |
| B. | store all data on a single server |
| C. | store specific tables on different servers |
| D. | all of the above |
| Answer» E. | |
| 3. |
A table containing records that describe business events is: |
| A. | transaction file |
| B. | document file |
| C. | master file |
| D. | audit file |
| Answer» B. document file | |
| 4. |
To delete an existing record from a database, you would use: |
| A. | DCL |
| B. | DDL |
| C. | DML |
| D. | DLL |
| Answer» D. DLL | |
| 5. |
Which of the following is(are) goals of database design? |
| A. | a DB should be reliable |
| B. | a DB should be scalable |
| C. | a DB should support the business requirements of the information system |
| D. | all of the above |
| Answer» E. | |
| 6. |
Which technique assigns different columns to different database servers? |
| A. | vertical partitioning |
| B. | horizontal partitioning |
| C. | hierarchical partitioning |
| D. | segmented partitioning |
| Answer» B. horizontal partitioning | |
| 7. |
Which of the following is NOT a valid deletion rule? |
| A. | Delete:Restrict |
| B. | Delete:Default |
| C. | Delete:Cascade |
| D. | Delete:Set Null |
| Answer» C. Delete:Cascade | |
| 8. |
An application system can be mapped into how many different layers? |
| A. | one |
| B. | two |
| C. | three |
| D. | none of the above |
| Answer» E. | |
| 9. |
A language used by a DBMS to define a database or a view of a database is: |
| A. | DML |
| B. | DLL |
| C. | DCL |
| D. | DDL |
| Answer» E. | |
| 10. |
Which of the following is(are) shown on a network architecture DFD? |
| A. | processor specifications |
| B. | transport protocols |
| C. | clients and their physical locations |
| D. | all of the above |
| Answer» E. | |
| 11. |
Which of the following is(are) criteria for producing a quality data model? |
| A. | a good data model is complex |
| B. | a good data model is flexible |
| C. | a good data model is adaptable to future needs |
| D. | both (b) and (c) |
| Answer» E. | |
| 12. |
If two records in a student table would have the same value for StudentID, this would violate: |
| A. | key integrity |
| B. | referential integrity |
| C. | table integrity |
| D. | physical integrity |
| Answer» B. referential integrity | |
| 13. |
Which of the following is NOT an information system application layer? |
| A. | data layer |
| B. | database layer |
| C. | presentation layer |
| D. | application logic layer |
| Answer» C. presentation layer | |
| 14. |
A server that hosts services for e-mail, calendaring, and other work group functionality is known as a(n): |
| A. | groupware server |
| B. | communication server |
| C. | exchange server |
| D. | application server |
| Answer» B. communication server | |
| 15. |
Many relational DBMSs can automatically enforce Delete:Cascade rule of referential integrity using |
| A. | triggers |
| B. | stored procedures |
| C. | views |
| D. | DCL |
| Answer» B. stored procedures | |
| 16. |
The CustomerID field in a customer table can not be left blank. This is an example of: |
| A. | domain integrity |
| B. | logical integrity |
| C. | referential integrity |
| D. | none of the above |
| Answer» E. | |
| 17. |
Which technique allocates different rows in a table to different database servers? |
| A. | vertical partitioning |
| B. | segmented partitioning |
| C. | hierarchical partitioning |
| D. | horizontal partitioning |
| Answer» E. | |
| 18. |
A system in which the components of an information system are distributed to multiple locations in a computer network is known as a: |
| A. | database system |
| B. | networked system |
| C. | distributed system |
| D. | communication system |
| Answer» D. communication system | |
| 19. |
Which of the following define the application architecture for an information system? |
| A. | the implementation technology for all software to be developed in-house |
| B. | the technology to be used to implement the user interface |
| C. | the distribution of stored data across a network |
| D. | all of the above |
| Answer» E. | |
| 20. |
Which form of distribution is the simplest and the easiest to maintain? |
| A. | vertical distribution |
| B. | centralization |
| C. | replication |
| D. | horizontal distribution |
| Answer» C. replication | |
| 21. |
The set of instructions for how to tie a bow is an example of the _____Structure. |
| A. | Control |
| B. | Selection |
| C. | Sequence |
| D. | Repetition |
| Answer» D. Repetition | |
| 22. |
Among the attributes of a good systems analyst the following are essentiali) knowledge of organizationii) analytical mindiii) ability to communicate orallyiv) excellent mathematical abilities |
| A. | i and ii |
| B. | i, ii and iii |
| C. | i, ii and iv |
| D. | i, iii and iv |
| Answer» C. i, ii and iv | |
| 23. |
System analysts have to interact withi) managers of organizationsii) users in the organizationiii) programming teamiv) data entry operator |
| A. | iii and iv |
| B. | i, ii and iii |
| C. | ii, iii and iv |
| D. | ii and iii |
| Answer» C. ii, iii and iv | |
| 24. |
The responsibilities of a system analyst includei) defining and prioritizing information requirement of an organizationii) gathering data, facts and opinions of users in an organizationiii) drawing up specifications of the system for an organizationiv) designing and evaluating the system |
| A. | i and ii |
| B. | i, ii and iv |
| C. | i, ii, iii and iv |
| D. | i, ii and iii |
| Answer» E. | |
| 25. |
After the design phase the document prepared is known as……………… |
| A. | system specification |
| B. | performance specification |
| C. | design specification |
| D. | None of these |
| Answer» D. None of these | |
| 26. |
The main objective of system evaluation is |
| A. | to see whether the system met specification |
| B. | to improve the system based on operational experience for a period |
| C. | to remove bugs in the programs |
| D. | to asses the efficiency of the system |
| Answer» C. to remove bugs in the programs | |
| 27. |
The approach used in top‐down analysis and design is |
| A. | to identify the top level functions by combining many smaller components into a single entity |
| B. | to prepare flow charts after programming has been completed |
| C. | to identify a top level function an d then create a hierarchy of lower‐level modules and components. |
| D. | All of the above |
| Answer» D. All of the above | |
| 28. |
System design is carried out |
| A. | as soon as system requirements are determined |
| B. | whenever a system analyst feels it is urgent |
| C. | after final system specifications are approved by the organization |
| D. | whenever the user management feels it should be done |
| Answer» D. whenever the user management feels it should be done | |
| 29. |
The primary objective of system design is to |
| A. | design the programs, databases and test plan |
| B. | design only user interfaces |
| C. | implement the system |
| D. | find out how the system will perform |
| Answer» B. design only user interfaces | |
| 30. |
System evaluation is carried out |
| A. | after the system has been operational for a reasonable time |
| B. | during system implementation |
| C. | whenever managers of user organization want it |
| D. | whenever operational staff want it |
| Answer» B. during system implementation | |
| 31. |
Actual programming of software code is done during the ____________step in the SDLC. |
| A. | Maintenance and Evaluation |
| B. | Design |
| C. | Analysis |
| D. | Development and Documentation |
| Answer» E. | |
| 32. |
Managers in organizations should not design their own systems as |
| A. | systems have to interact with other systems |
| B. | they do not have the special skills necessary to design systems |
| C. | it is not their job |
| D. | they are always very busy |
| Answer» C. it is not their job | |
| 33. |
Difference between Decision - Tables and Decision Trees is (are) |
| A. | value to end user |
| B. | form of representation |
| C. | one shows the logic while other shows the process |
| D. | All of the above |
| Answer» C. one shows the logic while other shows the process | |
| 34. |
Structured charts are a product of |
| A. | requirements gathering |
| B. | requirements analysis |
| C. | design |
| D. | coding |
| Answer» D. coding | |
| 35. |
Systems analyst should use software tools in their work as |
| A. | all analysts use them |
| B. | they assist in systematic design of systems |
| C. | they are inexpensive |
| D. | they are easily available |
| Answer» C. they are inexpensive | |
| 36. |
____________ spend most of their time in the beginning stages of the SDLC, talking with end-users, gathering information, documenting systems, and proposing solutions. |
| A. | Systems analysts |
| B. | Project managers |
| C. | Network engineers |
| D. | Database administrators |
| Answer» B. Project managers | |
| 37. |
____________ manage the system development, assign staff, manage the budget and reporting, and ensure that deadlines are met. |
| A. | Project managers |
| B. | Network engineers |
| C. | Graphic designers |
| D. | Systems analysts |
| Answer» B. Network engineers | |
| 38. |
HIPO means |
| A. | is a forms-driven technique in which standard forms are used to document the information |
| B. | consists of a hierarchy chart and an associated set of input/process/ output charts |
| C. | captures the essence of top down decomposition. |
| D. | All of the above |
| Answer» E. | |
| 39. |
Which of the following is(are) utilized in Rapid Application Development (RAD)? |
| A. | structured techniques |
| B. | joint application development techniques |
| C. | object-oriented design techniques |
| D. | both (a) and (b) |
| Answer» E. | |
| 40. |
Which of the following is NOT a disadvantage of prototyping? |
| A. | errors can not be detected as easily when a prototype is developed |
| B. | prototypes are a passive model of the system |
| C. | end-users do not fully understand their requirements until they see them |
| D. | none of the above |
| Answer» E. | |
| 41. |
Which of the following is the first task undertaken by system developers during the procurement phase? |
| A. | validate vendor claims and performances |
| B. | research technical criteria and options |
| C. | award contract and debrief vendor |
| D. | solicit proposals or quotes |
| Answer» C. award contract and debrief vendor | |
| 42. |
A document that is prepared to solicit competitive proposals and quotes from several different candidate vendors and/or project is a: |
| A. | request for vendor proposal |
| B. | request for specification |
| C. | request for quotation |
| D. | none of the above |
| Answer» E. | |
| 43. |
Which one of the following is an example of model-driven approaches? |
| A. | structured design, rapid application development, CASE |
| B. | information engineering, CASE, joint application design |
| C. | object-oriented design, joint application, and rapid application development |
| D. | none of the above |
| Answer» E. | |
| 44. |
In the procurement phase, which of the following is NOT a resource used to conduct research on technical alternatives? |
| A. | vendor qualifications |
| B. | internal standards |
| C. | trade newspapers and periodicals |
| D. | information services |
| Answer» B. internal standards | |
| 45. |
A process model used to communicate the technical implementation characteristics of an information system is a(n): |
| A. | environmental model |
| B. | physical data model |
| C. | logical data model |
| D. | class diagram |
| Answer» C. logical data model | |
| 46. |
Which of the following is NOT a task of the procurement phase? |
| A. | evaluate and rank vendor proposals |
| B. | validate vendor claims and performances |
| C. | develop system models for each of the vendor’s proposals |
| D. | research technical criteria and options |
| Answer» D. research technical criteria and options | |
| 47. |
Structured design seeks to factor a program into the top-down hierarchy of modules that have the following properties: |
| A. | highly cohesive and highly coupled |
| B. | loosely structured and loosely cohesive |
| C. | loosely cohesive and highly coupled |
| D. | none of the above |
| Answer» E. | |
| 48. |
Which of the following is the first step in designing a system for in-house development? |
| A. | design the system interface |
| B. | design the application architecture |
| C. | package design specifications |
| D. | design the system database |
| Answer» C. package design specifications | |