Font size
WorksheetsDBMS and IS Development Quiz
Total questions: 60
Worksheet time: 33mins
What is a major benefit of using a database over a traditional file system?
Increased data redundancy
Faster manual retrieval
Reduced data inconsistency
Simpler storage hardware
Which component of DBMS is used to create data structures and define relationships?
Data Manipulation
Data Definition
Application Generation
Inference Engine
Which type of database allows multiple users to access data from different physical locations?
Flat-file database
Relational database
Distributed database
Hierarchical database
Which language is commonly used to interact with relational databases?
HTML
SQL
XML
CSS
Which is the correct order in the data hierarchy from smallest to largest?
Record, Field, File, Database
Character, Field, Record, File
File, Record, Field, Database
Field, Record, File, Database
In SDLC, which phase involves determining user requirements?
Design
Analysis
Implementation
Maintenance
What does CRUD stand for in the context of database operations?
Create, Read, Update, Delete
Connect, Run, Update, Debug
Compute, Retrieve, Upload, Deliver
Check, Render, Use, Dump
Which of the following is an advantage of Rapid Application Development (RAD)?
Minimal user involvement
Focuses only on coding
Longer development cycle
Quick feedback and prototyping
Which SDLC phase includes testing system components?
Design
Implementation
Analysis
Planning
Which methodology delivers software in small, incremental builds?
Waterfall
Agile
RAD
SOA
Which database model stores data in rows and columns with relationships between tables?
Hierarchical
Relational
Network
Object-oriented
What does the acronym DBMS stand for?
Data Binary Management System
Direct Business Module System
Database Management System
Data Backup and Monitoring System
Which of the following best describes a data dictionary?
A file that stores code
A list of data types and values
A repository of metadata
A directory of users
In DBMS, what is the function of the database engine?
Network communication
Backup and recovery
Data storage, manipulation, and retrieval
User authentication
What is a primary key?
A password-protected file
A unique identifier for a record
A foreign language interface
A SQL command
Which of the following is NOT an SDLC methodology?
Agile
Waterfall
Spiral
Encryptor
Which component allows users to extract information from a database?
Operating System
Data Query Language
Metadata table
Data Dump Tool
Which type of system design is done before physical implementation?
Logical design
Structural design
Physical design
Reactive design
In DBMS, what is normalization used for?
Creating backup copies
Encrypting passwords
Reducing data redundancy
Increasing file size
What does the “entity” represent in a database model?
User login info
A distinct object or concept
A type of algorithm
An external system
A system that helps in decision-making by analyzing business data is called:
DBMS
MIS
OIS
AI
What is the output of the SDLC design phase?
Final software
Requirements document
System specifications
Project invoice
Which of the following is a role of system analysts?
Building hardware
Managing customer service
Evaluating and designing information systems
Updating antivirus software
The process of transforming user needs into detailed system specifications is called:
Planning
Coding
System Analysis
Installation
Which model assumes each step must be completed before the next begins?
Agile
Spiral
Waterfall
Prototype
A ________ is a detailed, structured set of instructions to build a system.
Software license
Design document
Source code
Program debugger
Which tool is often used to visually represent entities and relationships?
Flowchart
ER Diagram
Pie chart
Dashboard
Which development method is best when requirements are not well-understood?
Waterfall
V-Model
Prototyping
Batch processing
Which type of testing checks whether each module functions correctly?
Alpha testing
Unit testing
Beta testing
Regression testing
What is the main goal of the implementation phase in SDLC?
Writing contracts
Installing hardware
Deploying the system
Creating flowcharts
Which feature of a DBMS helps enforce data integrity?
SQL
Firewall
Constraints
Debuggers
What is a foreign key used for?
Encrypting a table
Creating network access
Linking related tables
Backing up records
In which SDLC phase is software maintained and upgraded?
Analysis
Testing
Maintenance
Design
What kind of database model supports object encapsulation?
Relational
Object-oriented
Hierarchical
Network
Which component of DBMS ensures that only authorized users can access the system?
Metadata
Data dictionary
Security subsystem
Query processor
What is the final stage in the waterfall model?
Testing
Maintenance
Implementation
Evaluation
Which tool is used for generating user interfaces in DBMS?
Database Engine
Application Generator
Form Builder
Query Optimizer
Which type of database would best suit multimedia data like images or audio?
Object-oriented database
Relational database
Flat file system
Hierarchical database
What is the purpose of a backup in a database system?
To increase redundancy
To reduce performance
To restore data in case of loss
To optimize queries
Which IS development method emphasizes frequent delivery of working software?
Waterfall
Agile
Spiral
Traditional
A (a) is a collection of logically related data stored together for efficient retrieval and management.
In databases, a (a) key uniquely identifies each record in a table.
The DBMS component responsible for storing, retrieving, and updating data is called the (a) .
A (a) key is used to create a link between two related tables.
(a) is the process of organizing data to reduce redundancy and improve integrity.
SQL stands for ________.
A (a) is a single unit of data, such as a name or number.
(a) diagrams are used to model relationships between entities in a database.
In DBMS, a (a) contains information about the structure of the database, such as table names and field types.
(a) refers to data that is consistent, complete, and correct.
The (a) phase in SDLC focuses on understanding what the system should do.
The (a) model is a sequential approach where each phase must be completed before the next begins.
(a) is a development approach that emphasizes flexibility, customer collaboration, and rapid delivery.
A working system that demonstrates key features before full development is called a (a) .
In SDLC, (a) testing checks whether each individual module functions as intended.
During the (a) phase, developers build and code the actual system components.
The SDLC phase where user feedback is collected and updates are applied is called (a) .
(a) requirements describe what the system should do from a user's perspective.
A database that supports storing objects, including methods and attributes, is called an (a) database.
A (a) driven website interacts with a backend database to display dynamic content.
