Database Management Systems (DBMS)
Practice Database Management Systems (DBMS) MCQs for Pakistan exams (CSS, FPSC, PPSC, NTS) — 100 practice questions with answers and explanations.
How to use these questions
Database Management Systems (DBMS) on MCQsHub is 50 published questions for Pakistan exams such as CSS, FPSC, PPSC, and NTS. Open a question, choose an option, then read the explanation before you move on. The explanation names the correct choice and why the other options do not fit. Difficulty labels and topic tags show which idea to revise next, instead of repeating questions you already know.
Previous and next links on each question page stay inside Database Management Systems (DBMS), so you can work through the subject without returning to this index. Subtopics listed here belong to the same subject and narrow the set. When you want a clock and a score, start a timed quiz for Database Management Systems (DBMS). When you want a whole sitting rather than one question, open the past-paper library. New Database Management Systems (DBMS) questions appear here after editorial review.
The list below starts with the newest Database Management Systems (DBMS) questions. Later pages keep the same subject. Each title is a link to the full stem, the options, and the explanation.
1 2 3 Next All questions Full list of questions in this category for browsing.
The concept in which a subset of SQL commands used to define and modify database structures, such as CREATE an... Identify the correct definition of Data Definition Language (DDL). What term describes the following? a subset of SQL commands used to manage data within tables, such as INSERT,... In computer science, Data Manipulation Language (DML) refers to which of the following? Select the correct name for: a subset of SQL primarily represented by the SELECT statement, used to retrieve d... Which statement correctly explains Data Query Language (DQL)? Which concept is defined as follows: a precompiled collection of SQL statements stored in a database that can... What is Stored procedure primarily used for? The following statement describes a specific concept. What is it called? a key formed by combining two or more... Select the accurate description of Composite key. Which term refers to a database property ensuring that relationships between tables remain consistent, typical... What does Referential integrity refer to? What is the name for a set of techniques used in a DBMS to ensure correct results for concurrent transaction o... Which of the following best describes Concurrency control? Identify the correct concept described as: a large, centralized repository of integrated data from multiple so... Data warehouse is best defined as which of the following? A type of database that organizes data into tables of rows and columns linked by defined relationships. What i... Choose the correct description of Relational database. Which of the following best names the concept in which a type of database designed for storing and retrieving... What is the function or purpose of NoSQL database? The concept in which the overall logical structure that defines how data is organized within a database is bes... Identify the correct definition of Database schema. What term describes the following? a DBMS component that determines the most efficient way to execute a given... In computer science, Query optimizer refers to which of the following? Select the correct name for: a normalization level in which a table is in second normal form and has no transi... The following statement describes a specific concept. What is it called? a stored procedure that automatically... Select the accurate description of Database trigger. Which term refers to a virtual table based on the result of a stored SQL query? What does Database view refer to? What is the name for a situation in which two transactions are each waiting for the other to release a lock, p... Which of the following best describes Transaction deadlock? Identify the correct concept described as: a minimal set of attributes that can uniquely identify a record in... Which term refers to a column or set of columns that uniquely identifies each row in a database table? What does Primary key refer to? What is the name for a column that creates a link between data in two tables by referencing a primary key in a... Which of the following best describes Foreign key? Identify the correct concept described as: the process of organizing database tables to reduce data redundancy... Normalization is best defined as which of the following? A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transacti... Choose the correct description of ACID properties. Which of the following best names the concept in which an SQL operation that combines rows from two or more ta... What is the function or purpose of SQL JOIN? The concept in which a database structure that improves the speed of data retrieval operations on a table is b... Identify the correct definition of Database index. What term describes the following? a sequence of one or more database operations executed as a single logical... In computer science, Transaction refers to which of the following? Select the correct name for: a diagram that visually represents entities and their relationships within a data... Which statement correctly explains Entity-Relationship (ER) diagram? Which concept is defined as follows: the process of intentionally introducing redundancy into a database to im... What is Denormalization primarily used for?