Database Management MCQs (Set-1)

Difficulty: Easy & Basic

Which software manages organized collections of related records?

A Database management system
B Spreadsheet theme
C Network protocol
D Report template

In a relational database, what does each row represent?

A A query
B A record
C A constraint
D A schema

When a table needs a unique row identifier, which key is used?

A Display key
B Foreign key
C Primary key
D Sort key

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

Where are relational records commonly organized?

A Tables
B Network zones
C Presentation slides
D Folders

Which language retrieves data from relational tables?

A CSS
B SQL
C HTML
D SMTP

To filter matching orders only, which clause applies?

A ORDER BY clause
B FROM clause
C WHERE clause
D CREATE clause

Before tables are built, what design description defines their structure?

A User password
B Backup schedule
C Audit report
D Database schema

Repeated customer details create which design problem?

A Data redundancy
B Access control
C Referential integrity
D Query parsing

Why enforce database constraints?

A Increase duplicate values
B Protect data integrity
C Remove key relationships
D Delay every query

Which resource describes tables, fields, and meanings?

A User interface
B Backup image
C Data dictionary
D Transaction log

Who commonly manages database access and performance?

A Process analyst
B Sales representative
C External customer
D Database administrator

To add a new customer row, which SQL command is used?

A INSERT
B SELECT
C UPDATE
D DROP

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

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

Which design method reduces unnecessary repeated facts?

A Replication
B Sorting
C Indexing
D Normalization

After accidental data loss, what can support restoration?

A Verified backup
B Query alias
C Access token
D Screen theme

Which transaction property makes all steps succeed or none?

A Scalability
B Atomicity
C Availability
D Portability

How can a DBMS restrict access to sensitive tables?

A Sorting rules
B Table aliases
C Access controls
D Read replicas

What keeps entered values within approved limits?

A Network routes
B Backup labels
C Presentation themes
D Validation constraints

Which model organizes data into relations?

A Relational model
B Document theme
C Hierarchical chart
D Event model

To show newest records first, which clause controls sorting?

A GROUP BY
B ORDER BY
C WHERE
D HAVING

Which database object presents stored query results as a table?

A Index
B Sequence
C View
D Trigger

During simultaneous updates, what coordinates conflicting changes?

A File compression
B Data dictionary
C Schema naming
D Concurrency control

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