Worksheets2,00
Total questions: 100
Worksheet time: 3600secs
What does better data quality promote?
Slower decision making
Data inconsistency
Accuracy, validity, timeliness
Manual storage
What does ADO stand for?
Active Design Optimization
ActiveX Data Objects
Automated Data Operations
Adaptive Database Output
What is the primary purpose of ADO?
Encrypting documents
Accessing and manipulating data from various sources
Managing cloud infrastructure
Designing user interfaces
ADO provides access to which types of data sources?
Databases, spreadsheets, text files
Audio files, video streams, HTML pages
ZIP archives, PDFs, EXEs
RAM and CPU settings
What is one key advantage of ADO?
Requires no coding skills
Unified programming model for accessing different data sources
Only works with Microsoft Access
What does connected mode in ADO mean?
Uses Wi-Fi connection
Sends data via email
Maintains a live connection to the data source
Transfers data through USB
What is disconnected mode in ADO?
File is saved in CSV
Remote access is blocked
Data is stored in memory without a continuous connection
Data is lost after use
Which operations does ADO support?
Compiling and linking
Querying, updating, inserting, deleting
File editing and compression
Encryption and hashing
Where is ADO commonly used?
Desktop, web, and mobile applications
Operating system design
Game development only
Graphic rendering systems
What industries benefit from ADO’s data capabilities?
Which of the following is an example of Fintech and Healthtech?
Fintech and Healthtech
Sports and Music
Automotive and Fashion
What is software development methodology?
Network configuration technique
Software purchase method
Framework for planning and managing software projects
Internet browsing guideline
What is SDLC?
Software Design Layout Code
Software Development Life Cycle
Secure Data Logging Center
Software Data Load Cycle
What is a primary goal of SDLC?
Launch new hardware
Deliver high-quality software cost-effectively
Manage cloud platforms
Create social media campaigns
Which phase comes first in SDLC?
Planning & Analysis
Development
Testing
Deployment
What happens in the 'Define Requirements' phase?
Documents like SRS and Use Cases are created
Only code is written
Users test the software
UI design begins
What is the outcome of the design phase?
Full working software
Software design document (SDD)
Bug reports
Marketing strategy
What is created during the development phase?
Cloud configurations
User feedback reports
Working software modules
Installation guides
Why is testing important in SDLC?
To change the project plan
To save money only
To ensure the software functions properly
To build prototypes
What does unit testing involve?
Testing individual software components
Testing databases only
Updating user accounts
What is acceptance testing?
Developer code review
Alpha phase bug listing
Server setup verification
Final validation by end users
What is deployment in SDLC?
Writing the first draft of the plan
Creating documentation
Delivering the final product to users
Encrypting the software
What is the purpose of the maintenance phase?
Fix bugs and improve software after release
End the development process permanently
Remove the software from servers
Block user access
Which SDLC model is flexible and iterative?
Waterfall model
Agile model
Big Bang model
Monolithic model
What is a key feature of the Agile model?
Which of the following is an example of documenting UI elements?
Documenting UI colors
Writing backend code
Encrypting user data
Setting up servers
What defines the Waterfall model?
Ongoing feedback cycles
Cyclical revisiting of phases
Linear and sequential steps
Cloud-based only
What is the Iterative model best for?
Projects needing high flexibility
Projects without a deadline
Single-screen apps
One-time-only projects
What is the focus of the Spiral model?
Speed and low cost
Risk analysis and complex project handling
Building games
No planning required
What characterizes the Big Bang model?
Careful requirement planning
Minimal planning, coding starts immediately
Large team structures
Predefined customer contracts
Which document defines all the system's behaviors and architecture?
Software Design Document (SDD)
End-user license agreement
System BIOS manual
Marketing Brochure
What type of testing is done to assess speed and scalability?
Performance testing
Usability testing
Acceptance testing
Functional testing
What testing evaluates the UI and user interaction?
Unit testing
Usability testing
Load testing
Vulnerability testing
What is the purpose of a prototype?
Visualize and test design ideas before full coding
Replace production software
Encrypt project files
Test server hardware
What document tracks which requirements are implemented?
User manual
Requirement Traceability Matrix
Error log
What is a use case document used for?
List all possible errors
Define the UI layout
Identify required hardware
Describe how users will interact with the system
What is a benefit of disconnected data access in ADO?
Requires constant internet access
Slows down performance
Reduces load on the database and increases scalability
Deletes data automatically
Which feature allows developers to work with multiple data types in ADO?
Scripting module
Database linker
Flexibility in data handling
Visual Designer
What does transactional support in ADO provide?
Ability to perform atomic operations
Only read-only access
Code optimization
Server reset control
In what case is ADO especially helpful in analytics?
Why is ADO useful in fintech and healthtech?
Provides antivirus tools
Offers AI analysis
Allows flexible and secure access to data
Generates patient reports automatically
What does the SDLC provide for the product team?
Elimination of QA process
Systematic development with clear goals
Cloud hosting setup
Graphic user interface
What is the purpose of feature prioritization frameworks?
Help decide what features to build first
Increase database performance
Reduce software size
Convert diagrams to code
What document is produced during the requirements phase?
Software Requirements Specification (SRS)
Software Bill of Materials (SBOM)
Database map
Source control logs
What happens during system design?
Customer onboarding
App store upload
Visual and functional planning of the product
Legal compliance review
What is functional testing?
Tests the company’s network
Analyzes hardware limitations
Verifies software functions as intended
Measures download speed
What is security testing?
Confirms file naming is correct
Identifies vulnerabilities in the system
Compresses files
Generates UI colors
When is acceptance testing typically done?
During design
At the planning stage
Before final release to users
After retirement of product
What is the goal of the deployment phase?
Train employees
Run usability surveys
Release the software to the user base
In Agile, how long is an iteration typically?
1-2 days
4-5 weeks
1-3 weeks
3-6 months
Which model allows you to start coding without a defined plan?
Spiral model
Agile
Big Bang model
Waterfall
Why can the spiral model be expensive for small projects?
It requires cloud computing
It uses outdated technology
It focuses heavily on risk analysis
It excludes testing
What is one drawback of the iterative model?
It uses old programming languages
Repeated cycles can lead to scope creep
It doesn’t allow prototypes
It doesn’t use testing
What type of software might skip the SDLC and use the Big Bang model?
Which of the following is an example of a small experimental app?
Financial reporting systems
Small experimental apps
Government tax systems
What is the role of acceptance testing?
Test internal memory
Check server speeds
Validate if software meets end-user expectations
Delete unused code
What is one benefit of generating documentation from UML or ADO-based systems?
Automation reduces human error
Manual review is faster
It allows real-time video output
It replaces the design team
What is system testing?
Testing user interface only
Unit testing of code modules
Evaluating how components interact in a full application
Beta testing by end-users
When is system testing typically performed?
Before unit testing
After acceptance testing
After integration testing and before acceptance testing
During coding phase
What is the purpose of system testing?
Creating project budget
Ensuring the system works as a unified whole
Training developers
Fixing servers
Why is system testing important in interconnected systems?
It speeds up release dates
Defects can cause complications for users
It reduces development time
It simplifies UI design
What does a test case represent in system testing?
Programming logic
Final product release
Crucial requirement or user story
User manual
One benefit of system testing is:
Improved product quality
Increased file size
Faster marketing campaign
Longer project deadlines
How does system testing contribute to error reduction?
Catches bugs missed in earlier testing
Reduces developer workload
Why is system testing cost-effective?
It reduces advertising cost
It's free software
Fixing bugs early prevents delays and budget overruns
It bypasses QA teams
How does system testing improve security?
By encrypting all files
Identifies potential vulnerabilities
Updates antivirus software
Stores data on paper
What role does system testing play in customer satisfaction?
Speeds up delivery
Adds animations to UI
Increases confidence and user experience
Reduces login steps
How does system testing assist developers?
Provides client feedback
Replaces code editors
Adds social media features
Makes code modification easier during development
What is checked in performance testing during system testing?
Functionality
Response time and resource usage
User interface design
Security vulnerabilities
What is functional system testing?
Ensures system meets functional requirements
Measures battery life
Applies style sheets
Creates backups
What is one phase of system testing?
Test environment setup
Product advertisement
Price negotiation
Web traffic tracking
What is the purpose of the test case stage?
Review test reports
Hire new QA members
Generate specific cases to evaluate
Analyze financial return
What happens during the test data phase?
System is deployed
Tests are deleted
UI is finalized
Data for the tests is created
What is test case execution?
Running predefined tests
Deleting defects
Reporting code coverage
Restarting the server
What happens in the defect reporting stage?
Errors are identified and logged
Hardware is updated
Legal issues are discussed
Customer contracts are signed
What is the goal of regression testing?
Review marketing results
Remove customer data
Check if new changes introduced new issues
Add more features
What is the retest stage for?
File exporting
Repeating a failed test
Code cleanup
Hardware installation
What are commercial system testing tools?
Free text editors
Paid tools like Squish and SpiraTest
Which is an open-source system testing tool?
Chrome
Visual Studio
Notepad++
Robotium
What can system testing tools do?
Manage and automate test cases
Build websites
Manage salaries
Edit videos
What else might system testing tools offer?
Photo editing
Game development
Requirements management
Data mining
What is one limitation for small organizations in testing?
Not enough customers
Limited access to expensive automated tools
Too many developers
Overuse of AI
Defect logging involves:
Recording and tracking defects found during testing.
Writing code for new features.
Designing user interfaces.
Deploying software to production.
Which of the following is a key activity after system testing?
Sending reports to HR
Recording found errors for future fixing
Deleting backups
Updating documentation
What is a major outcome of system testing?
Shorter login processes
Stable, user-ready software
Free mobile apps
Enhanced logo design
What follows successful system testing?
Acceptance testing
Unit testing
Planning phase
Code refactoring
What is the role of QA in system testing?
Ensure the application meets its requirements
Design product marketing
Develop mobile apps
Train sales staff
Who proposed the concept of the relational data model?
Edgar Codd
Bill Gates
Tim Berners-Lee
Charles Babbage
What structure is used in the relational model to represent data?
Tables
Trees
Graphs
Lists
In relational databases, what are table rows called?
Records (Tuples)
Attributes
Domains
Keys
What are table columns called in relational databases?
Records
Fields (Attributes)
Domains
Schemas
What does a field represent in a relational table?
A column with values of the same type
A single row
A table connection
A unique ID
What is the intersection of a row and a column called?
Schema
Domain
What is a domain in relational algebra?
A group of tables
A key relationship
Set of all possible values for an attribute
A file system
What is a tuple in a relational model?
A table name
A row in a table
A column title
A database language
What determines the degree of a relation?
Number of attributes
Number of rows
Number of keys
Number of schemas
What determines the cardinality of a relation?
Number of attributes
Number of tuples
Number of users
Number of constraints
What is a primary key?
A unique identifier for a record in a database table
A type of foreign key
A duplicate value in a table
A column that allows null values
What happens if a primary key is not unique?
Database creates backup
An error message is shown
Key is renamed
Column is deleted
What is a foreign key?
A field linking one table to another
A deleted row
A null value
A duplicate primary key
