MCQ

DBMS, SAD & IoT (Basic CI) MCQ - Practice Questions

Practice 183 questions across 4 topics with detailed explanations.

183Questions

4Topics

3Difficulty levels

Topics in DBMS, SAD & IoT (Basic CI)

Paper - II (x) — Database Management System 56 questions Paper - II (xi) — System Analysis and Design 56 questions Paper - II (xii) — Internet of things and its application 56 questions Database 15 questions

Sample questions

1For a banking application that requires strict transactions, fixed relationships, and strong consistency for account balances, which database choice is generally most suitable?

A Relational database management system

B Image gallery software

C A cache used as the only permanent data store

D Plain text files without constraints

2A project has high technical uncertainty, a high cost of late failure, and stakeholders want repeated risk review before committing to the next build. Which development approach is the best conceptual fit?

A Big-bang model with no planned milestones

B Pure waterfall with all requirements frozen before any risk analysis

C Spiral model with iterative risk analysis before each major cycle

D One-time throwaway prototyping with no later engineering cycle

3A browser-based video conferencing system should allow audio and video communication without installing a separate plug-in. Which web technology is most directly associated with this requirement?

A robots.txt

B WebRTC

C XML namespace declaration

D SMTP relay

4A college wants to replace its admission system. The proposed biometric device is available, the database can handle expected load, and the project can be built by the IT team. However, admission rules are changed every year by regulation, and the proposed system hard-codes all eligibility rules. Which feasibility concern is most directly threatened?

A Technical feasibility, because the server and biometric device may not exist

B Operational feasibility, because the system is unlikely to fit changing institutional procedures

C Schedule feasibility, because rule changes prove that coding cannot start on time

D Economic feasibility, because biometric devices are always costlier than manual verification

5An application mainly needs fixed relationships, joins between tables, and strict referential integrity. Which database choice is generally most suitable?

A Object cache only

B Document database only

C Relational database management system

D Key-value store only

Topics in DBMS, SAD & IoT (Basic CI)

Sample questions

Explore more subjects