CSS MPT 2027 Complete Preparation Pack 12 Premium PDFs • 8 Live Mock Exams Explore Pack
CSS - PMS - CCE - PCS - Basic Computing Practice

Database Basics – DBMS, Tables, Keys, SQL & Database Concepts MCQs

Learn Database Basics for CSS, PMS, CCE, PCS and other competitive exams. Cover DBMS concepts, databases, tables, records, fields, primary and foreign keys, relational databases, SQL, queries, normalization, data types, database models, advantages of DBMS and important exam-focused MCQs for quick preparation and revision.

Start Free Practice Try Daily MCQs International Exams
Which option best explains your concept?
Instant answer validation
Performance tracking
Timed mock tests
Daily Practice +10 XP

Step-by-Step

Detailed Explanations

54,554

Practice MCQs

27

Mock Tests

95%

Success Focus

Continue Studying

More Basic Computing MCQ Topics

Explore more topic-wise practice from the same subject.

All Basic Computing MCQs
Operating Systems MCQs with Answers & Key Concepts MCQsOpen topicNetworking Basics MCQsOpen topicCyber Security Basics MCQsOpen topicInternet Basics MCQsOpen topicEmail Basics MCQsOpen topicComputer Fundamentals MCQsOpen topic
Database Basics – DBMS, Tables, Keys, SQL & Database Concepts

Database Basics – DBMS, Tables, Keys, SQL & Database Concepts MCQs With Answers

Only MCQs mapped to Database Basics – DBMS, Tables, Keys, SQL & Database Concepts are shown on this page. You are viewing page 2.

Find Your Question Instantly

Search by keyword, subject, topic, or exact MCQ text.

CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: is a concurrency-control mechanism that restricts conflicting access to data?
A. Isolation
B. Superkey
C. Lock
D. Third Normal Form
Read Theory
Correct Answer: C
Lock is a concurrency-control mechanism that restricts conflicting access to data.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: occurs when transactions wait on one another's locked resources in a cycle?
A. Deadlock
B. Denormalization
C. UNIQUE constraint
D. View
Read Theory
Correct Answer: A
Deadlock occurs when transactions wait on one another's locked resources in a cycle.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: occurs when repeating a range query returns a different set of rows because another transaction inserted or deleted matching rows?
A. Composite key
B. Phantom read
C. One-to-many relationship
D. ALTER
Read Theory
Correct Answer: B
Phantom read occurs when repeating a range query returns a different set of rows because another transaction inserted or deleted matching rows.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: occurs when the same row is read twice and returns different committed values due to another transaction's update?
A. Superkey
B. Nonrepeatable read
C. HAVING
D. Full backup
Read Theory
Correct Answer: B
Nonrepeatable read occurs when the same row is read twice and returns different committed values due to another transaction's update.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: occurs when a transaction reads data written by another transaction that has not committed?
A. Dirty read
B. Replication
C. Hierarchical model
D. ER diagram
Read Theory
Correct Answer: A
Dirty read occurs when a transaction reads data written by another transaction that has not committed.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: provides row-by-row processing of a result set or query output?
A. UPDATE
B. Deletion anomaly
C. First Normal Form
D. Cursor
Read Theory
Correct Answer: D
Cursor provides row-by-row processing of a result set or query output.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: executes automatically in response to specified database events?
A. Surrogate key
B. Foreign key
C. Trigger
D. Cursor
Read Theory
Correct Answer: C
Trigger executes automatically in response to specified database events.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: is a named program unit stored in the database and executed on request?
A. Stored procedure
B. Nonclustered index
C. CHECK constraint
D. Optimistic concurrency control
Read Theory
Correct Answer: A
Stored procedure is a named program unit stored in the database and executed on request.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: stores the result of a query physically and refreshes it according to DBMS rules?
A. Materialized view
B. Atomicity
C. Deletion anomaly
D. Relational model
Read Theory
Correct Answer: A
Materialized view stores the result of a query physically and refreshes it according to DBMS rules.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: is a named query that presents a virtual table-like result?
A. Deletion anomaly
B. DEFAULT constraint
C. View
D. IS NULL
Read Theory
Correct Answer: C
View is a named query that presents a virtual table-like result.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: describes operations selected to execute a query?
A. Execution plan
B. RIGHT OUTER JOIN
C. Pessimistic concurrency control
D. DISTINCT
Read Theory
Correct Answer: A
Execution plan describes operations selected to execute a query.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: chooses an execution strategy for a SQL query?
A. GROUP BY
B. Query optimizer
C. Network model
D. Incremental backup
Read Theory
Correct Answer: B
Query optimizer chooses an execution strategy for a SQL query.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: stores index keys separately from table data with references to rows?
A. Nonclustered index
B. Self join
C. DELETE
D. CROSS JOIN
Read Theory
Correct Answer: A
Nonclustered index stores index keys separately from table data with references to rows.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: determines or closely influences physical row order in DBMSs that implement clustered storage?
A. Clustered index
B. Cursor
C. Isolation
D. REVOKE
Read Theory
Correct Answer: A
Clustered index determines or closely influences physical row order in DBMSs that implement clustered storage.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: joins a table to another reference of itself?
A. Index
B. REVOKE
C. Self join
D. Deadlock
Read Theory
Correct Answer: C
Self join joins a table to another reference of itself.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: returns matched rows and unmatched rows from both sides?
A. Transaction log
B. Full backup
C. First Normal Form
D. FULL OUTER JOIN
Read Theory
Correct Answer: D
FULL OUTER JOIN returns matched rows and unmatched rows from both sides.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: returns all right-side rows plus matching left-side rows?
A. RIGHT OUTER JOIN
B. DEFAULT constraint
C. CREATE
D. Deadlock
Read Theory
Correct Answer: A
RIGHT OUTER JOIN returns all right-side rows plus matching left-side rows.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: returns all left-side rows plus matching right-side rows?
A. Read replica
B. NOT NULL constraint
C. LEFT OUTER JOIN
D. Stored procedure
Read Theory
Correct Answer: C
LEFT OUTER JOIN returns all left-side rows plus matching right-side rows.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: returns rows that satisfy the join condition on both sides?
A. Foreign key
B. GRANT
C. INNER JOIN
D. Self join
Read Theory
Correct Answer: C
INNER JOIN returns rows that satisfy the join condition on both sides.
CSS - PMS - CCE - PCS - Basic Computing Database Basics
Which database term best fits this description: tests specifically for SQL NULL values?
A. BETWEEN
B. IS NULL
C. REVOKE
D. Cursor
Read Theory
Correct Answer: B
IS NULL tests specifically for SQL NULL values.
Load More MCQs
Why Students Like It

Built For Focused Exam Preparation

A clean learning system that keeps students practicing, improving, and coming back.

Instant Feedback

Students immediately know the correct answer and learn from explanations.

Real Exam Practice

Timed mock tests help users prepare for real exam pressure.

Weak Area Tracking

Performance insights help students focus on the topics that need attention.

Student Feedback

What Learners Say

Start Your Success Journey Today

Create your free account and begin practicing with confidence.

Create Free Account