Difficulty: Easy & Basic
Which software manages organized collections of related records?
A Database management system
B Spreadsheet theme
C Network protocol
D Report template
Answer: A. Database management system. A DBMS defines, stores, retrieves, and manages database data.
In a relational database, what does each row represent?
A A query
B A record
C A constraint
D A schema
Answer: B. A record. A table row represents one record or tuple.
When a table needs a unique row identifier, which key is used?
A Display key
B Foreign key
C Primary key
D Sort key
Answer: C. Primary key. A primary key uniquely identifies each row in its table.
How does a foreign key connect related tables?
A Sorts every table row
B Stores a report title
C Encrypts the database file
D References another table key
Answer: D. References another table key. A foreign key refers to a key in another table.
Where are relational records commonly organized?
A Tables
B Network zones
C Presentation slides
D Folders
Answer: A. Tables. The relational model organizes records in tables of rows and columns.
Which language retrieves data from relational tables?
A CSS
B SQL
C HTML
D SMTP
Answer: B. SQL. SQL is commonly used to define and query relational data.
To filter matching orders only, which clause applies?
A ORDER BY clause
B FROM clause
C WHERE clause
D CREATE clause
Answer: C. WHERE clause. WHERE filters rows using a specified condition.
Before tables are built, what design description defines their structure?
A User password
B Backup schedule
C Audit report
D Database schema
Answer: D. Database schema. A schema describes database objects, fields, and relationships.
Repeated customer details create which design problem?
A Data redundancy
B Access control
C Referential integrity
D Query parsing
Answer: A. Data redundancy. Redundant copies can waste storage and create inconsistent updates.
Why enforce database constraints?
A Increase duplicate values
B Protect data integrity
C Remove key relationships
D Delay every query
Answer: B. Protect data integrity. Constraints reject data that violates defined rules.
Which resource describes tables, fields, and meanings?
A User interface
B Backup image
C Data dictionary
D Transaction log
Answer: C. Data dictionary. A data dictionary documents database objects and their definitions.
Who commonly manages database access and performance?
A Process analyst
B Sales representative
C External customer
D Database administrator
Answer: D. Database administrator. Database administrators oversee database availability, security, and performance.
To add a new customer row, which SQL command is used?
A INSERT
B SELECT
C UPDATE
D DROP
Answer: A. INSERT. INSERT adds new rows to a table.
What can a NULL value represent?
A A zero value always
B Missing or unknown data
C A deleted table
D An empty string always
Answer: B. Missing or unknown data. NULL commonly represents unavailable, unknown, or inapplicable data.
One customer may place many orders. Which relationship fits?
A No relationship
B One-to-one
C One-to-many
D Many-to-many only
Answer: C. One-to-many. A one-to-many relationship links one customer to multiple orders.
Which design method reduces unnecessary repeated facts?
A Replication
B Sorting
C Indexing
D Normalization
Answer: D. Normalization. Normalization organizes data to reduce avoidable redundancy and anomalies.
After accidental data loss, what can support restoration?
A Verified backup
B Query alias
C Access token
D Screen theme
Answer: A. Verified backup. A verified backup provides a recoverable copy of database data.
Which transaction property makes all steps succeed or none?
A Scalability
B Atomicity
C Availability
D Portability
Answer: B. Atomicity. Atomicity treats a transaction as an all-or-nothing unit.
How can a DBMS restrict access to sensitive tables?
A Sorting rules
B Table aliases
C Access controls
D Read replicas
Answer: C. Access controls. Access controls limit database actions to authorized users.
What keeps entered values within approved limits?
A Network routes
B Backup labels
C Presentation themes
D Validation constraints
Answer: D. Validation constraints. Constraints can validate data types, ranges, and required values.
Which model organizes data into relations?
A Relational model
B Document theme
C Hierarchical chart
D Event model
Answer: A. Relational model. The relational model represents data as related tables.
To show newest records first, which clause controls sorting?
A GROUP BY
B ORDER BY
C WHERE
D HAVING
Answer: B. ORDER BY. ORDER BY arranges query results using selected columns.
Which database object presents stored query results as a table?
A Index
B Sequence
C View
D Trigger
Answer: C. View. A view presents the results of a stored query as a virtual table.
During simultaneous updates, what coordinates conflicting changes?
A File compression
B Data dictionary
C Schema naming
D Concurrency control
Answer: D. Concurrency control. Concurrency control manages simultaneous database operations safely.
When no single column uniquely identifies a row, what key may combine fields?
A Composite key
B Foreign key
C Display key
D Lookup label
Answer: A. Composite key. A composite key uses two or more columns to identify a row.