Q1medium
Which of the following best describes the difference between a Database Schema and a Database Instance?
Back to Database Management Systems
10 Questions Total
Introduction to Database Systems MCQs
Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.
Zero-leak answer engine • Rate-limited explanations
Practice in Timed ModeQ2medium
Two travel agents attempt to book the last remaining seat on a flight at the exact same millisecond. In a traditional file system, both might succeed, causing an overbooking. What inherent feature of a DBMS prevents this?
Q3hard
A database administrator executes the following SQL query to inspect the database. What specific DBMS component is being accessed here?
Q4medium
In traditional file systems, if you change the length of a 'ZipCode' field from 5 to 9 characters in the storage file, you must also rewrite the application code reading that file. A DBMS eliminates this requirement. This characteristic is known as:
Q5medium
While a DBMS offers many advantages, there are scenarios where utilizing a DBMS is considered unnecessary or harmful. Which of the following is a valid reason to avoid using a full-scale DBMS?
Q6medium
An e-commerce system uses a DBMS to ensure that if a server crashes during a checkout process (after deducting inventory but before charging the credit card), the inventory deduction is undone. This capability falls under:
Q7easy
Which of the following is NOT a fundamental property of a Database Management System?
Q8easy
What is the primary difference between a "Data Definition Language (DDL)" and a "Data Manipulation Language (DML)"?
Q9hard
A bank's IT department is separating roles. Employee A manages the physical disk storage and backup strategies. Employee B designs the logical tables and ER diagrams. Employee C writes web applications that query the database. Who represents the Database Administrator (DBA)?
Q10hard
A university registrar uses a traditional File Processing System. Student addresses are stored in both a Billing.dat file and a Library.dat file. When a student moves, the address is only updated in the Billing.dat file. What specific database problem does this illustrate?