System Analysis and Design Test 2
Test Papers for the Engineering Graduates from Various Institutions to clear the concepts in SAD covers all chapters
Questions
The major step between system design and feasibility study is
- analysis activity
- equipment selection activity
- implementation activity
- none of the above
If a data dictionary is not included in the system analysis and design of a software project, then the following task cannot be carried out well. Identify the task.
- Over-all cost benefit analysis of the project
- Cross referencing and consistency checks of various data
- Bench marking of equipment to be purchased
- None of the above
Reason(s) for normalization is/are
- structure data
- simplify maintenance, eg: updates
- simplify retrieval, eg: query
- all of the above
Why is a data flow diagram referred to during the design of input?
- There is one to one relation between the input items and processes
- A DFD shows the storage methods for data files
- Input items are some of the data flows on the data flow diagram
- All of the above
'Removal of functional dependency from a relation' falls under the category of
- 1st form of Normalization
- 2nd form of Normalization
- 3rd form of Normalization
- none of the above
Major advantage(s) of systems developed using DBMS as compared to systems using conventional file system, is/are
- that the DBMS involves simultaneous updates of all data structures to keep the status current
- that conventional file system applications are inflexible
- that ad-hoc queries are not possible in conventional file system applications
- all of the above
Which of the following cannot be used for data entry?
- COM
- CDROM
- MICR
- None of the above
To ensure system quality
- system design should not be initiated unless user needs and software requirements specification are reviewed
- inspection should be carried out at pre-specified milestones
- a proper test plan should be prepared and followed
- all of the above
The main advantage of normalized relations in relational DBMS is that they
- are highly secure
- do not suffer from anomalies during delete and update operations
- occupy minimal storage
- all of the above
When is menu interface for a convenient way of user interaction?
- For data processing in a restaurant
- When mouse is used as the main input device
- When data has to be imported from a spreadsheet
- When it is difficult for the user to remember all the options available and for typing in complicated commands
Chaining and linking are frequently used techniques in respect of storage of records in
- tables
- files
- access
- none of the above
Which one of the following statements is incorrect?
- A report format can show vertical lines in a report.
- A report format file can show any object within a box.
- Current date can be shown in page header as well as page footer.
- None of the above
________ is/are included in the implementation phase of SASD.
- Parallel run
- Sizing
- Specification freeze
- All of the above
Which of the following is not used in end-user training before implementation?
- CAI
- Multi Media
- User manual
- None of the above
Stub is met within the context of
- data communication
- testing of modules
- random access
- none of the above