{"id":5196,"date":"2026-02-27T08:55:16","date_gmt":"2026-02-27T08:55:16","guid":{"rendered":"https:\/\/murreeroad.org\/?p=5196"},"modified":"2026-02-27T08:55:16","modified_gmt":"2026-02-27T08:55:16","slug":"100-database-management-mcqs-with-answers","status":"publish","type":"post","link":"https:\/\/learn-nest.murreeroad.org\/blog\/100-database-management-mcqs-with-answers\/","title":{"rendered":"100 Database Management MCQs with Answers"},"content":{"rendered":"<p>100 Database Management MCQs with Answers (DBMS Multiple Choice Questions for Exams &amp; Interviews). Prepare for exams and interviews with these 100 Database Management MCQs with answers. This comprehensive DBMS question set covers SQL, normalization, keys, ER diagrams, transactions, ACID properties, joins, indexing, and more \u2014 perfect for computer science students, IT exams, and competitive test preparation.<\/p>\n<p>Database Management Systems (DBMS) are a fundamental part of computer science and information technology, playing a crucial role in storing, organizing, and managing data efficiently. Whether you are preparing for university exams, competitive tests, IT certifications, or technical interviews, a strong understanding of database concepts is essential. This collection of <strong data-start=\"414\" data-end=\"459\">100 Database Management MCQs with answers<\/strong> covers key topics such as SQL commands, normalization, primary and foreign keys, ER diagrams, joins, transactions, ACID properties, indexing, and data modeling. These carefully designed multiple choice questions will help students strengthen their core concepts, improve problem-solving skills, and confidently prepare for DBMS exams and professional assessments.<\/p>\n<h1 data-start=\"181\" data-end=\"243\">Database Management Systems (DBMS) \u2013 100 MCQs with Answers<\/h1>\n<hr data-start=\"245\" data-end=\"248\" \/>\n<h3 data-start=\"250\" data-end=\"282\">1. What does DBMS stand for?<\/h3>\n<p data-start=\"283\" data-end=\"436\">A) Data Backup Management System<br data-start=\"315\" data-end=\"318\" \/>B) Database Management System<br data-start=\"347\" data-end=\"350\" \/>C) Digital Base Management System<br data-start=\"383\" data-end=\"386\" \/>D) Data Building Management System<br data-start=\"420\" data-end=\"423\" \/><strong data-start=\"423\" data-end=\"436\">Answer: B<\/strong><\/p>\n<hr data-start=\"438\" data-end=\"441\" \/>\n<h3 data-start=\"443\" data-end=\"464\">2. A database is:<\/h3>\n<p data-start=\"465\" data-end=\"576\">A) Collection of programs<br data-start=\"490\" data-end=\"493\" \/>B) Organized collection of data<br data-start=\"524\" data-end=\"527\" \/>C) Operating system<br data-start=\"546\" data-end=\"549\" \/>D) Compiler<br data-start=\"560\" data-end=\"563\" \/><strong data-start=\"563\" data-end=\"576\">Answer: B<\/strong><\/p>\n<hr data-start=\"578\" data-end=\"581\" \/>\n<h3 data-start=\"583\" data-end=\"623\">3. Which of the following is a DBMS?<\/h3>\n<p data-start=\"624\" data-end=\"685\">A) MySQL<br data-start=\"632\" data-end=\"635\" \/>B) Windows<br data-start=\"645\" data-end=\"648\" \/>C) Linux<br data-start=\"656\" data-end=\"659\" \/>D) MS Word<br data-start=\"669\" data-end=\"672\" \/><strong data-start=\"672\" data-end=\"685\">Answer: A<\/strong><\/p>\n<hr data-start=\"687\" data-end=\"690\" \/>\n<h3 data-start=\"692\" data-end=\"736\">4. Which model organizes data in tables?<\/h3>\n<p data-start=\"737\" data-end=\"833\">A) Hierarchical model<br data-start=\"758\" data-end=\"761\" \/>B) Network model<br data-start=\"777\" data-end=\"780\" \/>C) Relational model<br data-start=\"799\" data-end=\"802\" \/>D) Object model<br data-start=\"817\" data-end=\"820\" \/><strong data-start=\"820\" data-end=\"833\">Answer: C<\/strong><\/p>\n<hr data-start=\"835\" data-end=\"838\" \/>\n<h3 data-start=\"840\" data-end=\"862\">5. SQL stands for:<\/h3>\n<p data-start=\"863\" data-end=\"997\">A) Structured Query Language<br data-start=\"891\" data-end=\"894\" \/>B) Simple Query Language<br data-start=\"918\" data-end=\"921\" \/>C) Sequential Query Language<br data-start=\"949\" data-end=\"952\" \/>D) Standard Question Language<br data-start=\"981\" data-end=\"984\" \/><strong data-start=\"984\" data-end=\"997\">Answer: A<\/strong><\/p>\n<hr data-start=\"999\" data-end=\"1002\" \/>\n<h3 data-start=\"1004\" data-end=\"1050\">6. Which command is used to retrieve data?<\/h3>\n<p data-start=\"1051\" data-end=\"1112\">A) INSERT<br data-start=\"1060\" data-end=\"1063\" \/>B) UPDATE<br data-start=\"1072\" data-end=\"1075\" \/>C) SELECT<br data-start=\"1084\" data-end=\"1087\" \/>D) DELETE<br data-start=\"1096\" data-end=\"1099\" \/><strong data-start=\"1099\" data-end=\"1112\">Answer: C<\/strong><\/p>\n<hr data-start=\"1114\" data-end=\"1117\" \/>\n<h3 data-start=\"1119\" data-end=\"1165\">7. Which key uniquely identifies a record?<\/h3>\n<p data-start=\"1166\" data-end=\"1251\">A) Foreign key<br data-start=\"1180\" data-end=\"1183\" \/>B) Primary key<br data-start=\"1197\" data-end=\"1200\" \/>C) Candidate key<br data-start=\"1216\" data-end=\"1219\" \/>D) Composite key<br data-start=\"1235\" data-end=\"1238\" \/><strong data-start=\"1238\" data-end=\"1251\">Answer: B<\/strong><\/p>\n<hr data-start=\"1253\" data-end=\"1256\" \/>\n<h3 data-start=\"1258\" data-end=\"1290\">8. A foreign key is used to:<\/h3>\n<p data-start=\"1291\" data-end=\"1378\">A) Delete records<br data-start=\"1308\" data-end=\"1311\" \/>B) Create index<br data-start=\"1326\" data-end=\"1329\" \/>C) Link two tables<br data-start=\"1347\" data-end=\"1350\" \/>D) Sort data<br data-start=\"1362\" data-end=\"1365\" \/><strong data-start=\"1365\" data-end=\"1378\">Answer: C<\/strong><\/p>\n<hr data-start=\"1380\" data-end=\"1383\" \/>\n<h3 data-start=\"1385\" data-end=\"1437\">9. Which normal form removes partial dependency?<\/h3>\n<p data-start=\"1438\" data-end=\"1488\">A) 1NF<br data-start=\"1444\" data-end=\"1447\" \/>B) 2NF<br data-start=\"1453\" data-end=\"1456\" \/>C) 3NF<br data-start=\"1462\" data-end=\"1465\" \/>D) BCNF<br data-start=\"1472\" data-end=\"1475\" \/><strong data-start=\"1475\" data-end=\"1488\">Answer: B<\/strong><\/p>\n<hr data-start=\"1490\" data-end=\"1493\" \/>\n<h3 data-start=\"1495\" data-end=\"1525\">10. A tuple in DBMS means:<\/h3>\n<p data-start=\"1526\" data-end=\"1585\">A) Column<br data-start=\"1535\" data-end=\"1538\" \/>B) Row<br data-start=\"1544\" data-end=\"1547\" \/>C) Table<br data-start=\"1555\" data-end=\"1558\" \/>D) Database<br data-start=\"1569\" data-end=\"1572\" \/><strong data-start=\"1572\" data-end=\"1585\">Answer: B<\/strong><\/p>\n<hr data-start=\"1587\" data-end=\"1590\" \/>\n<h3 data-start=\"1592\" data-end=\"1622\">11. A relation in DBMS is:<\/h3>\n<p data-start=\"1623\" data-end=\"1679\">A) Row<br data-start=\"1629\" data-end=\"1632\" \/>B) Column<br data-start=\"1641\" data-end=\"1644\" \/>C) Table<br data-start=\"1652\" data-end=\"1655\" \/>D) Index<br data-start=\"1663\" data-end=\"1666\" \/><strong data-start=\"1666\" data-end=\"1679\">Answer: C<\/strong><\/p>\n<hr data-start=\"1681\" data-end=\"1684\" \/>\n<h3 data-start=\"1686\" data-end=\"1735\">12. Which command is used to add new records?<\/h3>\n<p data-start=\"1736\" data-end=\"1794\">A) ADD<br data-start=\"1742\" data-end=\"1745\" \/>B) INSERT<br data-start=\"1754\" data-end=\"1757\" \/>C) CREATE<br data-start=\"1766\" data-end=\"1769\" \/>D) UPDATE<br data-start=\"1778\" data-end=\"1781\" \/><strong data-start=\"1781\" data-end=\"1794\">Answer: B<\/strong><\/p>\n<hr data-start=\"1796\" data-end=\"1799\" \/>\n<h3 data-start=\"1801\" data-end=\"1824\">13. DDL stands for:<\/h3>\n<p data-start=\"1825\" data-end=\"1956\">A) Data Definition Language<br data-start=\"1852\" data-end=\"1855\" \/>B) Data Deletion Language<br data-start=\"1880\" data-end=\"1883\" \/>C) Data Directory Language<br data-start=\"1909\" data-end=\"1912\" \/>D) Data Duplication Language<br data-start=\"1940\" data-end=\"1943\" \/><strong data-start=\"1943\" data-end=\"1956\">Answer: A<\/strong><\/p>\n<hr data-start=\"1958\" data-end=\"1961\" \/>\n<h3 data-start=\"1963\" data-end=\"1994\">14. Which is a DDL command?<\/h3>\n<p data-start=\"1995\" data-end=\"2056\">A) SELECT<br data-start=\"2004\" data-end=\"2007\" \/>B) UPDATE<br data-start=\"2016\" data-end=\"2019\" \/>C) CREATE<br data-start=\"2028\" data-end=\"2031\" \/>D) DELETE<br data-start=\"2040\" data-end=\"2043\" \/><strong data-start=\"2043\" data-end=\"2056\">Answer: C<\/strong><\/p>\n<hr data-start=\"2058\" data-end=\"2061\" \/>\n<h3 data-start=\"2063\" data-end=\"2086\">15. DML stands for:<\/h3>\n<p data-start=\"2087\" data-end=\"2219\">A) Data Manipulation Language<br data-start=\"2116\" data-end=\"2119\" \/>B) Data Management Language<br data-start=\"2146\" data-end=\"2149\" \/>C) Data Modeling Language<br data-start=\"2174\" data-end=\"2177\" \/>D) Data Migration Language<br data-start=\"2203\" data-end=\"2206\" \/><strong data-start=\"2206\" data-end=\"2219\">Answer: A<\/strong><\/p>\n<hr data-start=\"2221\" data-end=\"2224\" \/>\n<h3 data-start=\"2226\" data-end=\"2264\">16. Which command deletes a table?<\/h3>\n<p data-start=\"2265\" data-end=\"2323\">A) REMOVE<br data-start=\"2274\" data-end=\"2277\" \/>B) DELETE<br data-start=\"2286\" data-end=\"2289\" \/>C) DROP<br data-start=\"2296\" data-end=\"2299\" \/>D) ERASE<br data-start=\"2307\" data-end=\"2310\" \/><strong data-start=\"2310\" data-end=\"2323\">Answer: C<\/strong><\/p>\n<hr data-start=\"2325\" data-end=\"2328\" \/>\n<h3 data-start=\"2330\" data-end=\"2377\">17. Which constraint ensures unique values?<\/h3>\n<p data-start=\"2378\" data-end=\"2441\">A) NOT NULL<br data-start=\"2389\" data-end=\"2392\" \/>B) UNIQUE<br data-start=\"2401\" data-end=\"2404\" \/>C) DEFAULT<br data-start=\"2414\" data-end=\"2417\" \/>D) CHECK<br data-start=\"2425\" data-end=\"2428\" \/><strong data-start=\"2428\" data-end=\"2441\">Answer: B<\/strong><\/p>\n<hr data-start=\"2443\" data-end=\"2446\" \/>\n<h3 data-start=\"2448\" data-end=\"2495\">18. Which clause is used to filter records?<\/h3>\n<p data-start=\"2496\" data-end=\"2560\">A) GROUP BY<br data-start=\"2507\" data-end=\"2510\" \/>B) ORDER BY<br data-start=\"2521\" data-end=\"2524\" \/>C) WHERE<br data-start=\"2532\" data-end=\"2535\" \/>D) HAVING<br data-start=\"2544\" data-end=\"2547\" \/><strong data-start=\"2547\" data-end=\"2560\">Answer: C<\/strong><\/p>\n<hr data-start=\"2562\" data-end=\"2565\" \/>\n<h3 data-start=\"2567\" data-end=\"2602\">19. Aggregate function example:<\/h3>\n<p data-start=\"2603\" data-end=\"2662\">A) SUM()<br data-start=\"2611\" data-end=\"2614\" \/>B) SELECT<br data-start=\"2623\" data-end=\"2626\" \/>C) INSERT<br data-start=\"2635\" data-end=\"2638\" \/>D) TABLE<br data-start=\"2646\" data-end=\"2649\" \/><strong data-start=\"2649\" data-end=\"2662\">Answer: A<\/strong><\/p>\n<hr data-start=\"2664\" data-end=\"2667\" \/>\n<h3 data-start=\"2669\" data-end=\"2702\">20. COUNT() function returns:<\/h3>\n<p data-start=\"2703\" data-end=\"2777\">A) Sum<br data-start=\"2709\" data-end=\"2712\" \/>B) Average<br data-start=\"2722\" data-end=\"2725\" \/>C) Number of rows<br data-start=\"2742\" data-end=\"2745\" \/>D) Maximum value<br data-start=\"2761\" data-end=\"2764\" \/><strong data-start=\"2764\" data-end=\"2777\">Answer: C<\/strong><\/p>\n<hr data-start=\"2779\" data-end=\"2782\" \/>\n<h3 data-start=\"2784\" data-end=\"2836\">21. Which joins tables based on matching values?<\/h3>\n<p data-start=\"2837\" data-end=\"2914\">A) INNER JOIN<br data-start=\"2850\" data-end=\"2853\" \/>B) DROP JOIN<br data-start=\"2865\" data-end=\"2868\" \/>C) DELETE JOIN<br data-start=\"2882\" data-end=\"2885\" \/>D) ALTER JOIN<br data-start=\"2898\" data-end=\"2901\" \/><strong data-start=\"2901\" data-end=\"2914\">Answer: A<\/strong><\/p>\n<hr data-start=\"2916\" data-end=\"2919\" \/>\n<h3 data-start=\"2921\" data-end=\"2959\">22. Which key can have NULL value?<\/h3>\n<p data-start=\"2960\" data-end=\"3041\">A) Primary key<br data-start=\"2974\" data-end=\"2977\" \/>B) Foreign key<br data-start=\"2991\" data-end=\"2994\" \/>C) Candidate key<br data-start=\"3010\" data-end=\"3013\" \/>D) Super key<br data-start=\"3025\" data-end=\"3028\" \/><strong data-start=\"3028\" data-end=\"3041\">Answer: B<\/strong><\/p>\n<hr data-start=\"3043\" data-end=\"3046\" \/>\n<h3 data-start=\"3048\" data-end=\"3071\">23. A super key is:<\/h3>\n<p data-start=\"3072\" data-end=\"3199\">A) Minimal unique key<br data-start=\"3093\" data-end=\"3096\" \/>B) Set of attributes uniquely identifying rows<br data-start=\"3142\" data-end=\"3145\" \/>C) Foreign key<br data-start=\"3159\" data-end=\"3162\" \/>D) Composite key only<br data-start=\"3183\" data-end=\"3186\" \/><strong data-start=\"3186\" data-end=\"3199\">Answer: B<\/strong><\/p>\n<hr data-start=\"3201\" data-end=\"3204\" \/>\n<h3 data-start=\"3206\" data-end=\"3262\">24. Which normal form removes transitive dependency?<\/h3>\n<p data-start=\"3263\" data-end=\"3312\">A) 1NF<br data-start=\"3269\" data-end=\"3272\" \/>B) 2NF<br data-start=\"3278\" data-end=\"3281\" \/>C) 3NF<br data-start=\"3287\" data-end=\"3290\" \/>D) 4NF<br data-start=\"3296\" data-end=\"3299\" \/><strong data-start=\"3299\" data-end=\"3312\">Answer: C<\/strong><\/p>\n<hr data-start=\"3314\" data-end=\"3317\" \/>\n<h3 data-start=\"3319\" data-end=\"3343\">25. BCNF stands for:<\/h3>\n<p data-start=\"3344\" data-end=\"3469\">A) Boyce-Codd Normal Form<br data-start=\"3369\" data-end=\"3372\" \/>B) Basic Codd Normal Form<br data-start=\"3397\" data-end=\"3400\" \/>C) Binary Code Normal Form<br data-start=\"3426\" data-end=\"3429\" \/>D) Base Codd Normal Form<br data-start=\"3453\" data-end=\"3456\" \/><strong data-start=\"3456\" data-end=\"3469\">Answer: A<\/strong><\/p>\n<hr data-start=\"3471\" data-end=\"3474\" \/>\n<h3 data-start=\"3476\" data-end=\"3523\">26. Which command modifies table structure?<\/h3>\n<p data-start=\"3524\" data-end=\"3584\">A) UPDATE<br data-start=\"3533\" data-end=\"3536\" \/>B) ALTER<br data-start=\"3544\" data-end=\"3547\" \/>C) MODIFY<br data-start=\"3556\" data-end=\"3559\" \/>D) CHANGE<br data-start=\"3568\" data-end=\"3571\" \/><strong data-start=\"3571\" data-end=\"3584\">Answer: B<\/strong><\/p>\n<hr data-start=\"3586\" data-end=\"3589\" \/>\n<h3 data-start=\"3591\" data-end=\"3614\">27. Index improves:<\/h3>\n<p data-start=\"3615\" data-end=\"3691\">A) Storage<br data-start=\"3625\" data-end=\"3628\" \/>B) Data retrieval speed<br data-start=\"3651\" data-end=\"3654\" \/>C) Security<br data-start=\"3665\" data-end=\"3668\" \/>D) Size<br data-start=\"3675\" data-end=\"3678\" \/><strong data-start=\"3678\" data-end=\"3691\">Answer: B<\/strong><\/p>\n<hr data-start=\"3693\" data-end=\"3696\" \/>\n<h3 data-start=\"3698\" data-end=\"3726\">28. Which is not a DBMS?<\/h3>\n<p data-start=\"3727\" data-end=\"3793\">A) Oracle<br data-start=\"3736\" data-end=\"3739\" \/>B) MySQL<br data-start=\"3747\" data-end=\"3750\" \/>C) PostgreSQL<br data-start=\"3763\" data-end=\"3766\" \/>D) MS Excel<br data-start=\"3777\" data-end=\"3780\" \/><strong data-start=\"3780\" data-end=\"3793\">Answer: D<\/strong><\/p>\n<hr data-start=\"3795\" data-end=\"3798\" \/>\n<h3 data-start=\"3800\" data-end=\"3818\">29. A view is:<\/h3>\n<p data-start=\"3819\" data-end=\"3896\">A) Physical table<br data-start=\"3836\" data-end=\"3839\" \/>B) Virtual table<br data-start=\"3855\" data-end=\"3858\" \/>C) Index<br data-start=\"3866\" data-end=\"3869\" \/>D) Database<br data-start=\"3880\" data-end=\"3883\" \/><strong data-start=\"3883\" data-end=\"3896\">Answer: B<\/strong><\/p>\n<hr data-start=\"3898\" data-end=\"3901\" \/>\n<h3 data-start=\"3903\" data-end=\"3965\">30. Which command removes all records but keeps the structure?<\/h3>\n<p data-start=\"3966\" data-end=\"4026\">A) DROP<br data-start=\"3973\" data-end=\"3976\" \/>B) DELETE<br data-start=\"3985\" data-end=\"3988\" \/>C) TRUNCATE<br data-start=\"3999\" data-end=\"4002\" \/>D) ERASE<br data-start=\"4010\" data-end=\"4013\" \/><strong data-start=\"4013\" data-end=\"4026\">Answer: C<\/strong><\/p>\n<hr data-start=\"4028\" data-end=\"4031\" \/>\n<h3 data-start=\"4033\" data-end=\"4063\">31. ACID property ensures:<\/h3>\n<p data-start=\"4064\" data-end=\"4150\">A) Speed<br data-start=\"4072\" data-end=\"4075\" \/>B) Security<br data-start=\"4086\" data-end=\"4089\" \/>C) Reliable transactions<br data-start=\"4113\" data-end=\"4116\" \/>D) Data redundancy<br data-start=\"4134\" data-end=\"4137\" \/><strong data-start=\"4137\" data-end=\"4150\">Answer: C<\/strong><\/p>\n<hr data-start=\"4152\" data-end=\"4155\" \/>\n<h3 data-start=\"4157\" data-end=\"4187\">32. A transaction must be:<\/h3>\n<p data-start=\"4188\" data-end=\"4258\">A) Permanent<br data-start=\"4200\" data-end=\"4203\" \/>B) Atomic<br data-start=\"4212\" data-end=\"4215\" \/>C) Temporary<br data-start=\"4227\" data-end=\"4230\" \/>D) Duplicate<br data-start=\"4242\" data-end=\"4245\" \/><strong data-start=\"4245\" data-end=\"4258\">Answer: B<\/strong><\/p>\n<hr data-start=\"4260\" data-end=\"4263\" \/>\n<h3 data-start=\"4265\" data-end=\"4289\">33. Atomicity means:<\/h3>\n<p data-start=\"4290\" data-end=\"4385\">A) All or nothing<br data-start=\"4307\" data-end=\"4310\" \/>B) Fast execution<br data-start=\"4327\" data-end=\"4330\" \/>C) Parallel processing<br data-start=\"4352\" data-end=\"4355\" \/>D) Duplication<br data-start=\"4369\" data-end=\"4372\" \/><strong data-start=\"4372\" data-end=\"4385\">Answer: A<\/strong><\/p>\n<hr data-start=\"4387\" data-end=\"4390\" \/>\n<h3 data-start=\"4392\" data-end=\"4420\">34. Consistency ensures:<\/h3>\n<p data-start=\"4421\" data-end=\"4502\">A) Data remains valid<br data-start=\"4442\" data-end=\"4445\" \/>B) Fast query<br data-start=\"4458\" data-end=\"4461\" \/>C) Small size<br data-start=\"4474\" data-end=\"4477\" \/>D) Backup<br data-start=\"4486\" data-end=\"4489\" \/><strong data-start=\"4489\" data-end=\"4502\">Answer: A<\/strong><\/p>\n<hr data-start=\"4504\" data-end=\"4507\" \/>\n<h3 data-start=\"4509\" data-end=\"4533\">35. Isolation means:<\/h3>\n<p data-start=\"4534\" data-end=\"4637\">A) Separate tables<br data-start=\"4552\" data-end=\"4555\" \/>B) Transactions do not interfere<br data-start=\"4587\" data-end=\"4590\" \/>C) Delete records<br data-start=\"4607\" data-end=\"4610\" \/>D) Indexing<br data-start=\"4621\" data-end=\"4624\" \/><strong data-start=\"4624\" data-end=\"4637\">Answer: B<\/strong><\/p>\n<hr data-start=\"4639\" data-end=\"4642\" \/>\n<h3 data-start=\"4644\" data-end=\"4669\">36. Durability means:<\/h3>\n<p data-start=\"4670\" data-end=\"4770\">A) Temporary storage<br data-start=\"4690\" data-end=\"4693\" \/>B) Permanent after commit<br data-start=\"4718\" data-end=\"4721\" \/>C) Fast rollback<br data-start=\"4737\" data-end=\"4740\" \/>D) Parallelism<br data-start=\"4754\" data-end=\"4757\" \/><strong data-start=\"4757\" data-end=\"4770\">Answer: B<\/strong><\/p>\n<hr data-start=\"4772\" data-end=\"4775\" \/>\n<h3 data-start=\"4777\" data-end=\"4817\">37. Which command saves transaction?<\/h3>\n<p data-start=\"4818\" data-end=\"4875\">A) SAVE<br data-start=\"4825\" data-end=\"4828\" \/>B) COMMIT<br data-start=\"4837\" data-end=\"4840\" \/>C) STORE<br data-start=\"4848\" data-end=\"4851\" \/>D) APPLY<br data-start=\"4859\" data-end=\"4862\" \/><strong data-start=\"4862\" data-end=\"4875\">Answer: B<\/strong><\/p>\n<hr data-start=\"4877\" data-end=\"4880\" \/>\n<h3 data-start=\"4882\" data-end=\"4924\">38. Which command cancels transaction?<\/h3>\n<p data-start=\"4925\" data-end=\"4986\">A) CANCEL<br data-start=\"4934\" data-end=\"4937\" \/>B) DELETE<br data-start=\"4946\" data-end=\"4949\" \/>C) ROLLBACK<br data-start=\"4960\" data-end=\"4963\" \/>D) DROP<br data-start=\"4970\" data-end=\"4973\" \/><strong data-start=\"4973\" data-end=\"4986\">Answer: C<\/strong><\/p>\n<hr data-start=\"4988\" data-end=\"4991\" \/>\n<h3 data-start=\"4993\" data-end=\"5023\">39. Data redundancy means:<\/h3>\n<p data-start=\"5024\" data-end=\"5107\">A) Unique data<br data-start=\"5038\" data-end=\"5041\" \/>B) Duplicate data<br data-start=\"5058\" data-end=\"5061\" \/>C) Clean data<br data-start=\"5074\" data-end=\"5077\" \/>D) Sorted data<br data-start=\"5091\" data-end=\"5094\" \/><strong data-start=\"5094\" data-end=\"5107\">Answer: B<\/strong><\/p>\n<hr data-start=\"5109\" data-end=\"5112\" \/>\n<h3 data-start=\"5114\" data-end=\"5146\">40. Data independence means:<\/h3>\n<p data-start=\"5147\" data-end=\"5249\">A) No database<br data-start=\"5161\" data-end=\"5164\" \/>B) Changes do not affect the application<br data-start=\"5200\" data-end=\"5203\" \/>C) No queries<br data-start=\"5216\" data-end=\"5219\" \/>D) Manual work<br data-start=\"5233\" data-end=\"5236\" \/><strong data-start=\"5236\" data-end=\"5249\">Answer: B<\/strong><\/p>\n<hr data-start=\"5251\" data-end=\"5254\" \/>\n<h3 data-start=\"5256\" data-end=\"5306\">41. Which level hides complexity from users?<\/h3>\n<p data-start=\"5307\" data-end=\"5393\">A) Physical level<br data-start=\"5324\" data-end=\"5327\" \/>B) Logical level<br data-start=\"5343\" data-end=\"5346\" \/>C) View level<br data-start=\"5359\" data-end=\"5362\" \/>D) Schema level<br data-start=\"5377\" data-end=\"5380\" \/><strong data-start=\"5380\" data-end=\"5393\">Answer: C<\/strong><\/p>\n<hr data-start=\"5395\" data-end=\"5398\" \/>\n<h3 data-start=\"5400\" data-end=\"5428\">42. Entity represents:<\/h3>\n<p data-start=\"5429\" data-end=\"5504\">A) Table only<br data-start=\"5442\" data-end=\"5445\" \/>B) Real-world object<br data-start=\"5465\" data-end=\"5468\" \/>C) Column<br data-start=\"5477\" data-end=\"5480\" \/>D) Index<br data-start=\"5488\" data-end=\"5491\" \/><strong data-start=\"5491\" data-end=\"5504\">Answer: B<\/strong><\/p>\n<hr data-start=\"5506\" data-end=\"5509\" \/>\n<h3 data-start=\"5511\" data-end=\"5543\">43. ER diagram stands for:<\/h3>\n<p data-start=\"5544\" data-end=\"5676\">A) Entity Relationship diagram<br data-start=\"5574\" data-end=\"5577\" \/>B) Entry Relation diagram<br data-start=\"5602\" data-end=\"5605\" \/>C) External Relation diagram<br data-start=\"5633\" data-end=\"5636\" \/>D) Entity Record diagram<br data-start=\"5660\" data-end=\"5663\" \/><strong data-start=\"5663\" data-end=\"5676\">Answer: A<\/strong><\/p>\n<hr data-start=\"5678\" data-end=\"5681\" \/>\n<h3 data-start=\"5683\" data-end=\"5713\">44. Cardinality defines:<\/h3>\n<p data-start=\"5714\" data-end=\"5798\">A) Data type<br data-start=\"5726\" data-end=\"5729\" \/>B) Number of relationships<br data-start=\"5755\" data-end=\"5758\" \/>C) Table size<br data-start=\"5771\" data-end=\"5774\" \/>D) Index<br data-start=\"5782\" data-end=\"5785\" \/><strong data-start=\"5785\" data-end=\"5798\">Answer: B<\/strong><\/p>\n<hr data-start=\"5800\" data-end=\"5803\" \/>\n<h3 data-start=\"5805\" data-end=\"5848\">45. One-to-many relationship example:<\/h3>\n<p data-start=\"5849\" data-end=\"5946\">A) Student\u2013Course<br data-start=\"5866\" data-end=\"5869\" \/>B) Teacher\u2013Students<br data-start=\"5888\" data-end=\"5891\" \/>C) Person\u2013Passport<br data-start=\"5909\" data-end=\"5912\" \/>D) Country\u2013Capital<br data-start=\"5930\" data-end=\"5933\" \/><strong data-start=\"5933\" data-end=\"5946\">Answer: B<\/strong><\/p>\n<hr data-start=\"5948\" data-end=\"5951\" \/>\n<h3 data-start=\"5953\" data-end=\"5987\">46. Which is a NoSQL database?<\/h3>\n<p data-start=\"5988\" data-end=\"6053\">A) MySQL<br data-start=\"5996\" data-end=\"5999\" \/>B) Oracle<br data-start=\"6008\" data-end=\"6011\" \/>C) MongoDB<br data-start=\"6021\" data-end=\"6024\" \/>D) SQL Server<br data-start=\"6037\" data-end=\"6040\" \/><strong data-start=\"6040\" data-end=\"6053\">Answer: C<\/strong><\/p>\n<hr data-start=\"6055\" data-end=\"6058\" \/>\n<h3 data-start=\"6060\" data-end=\"6099\">47. Which SQL clause groups rows?<\/h3>\n<p data-start=\"6100\" data-end=\"6164\">A) WHERE<br data-start=\"6108\" data-end=\"6111\" \/>B) GROUP BY<br data-start=\"6122\" data-end=\"6125\" \/>C) ORDER BY<br data-start=\"6136\" data-end=\"6139\" \/>D) SELECT<br data-start=\"6148\" data-end=\"6151\" \/><strong data-start=\"6151\" data-end=\"6164\">Answer: B<\/strong><\/p>\n<hr data-start=\"6166\" data-end=\"6169\" \/>\n<h3 data-start=\"6171\" data-end=\"6208\">48. The HAVING clause is used with:<\/h3>\n<p data-start=\"6209\" data-end=\"6271\">A) WHERE<br data-start=\"6217\" data-end=\"6220\" \/>B) GROUP BY<br data-start=\"6231\" data-end=\"6234\" \/>C) INSERT<br data-start=\"6243\" data-end=\"6246\" \/>D) UPDATE<br data-start=\"6255\" data-end=\"6258\" \/><strong data-start=\"6258\" data-end=\"6271\">Answer: B<\/strong><\/p>\n<hr data-start=\"6273\" data-end=\"6276\" \/>\n<h3 data-start=\"6278\" data-end=\"6308\">49. ORDER BY is used to:<\/h3>\n<p data-start=\"6309\" data-end=\"6367\">A) Filter<br data-start=\"6318\" data-end=\"6321\" \/>B) Group<br data-start=\"6329\" data-end=\"6332\" \/>C) Sort<br data-start=\"6339\" data-end=\"6342\" \/>D) Delete<br data-start=\"6351\" data-end=\"6354\" \/><strong data-start=\"6354\" data-end=\"6367\">Answer: C<\/strong><\/p>\n<hr data-start=\"6369\" data-end=\"6372\" \/>\n<h3 data-start=\"6374\" data-end=\"6406\">50. Default sort order is:<\/h3>\n<p data-start=\"6407\" data-end=\"6461\">A) DESC<br data-start=\"6414\" data-end=\"6417\" \/>B) ASC<br data-start=\"6423\" data-end=\"6426\" \/>C) RANDOM<br data-start=\"6435\" data-end=\"6438\" \/>D) NONE<br data-start=\"6445\" data-end=\"6448\" \/><strong data-start=\"6448\" data-end=\"6461\">Answer: B<\/strong><\/p>\n<hr data-start=\"6463\" data-end=\"6466\" \/>\n<h3 data-start=\"6468\" data-end=\"6506\">51\u2013100 (Continuing in the same format)<\/h3>\n<hr data-start=\"6508\" data-end=\"6511\" \/>\n<h3 data-start=\"6513\" data-end=\"6558\">51. Which function finds the maximum value?<\/h3>\n<p data-start=\"6559\" data-end=\"6616\">A) MAX()<br data-start=\"6567\" data-end=\"6570\" \/>B) MIN()<br data-start=\"6578\" data-end=\"6581\" \/>C) AVG()<br data-start=\"6589\" data-end=\"6592\" \/>D) SUM()<br data-start=\"6600\" data-end=\"6603\" \/><strong data-start=\"6603\" data-end=\"6616\">Answer: A<\/strong><\/p>\n<hr data-start=\"6618\" data-end=\"6621\" \/>\n<h3 data-start=\"6623\" data-end=\"6672\">52. Which key is a combination of attributes?<\/h3>\n<p data-start=\"6673\" data-end=\"6754\">A) Composite key<br data-start=\"6689\" data-end=\"6692\" \/>B) Primary key<br data-start=\"6706\" data-end=\"6709\" \/>C) Foreign key<br data-start=\"6723\" data-end=\"6726\" \/>D) Super key<br data-start=\"6738\" data-end=\"6741\" \/><strong data-start=\"6741\" data-end=\"6754\">Answer: A<\/strong><\/p>\n<hr data-start=\"6756\" data-end=\"6759\" \/>\n<h3 data-start=\"6761\" data-end=\"6781\">53. Schema is:<\/h3>\n<p data-start=\"6782\" data-end=\"6858\">A) Data<br data-start=\"6789\" data-end=\"6792\" \/>B) Structure of the database<br data-start=\"6816\" data-end=\"6819\" \/>C) Query<br data-start=\"6827\" data-end=\"6830\" \/>D) Table row<br data-start=\"6842\" data-end=\"6845\" \/><strong data-start=\"6845\" data-end=\"6858\">Answer: B<\/strong><\/p>\n<hr data-start=\"6860\" data-end=\"6863\" \/>\n<h3 data-start=\"6865\" data-end=\"6887\">54. Instance is:<\/h3>\n<p data-start=\"6888\" data-end=\"6967\">A) Structure<br data-start=\"6900\" data-end=\"6903\" \/>B) Current data in DB<br data-start=\"6924\" data-end=\"6927\" \/>C) Table design<br data-start=\"6942\" data-end=\"6945\" \/>D) Key<br data-start=\"6951\" data-end=\"6954\" \/><strong data-start=\"6954\" data-end=\"6967\">Answer: B<\/strong><\/p>\n<hr data-start=\"6969\" data-end=\"6972\" \/>\n<h3 data-start=\"6974\" data-end=\"7031\">55. Which join returns all records from the left table?<\/h3>\n<p data-start=\"7032\" data-end=\"7107\">A) RIGHT JOIN<br data-start=\"7045\" data-end=\"7048\" \/>B) INNER JOIN<br data-start=\"7061\" data-end=\"7064\" \/>C) LEFT JOIN<br data-start=\"7076\" data-end=\"7079\" \/>D) FULL JOIN<br data-start=\"7091\" data-end=\"7094\" \/><strong data-start=\"7094\" data-end=\"7107\">Answer: C<\/strong><\/p>\n<hr data-start=\"7109\" data-end=\"7112\" \/>\n<h3 data-start=\"7114\" data-end=\"7172\">56. Which join returns all records from both tables?<\/h3>\n<p data-start=\"7173\" data-end=\"7239\">A) INNER<br data-start=\"7181\" data-end=\"7184\" \/>B) FULL OUTER JOIN<br data-start=\"7202\" data-end=\"7205\" \/>C) LEFT<br data-start=\"7212\" data-end=\"7215\" \/>D) RIGHT<br data-start=\"7223\" data-end=\"7226\" \/><strong data-start=\"7226\" data-end=\"7239\">Answer: B<\/strong><\/p>\n<hr data-start=\"7241\" data-end=\"7244\" \/>\n<h3 data-start=\"7246\" data-end=\"7295\">57. Which command removes specific records?<\/h3>\n<p data-start=\"7296\" data-end=\"7356\">A) DELETE<br data-start=\"7305\" data-end=\"7308\" \/>B) DROP<br data-start=\"7315\" data-end=\"7318\" \/>C) TRUNCATE<br data-start=\"7329\" data-end=\"7332\" \/>D) CLEAR<br data-start=\"7340\" data-end=\"7343\" \/><strong data-start=\"7343\" data-end=\"7356\">Answer: A<\/strong><\/p>\n<hr data-start=\"7358\" data-end=\"7361\" \/>\n<h3 data-start=\"7363\" data-end=\"7403\">58. Which is used to rename a table?<\/h3>\n<p data-start=\"7404\" data-end=\"7464\">A) CHANGE<br data-start=\"7413\" data-end=\"7416\" \/>B) ALTER<br data-start=\"7424\" data-end=\"7427\" \/>C) RENAME<br data-start=\"7436\" data-end=\"7439\" \/>D) MODIFY<br data-start=\"7448\" data-end=\"7451\" \/><strong data-start=\"7451\" data-end=\"7464\">Answer: C<\/strong><\/p>\n<hr data-start=\"7466\" data-end=\"7469\" \/>\n<h3 data-start=\"7471\" data-end=\"7506\">59. CHECK constraint ensures:<\/h3>\n<p data-start=\"7507\" data-end=\"7595\">A) Unique value<br data-start=\"7522\" data-end=\"7525\" \/>B) Condition validation<br data-start=\"7548\" data-end=\"7551\" \/>C) Not null<br data-start=\"7562\" data-end=\"7565\" \/>D) Primary key<br data-start=\"7579\" data-end=\"7582\" \/><strong data-start=\"7582\" data-end=\"7595\">Answer: B<\/strong><\/p>\n<hr data-start=\"7597\" data-end=\"7600\" \/>\n<h3 data-start=\"7602\" data-end=\"7640\">60. NOT NULL constraint ensures:<\/h3>\n<p data-start=\"7641\" data-end=\"7721\">A) No duplicate<br data-start=\"7656\" data-end=\"7659\" \/>B) No empty value<br data-start=\"7676\" data-end=\"7679\" \/>C) No delete<br data-start=\"7691\" data-end=\"7694\" \/>D) No index<br data-start=\"7705\" data-end=\"7708\" \/><strong data-start=\"7708\" data-end=\"7721\">Answer: B<\/strong><\/p>\n<hr data-start=\"7723\" data-end=\"7726\" \/>\n<p><a href=\"https:\/\/murreeroad.org\/100-operating-systems-mcqs-with-answers\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-5193\" src=\"https:\/\/murreeroad.org\/wp-content\/uploads\/2026\/02\/100-Operating-Systems-MCQs-with-Answers-683x1024.png\" alt=\"100 Operating Systems MCQs with Answers\" width=\"640\" height=\"960\" srcset=\"https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Operating-Systems-MCQs-with-Answers-683x1024.png 683w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Operating-Systems-MCQs-with-Answers-200x300.png 200w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Operating-Systems-MCQs-with-Answers-768x1152.png 768w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Operating-Systems-MCQs-with-Answers.png 1024w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<hr data-start=\"7723\" data-end=\"7726\" \/>\n<h3 data-start=\"231\" data-end=\"291\">61. Which command is used to grant privileges to a user?<\/h3>\n<p data-start=\"292\" data-end=\"349\">A) ALLOW<br data-start=\"300\" data-end=\"303\" \/>B) PERMIT<br data-start=\"312\" data-end=\"315\" \/>C) GRANT<br data-start=\"323\" data-end=\"326\" \/>D) GIVE<br data-start=\"333\" data-end=\"336\" \/><strong data-start=\"336\" data-end=\"349\">Answer: C<\/strong><\/p>\n<hr data-start=\"351\" data-end=\"354\" \/>\n<h3 data-start=\"356\" data-end=\"412\">62. Which command is used to remove user privileges?<\/h3>\n<p data-start=\"413\" data-end=\"474\">A) DELETE<br data-start=\"422\" data-end=\"425\" \/>B) REMOVE<br data-start=\"434\" data-end=\"437\" \/>C) REVOKE<br data-start=\"446\" data-end=\"449\" \/>D) CANCEL<br data-start=\"458\" data-end=\"461\" \/><strong data-start=\"461\" data-end=\"474\">Answer: C<\/strong><\/p>\n<hr data-start=\"476\" data-end=\"479\" \/>\n<h3 data-start=\"481\" data-end=\"510\">63. A trigger in DBMS is:<\/h3>\n<p data-start=\"511\" data-end=\"614\">A) Manual query<br data-start=\"526\" data-end=\"529\" \/>B) Automatic procedure executed on events<br data-start=\"570\" data-end=\"573\" \/>C) Backup file<br data-start=\"587\" data-end=\"590\" \/>D) Index<br data-start=\"598\" data-end=\"601\" \/><strong data-start=\"601\" data-end=\"614\">Answer: B<\/strong><\/p>\n<hr data-start=\"616\" data-end=\"619\" \/>\n<h3 data-start=\"621\" data-end=\"651\">64. A stored procedure is:<\/h3>\n<p data-start=\"652\" data-end=\"759\">A) Temporary query<br data-start=\"670\" data-end=\"673\" \/>B) Precompiled collection of SQL statements<br data-start=\"716\" data-end=\"719\" \/>C) Index<br data-start=\"727\" data-end=\"730\" \/>D) Constraint<br data-start=\"743\" data-end=\"746\" \/><strong data-start=\"746\" data-end=\"759\">Answer: B<\/strong><\/p>\n<hr data-start=\"761\" data-end=\"764\" \/>\n<h3 data-start=\"766\" data-end=\"795\">65. A cursor is used for:<\/h3>\n<p data-start=\"796\" data-end=\"891\">A) Bulk processing<br data-start=\"814\" data-end=\"817\" \/>B) Row-by-row processing<br data-start=\"841\" data-end=\"844\" \/>C) Table deletion<br data-start=\"861\" data-end=\"864\" \/>D) Indexing<br data-start=\"875\" data-end=\"878\" \/><strong data-start=\"878\" data-end=\"891\">Answer: B<\/strong><\/p>\n<hr data-start=\"893\" data-end=\"896\" \/>\n<h3 data-start=\"898\" data-end=\"939\">66. A centralized database is stored:<\/h3>\n<p data-start=\"940\" data-end=\"1048\">A) At multiple locations<br data-start=\"964\" data-end=\"967\" \/>B) On cloud only<br data-start=\"983\" data-end=\"986\" \/>C) At a single location<br data-start=\"1009\" data-end=\"1012\" \/>D) On mobile devices<br data-start=\"1032\" data-end=\"1035\" \/><strong data-start=\"1035\" data-end=\"1048\">Answer: C<\/strong><\/p>\n<hr data-start=\"1050\" data-end=\"1053\" \/>\n<h3 data-start=\"1055\" data-end=\"1096\">67. A distributed database is stored:<\/h3>\n<p data-start=\"1097\" data-end=\"1185\">A) In one file<br data-start=\"1111\" data-end=\"1114\" \/>B) In multiple locations<br data-start=\"1138\" data-end=\"1141\" \/>C) In RAM only<br data-start=\"1155\" data-end=\"1158\" \/>D) In cache<br data-start=\"1169\" data-end=\"1172\" \/><strong data-start=\"1172\" data-end=\"1185\">Answer: B<\/strong><\/p>\n<hr data-start=\"1187\" data-end=\"1190\" \/>\n<h3 data-start=\"1192\" data-end=\"1223\">68. Data mining is used to:<\/h3>\n<p data-start=\"1224\" data-end=\"1322\">A) Delete data<br data-start=\"1238\" data-end=\"1241\" \/>B) Extract useful patterns<br data-start=\"1267\" data-end=\"1270\" \/>C) Backup database<br data-start=\"1288\" data-end=\"1291\" \/>D) Encrypt data<br data-start=\"1306\" data-end=\"1309\" \/><strong data-start=\"1309\" data-end=\"1322\">Answer: B<\/strong><\/p>\n<hr data-start=\"1324\" data-end=\"1327\" \/>\n<h3 data-start=\"1329\" data-end=\"1377\">69. Database backup is important to prevent:<\/h3>\n<p data-start=\"1378\" data-end=\"1456\">A) Speed issues<br data-start=\"1393\" data-end=\"1396\" \/>B) Data loss<br data-start=\"1408\" data-end=\"1411\" \/>C) Normalization<br data-start=\"1427\" data-end=\"1430\" \/>D) Sorting<br data-start=\"1440\" data-end=\"1443\" \/><strong data-start=\"1443\" data-end=\"1456\">Answer: B<\/strong><\/p>\n<hr data-start=\"1458\" data-end=\"1461\" \/>\n<h3 data-start=\"1463\" data-end=\"1500\">70. The restore operation is used to:<\/h3>\n<p data-start=\"1501\" data-end=\"1594\">A) Delete database<br data-start=\"1519\" data-end=\"1522\" \/>B) Recover lost data<br data-start=\"1542\" data-end=\"1545\" \/>C) Create index<br data-start=\"1560\" data-end=\"1563\" \/>D) Modify table<br data-start=\"1578\" data-end=\"1581\" \/><strong data-start=\"1581\" data-end=\"1594\">Answer: B<\/strong><\/p>\n<hr data-start=\"1596\" data-end=\"1599\" \/>\n<h3 data-start=\"1601\" data-end=\"1639\">71. The locking mechanism is used for:<\/h3>\n<p data-start=\"1640\" data-end=\"1724\">A) Data redundancy<br data-start=\"1658\" data-end=\"1661\" \/>B) Concurrency control<br data-start=\"1683\" data-end=\"1686\" \/>C) Sorting<br data-start=\"1696\" data-end=\"1699\" \/>D) Backup<br data-start=\"1708\" data-end=\"1711\" \/><strong data-start=\"1711\" data-end=\"1724\">Answer: B<\/strong><\/p>\n<hr data-start=\"1726\" data-end=\"1729\" \/>\n<h3 data-start=\"1731\" data-end=\"1768\">72. Deadlock in DBMS occurs when:<\/h3>\n<p data-start=\"1769\" data-end=\"1899\">A) Database crashes<br data-start=\"1788\" data-end=\"1791\" \/>B) Transactions wait indefinitely for each other<br data-start=\"1839\" data-end=\"1842\" \/>C) Table is empty<br data-start=\"1859\" data-end=\"1862\" \/>D) Query is incorrect<br data-start=\"1883\" data-end=\"1886\" \/><strong data-start=\"1886\" data-end=\"1899\">Answer: B<\/strong><\/p>\n<hr data-start=\"1901\" data-end=\"1904\" \/>\n<h3 data-start=\"1906\" data-end=\"1953\">73. Timestamp ordering protocol is used to:<\/h3>\n<p data-start=\"1954\" data-end=\"2058\">A) Increase speed<br data-start=\"1971\" data-end=\"1974\" \/>B) Prevent transaction conflicts<br data-start=\"2006\" data-end=\"2009\" \/>C) Backup data<br data-start=\"2023\" data-end=\"2026\" \/>D) Delete tables<br data-start=\"2042\" data-end=\"2045\" \/><strong data-start=\"2045\" data-end=\"2058\">Answer: B<\/strong><\/p>\n<hr data-start=\"2060\" data-end=\"2063\" \/>\n<h3 data-start=\"2065\" data-end=\"2099\">74. A log file in DBMS stores:<\/h3>\n<p data-start=\"2100\" data-end=\"2197\">A) Table structure<br data-start=\"2118\" data-end=\"2121\" \/>B) Transaction history<br data-start=\"2143\" data-end=\"2146\" \/>C) Index values<br data-start=\"2161\" data-end=\"2164\" \/>D) User passwords<br data-start=\"2181\" data-end=\"2184\" \/><strong data-start=\"2184\" data-end=\"2197\">Answer: B<\/strong><\/p>\n<hr data-start=\"2199\" data-end=\"2202\" \/>\n<h3 data-start=\"2204\" data-end=\"2248\">75. A data warehouse is mainly used for:<\/h3>\n<p data-start=\"2249\" data-end=\"2357\">A) Transaction processing<br data-start=\"2274\" data-end=\"2277\" \/>B) Data analysis and reporting<br data-start=\"2307\" data-end=\"2310\" \/>C) Data entry<br data-start=\"2323\" data-end=\"2326\" \/>D) File storage<br data-start=\"2341\" data-end=\"2344\" \/><strong data-start=\"2344\" data-end=\"2357\">Answer: B<\/strong><\/p>\n<hr data-start=\"2359\" data-end=\"2362\" \/>\n<h3 data-start=\"2364\" data-end=\"2388\">76. OLTP stands for:<\/h3>\n<p data-start=\"2389\" data-end=\"2545\">A) Online Logical Transaction Processing<br data-start=\"2429\" data-end=\"2432\" \/>B) Online Transaction Processing<br data-start=\"2464\" data-end=\"2467\" \/>C) Offline Transaction Processing<br data-start=\"2500\" data-end=\"2503\" \/>D) Online Table Processing<br data-start=\"2529\" data-end=\"2532\" \/><strong data-start=\"2532\" data-end=\"2545\">Answer: B<\/strong><\/p>\n<hr data-start=\"2547\" data-end=\"2550\" \/>\n<h3 data-start=\"2552\" data-end=\"2576\">77. OLAP stands for:<\/h3>\n<p data-start=\"2577\" data-end=\"2736\">A) Online Analytical Processing<br data-start=\"2608\" data-end=\"2611\" \/>B) Offline Analytical Processing<br data-start=\"2643\" data-end=\"2646\" \/>C) Online Application Processing<br data-start=\"2678\" data-end=\"2681\" \/>D) Object Logical Analytical Processing<br data-start=\"2720\" data-end=\"2723\" \/><strong data-start=\"2723\" data-end=\"2736\">Answer: A<\/strong><\/p>\n<hr data-start=\"2738\" data-end=\"2741\" \/>\n<h3 data-start=\"2743\" data-end=\"2770\">78. Big Data refers to:<\/h3>\n<p data-start=\"2771\" data-end=\"2885\">A) Small database<br data-start=\"2788\" data-end=\"2791\" \/>B) Structured data only<br data-start=\"2814\" data-end=\"2817\" \/>C) Very large and complex datasets<br data-start=\"2851\" data-end=\"2854\" \/>D) Simple table<br data-start=\"2869\" data-end=\"2872\" \/><strong data-start=\"2872\" data-end=\"2885\">Answer: C<\/strong><\/p>\n<hr data-start=\"2887\" data-end=\"2890\" \/>\n<h3 data-start=\"2892\" data-end=\"2912\">79. Metadata is:<\/h3>\n<p data-start=\"2913\" data-end=\"2993\">A) Raw data<br data-start=\"2924\" data-end=\"2927\" \/>B) Data about data<br data-start=\"2945\" data-end=\"2948\" \/>C) Backup file<br data-start=\"2962\" data-end=\"2965\" \/>D) SQL query<br data-start=\"2977\" data-end=\"2980\" \/><strong data-start=\"2980\" data-end=\"2993\">Answer: B<\/strong><\/p>\n<hr data-start=\"2995\" data-end=\"2998\" \/>\n<h3 data-start=\"3000\" data-end=\"3037\">80. A primary key cannot contain:<\/h3>\n<p data-start=\"3038\" data-end=\"3120\">A) Duplicate values<br data-start=\"3057\" data-end=\"3060\" \/>B) NULL values<br data-start=\"3074\" data-end=\"3077\" \/>C) Unique values<br data-start=\"3093\" data-end=\"3096\" \/>D) Index<br data-start=\"3104\" data-end=\"3107\" \/><strong data-start=\"3107\" data-end=\"3120\">Answer: B<\/strong><\/p>\n<hr data-start=\"3122\" data-end=\"3125\" \/>\n<h3 data-start=\"3127\" data-end=\"3180\">81. Which is an example of a hierarchical database?<\/h3>\n<p data-start=\"3181\" data-end=\"3242\">A) MySQL<br data-start=\"3189\" data-end=\"3192\" \/>B) IMS<br data-start=\"3198\" data-end=\"3201\" \/>C) Oracle<br data-start=\"3210\" data-end=\"3213\" \/>D) SQL Server<br data-start=\"3226\" data-end=\"3229\" \/><strong data-start=\"3229\" data-end=\"3242\">Answer: B<\/strong><\/p>\n<hr data-start=\"3244\" data-end=\"3247\" \/>\n<h3 data-start=\"3249\" data-end=\"3280\">82. The network model uses:<\/h3>\n<p data-start=\"3281\" data-end=\"3344\">A) Tables<br data-start=\"3290\" data-end=\"3293\" \/>B) Trees<br data-start=\"3301\" data-end=\"3304\" \/>C) Pointers<br data-start=\"3315\" data-end=\"3318\" \/>D) Indexes<br data-start=\"3328\" data-end=\"3331\" \/><strong data-start=\"3331\" data-end=\"3344\">Answer: C<\/strong><\/p>\n<hr data-start=\"3346\" data-end=\"3349\" \/>\n<h3 data-start=\"3351\" data-end=\"3389\">83. Referential integrity ensures:<\/h3>\n<p data-start=\"3390\" data-end=\"3489\">A) Unique records<br data-start=\"3407\" data-end=\"3410\" \/>B) Valid foreign key relationships<br data-start=\"3444\" data-end=\"3447\" \/>C) Sorted data<br data-start=\"3461\" data-end=\"3464\" \/>D) Backup<br data-start=\"3473\" data-end=\"3476\" \/><strong data-start=\"3476\" data-end=\"3489\">Answer: B<\/strong><\/p>\n<hr data-start=\"3491\" data-end=\"3494\" \/>\n<h3 data-start=\"3496\" data-end=\"3555\">84. Which of the following is a cloud database service?<\/h3>\n<p data-start=\"3556\" data-end=\"3631\">A) MS Access<br data-start=\"3568\" data-end=\"3571\" \/>B) Oracle Forms<br data-start=\"3586\" data-end=\"3589\" \/>C) Amazon RDS<br data-start=\"3602\" data-end=\"3605\" \/>D) Notepad<br data-start=\"3615\" data-end=\"3618\" \/><strong data-start=\"3618\" data-end=\"3631\">Answer: C<\/strong><\/p>\n<hr data-start=\"3633\" data-end=\"3636\" \/>\n<h3 data-start=\"3638\" data-end=\"3679\">85. MySQL is currently maintained by:<\/h3>\n<p data-start=\"3680\" data-end=\"3753\">A) Microsoft<br data-start=\"3692\" data-end=\"3695\" \/>B) Google<br data-start=\"3704\" data-end=\"3707\" \/>C) Oracle Corporation<br data-start=\"3728\" data-end=\"3731\" \/>D) IBM<br data-start=\"3737\" data-end=\"3740\" \/><strong data-start=\"3740\" data-end=\"3753\">Answer: C<\/strong><\/p>\n<hr data-start=\"3755\" data-end=\"3758\" \/>\n<h3 data-start=\"3760\" data-end=\"3782\">86. PostgreSQL is:<\/h3>\n<p data-start=\"3783\" data-end=\"3879\">A) Proprietary DBMS<br data-start=\"3802\" data-end=\"3805\" \/>B) Open-source DBMS<br data-start=\"3824\" data-end=\"3827\" \/>C) Operating System<br data-start=\"3846\" data-end=\"3849\" \/>D) Spreadsheet<br data-start=\"3863\" data-end=\"3866\" \/><strong data-start=\"3866\" data-end=\"3879\">Answer: B<\/strong><\/p>\n<hr data-start=\"3881\" data-end=\"3884\" \/>\n<h3 data-start=\"3886\" data-end=\"3921\">87. Data anomaly occurs due to:<\/h3>\n<p data-start=\"3922\" data-end=\"3996\">A) Normalization<br data-start=\"3938\" data-end=\"3941\" \/>B) Redundancy<br data-start=\"3954\" data-end=\"3957\" \/>C) Indexing<br data-start=\"3968\" data-end=\"3971\" \/>D) Backup<br data-start=\"3980\" data-end=\"3983\" \/><strong data-start=\"3983\" data-end=\"3996\">Answer: B<\/strong><\/p>\n<hr data-start=\"3998\" data-end=\"4001\" \/>\n<h3 data-start=\"4003\" data-end=\"4038\">88. Denormalization is used to:<\/h3>\n<p data-start=\"4039\" data-end=\"4148\">A) Reduce redundancy<br data-start=\"4059\" data-end=\"4062\" \/>B) Increase query performance<br data-start=\"4091\" data-end=\"4094\" \/>C) Delete data<br data-start=\"4108\" data-end=\"4111\" \/>D) Remove constraints<br data-start=\"4132\" data-end=\"4135\" \/><strong data-start=\"4135\" data-end=\"4148\">Answer: B<\/strong><\/p>\n<hr data-start=\"4150\" data-end=\"4153\" \/>\n<h3 data-start=\"4155\" data-end=\"4205\">89. Which command modifies an existing column?<\/h3>\n<p data-start=\"4206\" data-end=\"4272\">A) UPDATE<br data-start=\"4215\" data-end=\"4218\" \/>B) CHANGE<br data-start=\"4227\" data-end=\"4230\" \/>C) ALTER<br data-start=\"4238\" data-end=\"4241\" \/>D) MODIFY TABLE<br data-start=\"4256\" data-end=\"4259\" \/><strong data-start=\"4259\" data-end=\"4272\">Answer: C<\/strong><\/p>\n<hr data-start=\"4274\" data-end=\"4277\" \/>\n<h3 data-start=\"4279\" data-end=\"4322\">90. The VARCHAR data type is used to store:<\/h3>\n<p data-start=\"4323\" data-end=\"4405\">A) Integers<br data-start=\"4334\" data-end=\"4337\" \/>B) Fixed numbers<br data-start=\"4353\" data-end=\"4356\" \/>C) Variable-length text<br data-start=\"4379\" data-end=\"4382\" \/>D) Date<br data-start=\"4389\" data-end=\"4392\" \/><strong data-start=\"4392\" data-end=\"4405\">Answer: C<\/strong><\/p>\n<hr data-start=\"4407\" data-end=\"4410\" \/>\n<h3 data-start=\"4412\" data-end=\"4451\">91. INT data type is used to store:<\/h3>\n<p data-start=\"4452\" data-end=\"4527\">A) Characters<br data-start=\"4465\" data-end=\"4468\" \/>B) Decimal<br data-start=\"4478\" data-end=\"4481\" \/>C) Integer values<br data-start=\"4498\" data-end=\"4501\" \/>D) Boolean<br data-start=\"4511\" data-end=\"4514\" \/><strong data-start=\"4514\" data-end=\"4527\">Answer: C<\/strong><\/p>\n<hr data-start=\"4529\" data-end=\"4532\" \/>\n<h3 data-start=\"4534\" data-end=\"4564\">92. DATE data type stores:<\/h3>\n<p data-start=\"4565\" data-end=\"4630\">A) Text<br data-start=\"4572\" data-end=\"4575\" \/>B) Numbers<br data-start=\"4585\" data-end=\"4588\" \/>C) Date values<br data-start=\"4602\" data-end=\"4605\" \/>D) Images<br data-start=\"4614\" data-end=\"4617\" \/><strong data-start=\"4617\" data-end=\"4630\">Answer: C<\/strong><\/p>\n<hr data-start=\"4632\" data-end=\"4635\" \/>\n<h3 data-start=\"4637\" data-end=\"4674\">93. The LIKE operator is used to:<\/h3>\n<p data-start=\"4675\" data-end=\"4765\">A) Compare numbers<br data-start=\"4693\" data-end=\"4696\" \/>B) Search patterns<br data-start=\"4714\" data-end=\"4717\" \/>C) Delete records<br data-start=\"4734\" data-end=\"4737\" \/>D) Sort data<br data-start=\"4749\" data-end=\"4752\" \/><strong data-start=\"4752\" data-end=\"4765\">Answer: B<\/strong><\/p>\n<hr data-start=\"4767\" data-end=\"4770\" \/>\n<h3 data-start=\"4772\" data-end=\"4833\">94. Which wildcard represents multiple characters in SQL?<\/h3>\n<p data-start=\"4834\" data-end=\"4875\">A) _<br data-start=\"4838\" data-end=\"4841\" \/>B) %<br data-start=\"4845\" data-end=\"4848\" \/>C) *<br data-start=\"4852\" data-end=\"4855\" \/>D) #<br data-start=\"4859\" data-end=\"4862\" \/><strong data-start=\"4862\" data-end=\"4875\">Answer: B<\/strong><\/p>\n<hr data-start=\"4877\" data-end=\"4880\" \/>\n<h3 data-start=\"4882\" data-end=\"4904\">95. A subquery is:<\/h3>\n<p data-start=\"4905\" data-end=\"4999\">A) Main query<br data-start=\"4918\" data-end=\"4921\" \/>B) Query inside another query<br data-start=\"4950\" data-end=\"4953\" \/>C) Delete statement<br data-start=\"4972\" data-end=\"4975\" \/>D) Index<br data-start=\"4983\" data-end=\"4986\" \/><strong data-start=\"4986\" data-end=\"4999\">Answer: B<\/strong><\/p>\n<hr data-start=\"5001\" data-end=\"5004\" \/>\n<h3 data-start=\"5006\" data-end=\"5036\">96. A primary key must be:<\/h3>\n<p data-start=\"5037\" data-end=\"5119\">A) Duplicate<br data-start=\"5049\" data-end=\"5052\" \/>B) Unique and NOT NULL<br data-start=\"5074\" data-end=\"5077\" \/>C) Optional<br data-start=\"5088\" data-end=\"5091\" \/>D) Text only<br data-start=\"5103\" data-end=\"5106\" \/><strong data-start=\"5106\" data-end=\"5119\">Answer: B<\/strong><\/p>\n<hr data-start=\"5121\" data-end=\"5124\" \/>\n<h3 data-start=\"5126\" data-end=\"5153\">97. A candidate key is:<\/h3>\n<p data-start=\"5154\" data-end=\"5260\">A) Selected primary key<br data-start=\"5177\" data-end=\"5180\" \/>B) Possible primary key<br data-start=\"5203\" data-end=\"5206\" \/>C) Foreign key<br data-start=\"5220\" data-end=\"5223\" \/>D) Composite key only<br data-start=\"5244\" data-end=\"5247\" \/><strong data-start=\"5247\" data-end=\"5260\">Answer: B<\/strong><\/p>\n<hr data-start=\"5262\" data-end=\"5265\" \/>\n<h3 data-start=\"5267\" data-end=\"5314\">98. Which clause removes duplicate records?<\/h3>\n<p data-start=\"5315\" data-end=\"5378\">A) UNIQUE<br data-start=\"5324\" data-end=\"5327\" \/>B) REMOVE<br data-start=\"5336\" data-end=\"5339\" \/>C) DISTINCT<br data-start=\"5350\" data-end=\"5353\" \/>D) FILTER<br data-start=\"5362\" data-end=\"5365\" \/><strong data-start=\"5365\" data-end=\"5378\">Answer: C<\/strong><\/p>\n<hr data-start=\"5380\" data-end=\"5383\" \/>\n<h3 data-start=\"5385\" data-end=\"5411\">99. SQL is considered:<\/h3>\n<p data-start=\"5412\" data-end=\"5513\">A) Procedural language<br data-start=\"5434\" data-end=\"5437\" \/>B) Non-procedural language<br data-start=\"5463\" data-end=\"5466\" \/>C) Programming OS<br data-start=\"5483\" data-end=\"5486\" \/>D) Compiler<br data-start=\"5497\" data-end=\"5500\" \/><strong data-start=\"5500\" data-end=\"5513\">Answer: B<\/strong><\/p>\n<hr data-start=\"5515\" data-end=\"5518\" \/>\n<h3 data-start=\"5520\" data-end=\"5556\">100. The main goal of a DBMS is:<\/h3>\n<p data-start=\"5557\" data-end=\"5675\">A) Delete files<br data-start=\"5572\" data-end=\"5575\" \/>B) Increase hardware cost<br data-start=\"5600\" data-end=\"5603\" \/>C) Efficient and secure data management<br data-start=\"5642\" data-end=\"5645\" \/>D) Format disk<br data-start=\"5659\" data-end=\"5662\" \/><strong data-start=\"5662\" data-end=\"5675\">Answer: C<\/strong><\/p>\n<hr data-start=\"5677\" data-end=\"5680\" \/>\n<pre data-start=\"6288\" data-end=\"6423\">Advertisement:<\/pre>\n<p data-start=\"6288\" data-end=\"6423\"><a href=\"https:\/\/rgsoftwares.com\/school-management-software\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-4867\" src=\"https:\/\/murreeroad.org\/wp-content\/uploads\/2025\/12\/school-management-software-300x300.png\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" srcset=\"https:\/\/murreeroad.org\/wp-content\/uploads\/2025\/12\/school-management-software-300x300.png 300w, https:\/\/murreeroad.org\/wp-content\/uploads\/2025\/12\/school-management-software-1024x1024.png 1024w, https:\/\/murreeroad.org\/wp-content\/uploads\/2025\/12\/school-management-software-150x150.png 150w, https:\/\/murreeroad.org\/wp-content\/uploads\/2025\/12\/school-management-software-768x768.png 768w, https:\/\/murreeroad.org\/wp-content\/uploads\/2025\/12\/school-management-software.png 1080w\" alt=\"school-management-software\" width=\"300\" height=\"300\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>100 Database Management MCQs with Answers (DBMS Multiple Choice Questions for Exams &amp; Interviews). Prepare for exams and interviews with these 100 Database Management MCQs with answers. This comprehensive DBMS question set covers SQL, normalization, keys, ER diagrams, transactions, ACID properties, joins, indexing, and more \u2014 perfect for computer science students, IT exams, and competitive &#8230; <a title=\"100 Database Management MCQs with Answers\" class=\"read-more\" href=\"https:\/\/learn-nest.murreeroad.org\/blog\/100-database-management-mcqs-with-answers\/\" aria-label=\"Read more about 100 Database Management MCQs with Answers\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":5197,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowprK_DA:productID":"","om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2106],"tags":[2634,4041,4049,4045,4047,4037,4050,4032,4034,4044,4033,4035,4042,4046,4038,4040,4039,4036,4051,4048,4043,4052,4053],"class_list":["post-5196","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mcqs","tag-100-mcqs-with-answers","tag-acid-properties-mcqs","tag-bsc-computer-science-dbms-mcqs","tag-computer-science-dbms-quiz","tag-data-modeling-mcqs","tag-database-exam-preparation-questions","tag-database-fundamentals-mcqs","tag-database-management-mcqs","tag-database-management-multiple-choice-questions","tag-dbms-interview-questions","tag-dbms-mcqs-with-answers","tag-dbms-objective-questions","tag-er-diagram-mcqs","tag-it-competitive-exam-dbms-questions","tag-normalization-mcqs","tag-primary-key-and-foreign-key-mcqs","tag-sql-joins-mcqs","tag-sql-mcqs-with-answers","tag-sql-practice-questions","tag-structured-query-language-questions","tag-transaction-management-mcqs","tag-what-does-dbms-stand-for","tag-which-of-the-following-is-a-dbms"],"aioseo_notices":[],"uagb_featured_image_src":{"full":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Database-Management-MCQs-with-Answers.png",1536,1024,false],"thumbnail":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Database-Management-MCQs-with-Answers-150x150.png",150,150,true],"medium":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Database-Management-MCQs-with-Answers-300x200.png",300,200,true],"medium_large":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Database-Management-MCQs-with-Answers-768x512.png",768,512,true],"large":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Database-Management-MCQs-with-Answers-1024x683.png",1024,683,true],"1536x1536":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Database-Management-MCQs-with-Answers.png",1536,1024,false],"2048x2048":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/02\/100-Database-Management-MCQs-with-Answers.png",1536,1024,false]},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/learn-nest.murreeroad.org\/blog\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"100 Database Management MCQs with Answers (DBMS Multiple Choice Questions for Exams &amp; Interviews). Prepare for exams and interviews with these 100 Database Management MCQs with answers. This comprehensive DBMS question set covers SQL, normalization, keys, ER diagrams, transactions, ACID properties, joins, indexing, and more \u2014 perfect for computer science students, IT exams, and competitive&hellip;","_links":{"self":[{"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/posts\/5196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/comments?post=5196"}],"version-history":[{"count":1,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/posts\/5196\/revisions"}],"predecessor-version":[{"id":5198,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/posts\/5196\/revisions\/5198"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/media\/5197"}],"wp:attachment":[{"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/media?parent=5196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/categories?post=5196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/tags?post=5196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}