NEW
Font size
WorksheetsFUNDAMENTALS OF DATABASE Preliminary Examination
Total questions: 40
Worksheet time: 1hrs 20mins
What is a database?
A printed record of data
An organized collection of structured data
A random list of files
A software application
Data in a database is stored in:
Folders
Tables
Drawers
Networks
Rows in a table are also called:
Fields
Columns
Records
Attributes
Which command belongs to DDL?
INSERT
SELECT
CREATE
UPDATE
Which DBMS component retrieves data?
DDL
DCL
DQL
DML
INSERT, UPDATE, and DELETE are commands under:
A. DML
DDL
DCL
ERD
A DBMS is:
Hardware for storage
Software that manages databases
A file manager
A printer application
What does data integrity ensure?
Duplicate entries
Accuracy and consistency
Randomization of data
Unlimited storage
Which characteristic allows multiple users to access data at the same time?
Security
Scalability
Concurrency control
Flexibility
Which database architecture uses a front-end client and a back-end server?
Tiered
Distributed
Client-server
Offline
Which is an example of a distributed database?
Local spreadsheet
Google Cloud Spanner
Paper archives
File cabinet
Which DBMS is an example of relational software?
Notepad
MySQL
Photoshop
Excel only
What does DCL manage?
Security and permissions
Data querying
Table creation
Data updates
Which command is used for querying data?
SELECT
DROP
TRUNCATE
REVOKE
Scalability in databases means:
Making data smaller
Ability to handle increasing data
Constant data size
Reducing users
Which design stage focuses on entities, attributes, and relationships?
Physical design
Logical design
Implementation
Testing
In an ERD, Student and Teacher are examples of:
Attributes
Entities
Keys
Values
The purpose of requirement gathering is to identify:
Interests of users
What data is needed and how it will be used
Colors of the database interface
Hardware specifications
The command GRANT belongs to:
DML
DCL
DQL
DBLC
The DBLC is a:
Design tool
Structured process for database creation
Programming language
Backup software
A school wants to avoid duplicate student IDs. Which database characteristic helps this?
Scalability
Concurrency
Data integrity
Security
A banking system needs to allow thousands of transactions at once. What is required?
DDL
Concurrency control
Physical design
ERD
A company wants faster decision-making from real-time data. Which component handles retrieval?
DML
DCL
DQL
DDL
A developer is designing tables, attributes, and keys. Which design stage is this?
Physical
Logical
To improve performance, an admin adds indexes. This activity belongs to:
Logical design
Requirement analysis
Physical design
Data dictionary
Creating tables, applying constraints, and populating data occur in which DBLC stage?
Implementation
Planning
Maintenance
Logical design
A web app where users interact via browser while the database is stored on a server uses:
Spreadsheet architecture
Client-server
Tiered
Distributed
Interviewing staff and observing workflows are part of:
System definition
Requirement collection and analysis
Maintenance
Physical design
A 3-tier architecture separates presentation, logic, and data to improve:
Security only
Scalability and manageability
Storage reduction
Color theme
A developer uses ERD to model Student–Course relationships. This occurs in:
Requirement gathering
Logical design
Physical design
Populating data
A hospital wants to redesign its database to support future growth and stricter security. Which combined approach is best?
Logical redesign only
Combine logical + physical redesign for scalability and security
Add more computers
Delete old tables
An e-commerce platform wants to ensure high availability across regions. Which architecture fits best?
2-tier
Distributed database
Client-server
Local storage
A system must integrate DBLC and SDLC. Which statement is most accurate?
SDLC is part of DBLC
DBLC is a subset of SDLC
Both are unrelated
DBLC replaces SDLC
A company must visualize all data entities, relationships, and constraints before building the database. Which tool is ideal?
Flowchart
ER diagram
Spreadsheet
Command prompt
A university needs a database that handles multiple concurrent registrations without conflicts. What must be prioritized?
Data duplication
Concurrency control mechanisms
Manual scheduling
File-based storage
To design an optimized physical model, a designer must:
Ignore performance
Translate logical design into storage structures
Avoid indexing
Remove keys
A company wants to upgrade to a cloud-based database that remains operational even if a server fails. Which architecture is suitable?
Distributed
Single-tier
Local file system
Paper-based
A developer must ensure the database supports business processes and avoids invalid relationships. What document helps most?
Marketing plan
Data dictionary + business rules
Brochure
PowerPoint slides
A school is designing its Student Information System. Which pair exemplifies logical vs. physical design?
Table creation vs. ER diagram
ER diagram vs. table creation with data types
Backups vs. updates
Records vs. queries
A company wants to automate data population after design. Which SQL approach is required?
GRANT statements
INSERT commands
CREATE commands
REVOKE commands
