Worksheets2025-26-1S-PROF2-SF EXAM
Total questions: 100
Worksheet time: 17mins
Name
Class
Date
1.
A form acts as a ______ between user and system.
a)
A. Barrier
b)
B. Interface
c)
C. Record
d)
D. Storage
2.
Forms should be designed to minimize user ______.
a)
A. Effort
b)
B. Clarity
c)
C. Validation
d)
D. Reports
3.
A well-designed form captures data ______ at the source.
a)
A. Accurately
b)
B. Randomly
c)
C. Incompletely
d)
D. Slowly
4.
Forms must reduce ______ by guiding user input.
a)
A. Errors
b)
B. Files
c)
C. Tables
d)
D. Records
5.
Pre-printed labels are an example of a ______ form.
a)
A. Turnaround
b)
B. Hardcopy
c)
C. Softcopy
d)
D. Display
6.
Online forms typically include ______ validation.
a)
A. Random
b)
B. Input
c)
C. Manual
d)
D. Paper-based
7.
A ______ form serves both as output and input.
a)
A. Turnaround
b)
B. Standard
c)
C. Blank
d)
D. Interim
8.
The first step in form design is identifying ______ needs.
a)
A. User
b)
B. Hardware
c)
C. Managerial
d)
D. Storage
9.
To ensure readability, forms must follow proper ______ design.
a)
A. Layout
b)
B. Database
c)
C. File
d)
D. Graph
10.
Input masks in forms help restrict ______ entry.
a)
A. Unauthorized
b)
B. Incorrect
c)
C. Random
d)
D. Multiple
11.
Good forms reduce the cost of ______ operations.
a)
A. Database
b)
B. Data entry
c)
C. Backup
d)
D. Security
12.
A form should avoid ______ data fields.
a)
A. Duplicate
b)
B. Labeled
c)
C. Numeric
d)
D. Single
13.
Drop-down lists in forms help in ______ selection.
a)
A. Controlled
b)
B. Random
c)
C. Manual
d)
D. Duplicate
14.
Forms should allow ______ correction for user mistakes.
a)
A. Easy
b)
B. Complex
c)
C. Restricted
d)
D. Delayed
15.
Forms design directly impacts system ______.
a)
A. Accuracy
b)
B. Security
c)
C. Cost
d)
D. Revenue
16.
Turnaround forms are only used as output.
a)
True
b)
False
17.
Online forms often use input validation.
a)
True
b)
False
18.
Form design has no effect on system accuracy.
a)
True
b)
False
19.
Drop-down lists improve control of input.
a)
True
b)
False
20.
Duplicated fields increase usability.
a)
True
b)
False
21.
Forms should be designed around user needs.
a)
True
b)
False
22.
Layout has little role in readability.
a)
True
b)
False
23.
Turnaround forms serve as both input and output.
a)
True
b)
False
24.
Input masks help prevent incorrect data entry.
a)
True
b)
False
25.
Forms design influences data entry costs.
a)
True
b)
False
26.
A file is a collection of related ______.
a)
A. Records
b)
B. Tables
c)
C. Fields
d)
D. Codes
27.
A record is a group of related ______.
a)
A. Files
b)
B. Fields
c)
C. Programs
d)
D. Codes
28.
Files are the building blocks of a ______ system.
a)
A. Data
b)
B. Database
c)
C. Storage
d)
D. Security
29.
A ______ file holds data permanently.
a)
A. Temporary
b)
B. Master
c)
C. Backup
d)
D. Transaction
30.
A ______ file updates the master file.
a)
A. Program
b)
B. Transaction
c)
C. Control
d)
D. Record
31.
Backup files protect against data ______.
a)
A. Recovery
b)
B. Loss
c)
C. Redundancy
d)
D. Duplication
32.
File organization determines how ______ are stored.
a)
A. Records
b)
B. Programs
c)
C. Queries
d)
D. Databases
33.
In sequential organization, records are stored in ______ order.
a)
A. Random
b)
B. Indexed
c)
C. Linear
d)
D. Sorted
34.
Random file organization uses a ______ function.
a)
A. Sorting
b)
B. Hashing
c)
C. Validation
d)
D. Memory
35.
Indexed organization uses an ______ to locate records.
a)
A. Array
b)
B. Pointer
c)
C. Index
d)
D. Code
36.
The key field uniquely identifies each ______.
a)
A. File
b)
B. Record
c)
C. Index
d)
D. Field
37.
A backup file is created to guard against ______ failure.
a)
A. Program
b)
B. Hardware
c)
C. Human
d)
D. Any
38.
File access methods include sequential, random, and ______.
a)
A. Indexed
b)
B. Parallel
c)
C. Manual
d)
D. Stored
39.
A control file is mainly used for ______ purposes.
a)
A. Security
b)
B. Input
c)
C. Output
d)
D. Maintenance
40.
Data redundancy is reduced by proper file ______.
a)
A. Naming
b)
B. Organization
c)
C. Coding
d)
D. Printing
41.
A record is made up of fields.
a)
True
b)
False
42.
Transaction files permanently store all data.
a)
True
b)
False
43.
Backup files are created to prevent data loss.
a)
True
b)
False
44.
Hashing is used in sequential organization.
a)
True
b)
False
45.
Indexed files use keys to find records.
a)
True
b)
False
46.
The master file contains temporary data.
a)
True
b)
False
47.
Random file organization requires a hashing function.
a)
True
b)
False
48.
Control files are used to manage security.
a)
True
b)
False
49.
File redundancy improves efficiency.
a)
True
b)
False
50.
File organization affects storage and access.
a)
True
b)
False
51.
A database is an organized collection of ______.
a)
A. Codes
b)
B. Data
c)
C. Programs
d)
D. Fields
52.
In a hierarchical database, data is organized in a ______ structure.
a)
A. Circular
b)
B. Tree
c)
C. Grid
d)
D. Mesh
53.
The relational model organizes data into ______.
a)
A. Programs
b)
B. Tables
c)
C. Codes
d)
D. Graphs
54.
A network database organizes data using ______.
a)
A. Pointers
b)
B. Keys
c)
C. Hashing
d)
D. Trees
55.
Object-oriented databases combine data with ______.
a)
A. Functions
b)
B. Records
c)
C. Objects
d)
D. Methods
56.
Relational databases use ______ to link tables.
a)
A. Arrays
b)
B. Keys
c)
C. Trees
d)
D. Graphs
57.
NoSQL databases are most suited for ______ data.
a)
A. Structured
b)
B. Unstructured
c)
C. Numeric
d)
D. Sorted
58.
The primary key uniquely identifies each ______ in a table.
a)
A. Field
b)
B. Record
c)
C. Column
d)
D. Attribute
59.
The foreign key establishes ______ between tables.
a)
A. Duplication
b)
B. Relationship
c)
C. Sorting
d)
D. Hashing
60.
Distributed databases store data across multiple ______.
a)
A. Disks
b)
B. Networks
c)
C. Locations
d)
D. Programs
61.
Cloud databases provide ______ access.
a)
A. Offline
b)
B. On-demand
c)
C. Restricted
d)
D. Manual
62.
A database schema defines database ______.
a)
A. Size
b)
B. Structure
c)
C. Keys
d)
D. Memory
63.
Temporal databases manage data involving ______.
a)
A. Space
b)
B. Time
c)
C. Size
d)
D. Memory
64.
Object-relational databases combine relational and ______ models.
a)
A. Network
b)
B. Object-oriented
c)
C. Hierarchical
d)
D. Flat-file
65.
Flat-file databases store data in a single ______.
a)
A. Record
b)
B. File
c)
C. Program
d)
D. Column
66.
Hierarchical databases use a tree structure.
a)
True
b)
False
67.
Relational databases organize data into graphs.
a)
True
b)
False
68.
NoSQL databases handle unstructured data.
a)
True
b)
False
69.
A foreign key duplicates data across tables.
a)
True
b)
False
70.
Distributed databases store data in one location only.
a)
True
b)
False
71.
Cloud databases allow on-demand access.
a)
True
b)
False
72.
Temporal databases focus on time-based data.
a)
True
b)
False
73.
Flat-file databases contain multiple tables.
a)
True
b)
False
74.
Object-oriented databases combine data with methods.
a)
True
b)
False
75.
A schema defines database structure.
a)
True
b)
False
76.
System development involves creating an ______ system.
a)
A. Outdated
b)
B. New
c)
C. Partial
d)
D. Manual
77.
The development process begins with ______ analysis.
a)
A. Testing
b)
B. Requirement
c)
C. Training
d)
D. Maintenance
78.
The main output of requirement analysis is an ______ document.
a)
A. SRS
b)
B. Test
c)
C. Budget
d)
D. Review
79.
Designing a system includes both logical and ______ design.
a)
A. Manual
b)
B. Physical
c)
C. Financial
d)
D. Temporary
80.
______ development allows changes during the process.
a)
A. Agile
b)
B. Sequential
c)
C. Parallel
d)
D. Direct
81.
The waterfall model follows a ______ sequence.
a)
A. Cyclic
b)
B. Linear
c)
C. Parallel
d)
D. Random
82.
Implementation may use direct cutover or ______ conversion.
a)
A. Indirect
b)
B. Parallel
c)
C. Manual
d)
D. Digital
83.
A prototype is built to gather user ______.
a)
A. Approval
b)
B. Feedback
c)
C. Hardware
d)
D. Revenue
84.
Testing ensures the system meets ______ requirements.
a)
A. Vendor
b)
B. User
c)
C. Manual
d)
D. Random
85.
Maintenance helps improve system ______ over time.
a)
A. Complexity
b)
B. Performance
c)
C. Failure
d)
D. Obsolescence
86.
Adaptive maintenance modifies systems for ______ changes.
a)
A. Technical
b)
B. Legal
c)
C. Environmental
d)
D. Any
87.
Corrective maintenance addresses ______.
a)
A. Bugs
b)
B. Users
c)
C. Design
d)
D. Hardware
88.
Perfective maintenance aims at ______ improvements.
a)
A. Financial
b)
B. Functional
c)
C. Structural
d)
D. Random
89.
The spiral model emphasizes ______.
a)
A. Risk analysis
b)
B. Speed
c)
C. Cost
d)
D. Testing
90.
User training is usually part of system ______.
a)
A. Analysis
b)
B. Implementation
c)
C. Maintenance
d)
D. Design
91.
The SRS is created during design.
a)
True
b)
False
92.
Agile development is flexible.
a)
True
b)
False
93.
The waterfall model is parallel in nature.
a)
True
b)
False
94.
Parallel conversion runs old and new systems together.
a)
True
b)
False
95.
Prototypes help gather user feedback.
a)
True
b)
False
96.
Testing verifies compliance with user requirements.
a)
True
b)
False
97.
Adaptive maintenance is only technical.
a)
True
b)
False
98.
Corrective maintenance deals with bugs.
a)
True
b)
False
99.
Perfective maintenance improves functionality.
a)
True
b)
False
100.
Spiral model ignores risks.
a)
True
b)
False
100 %
