MCQ

DBMS & Software Engineering (Senior CI) MCQ - Practice Questions

Practice 98 questions across 3 topics with detailed explanations.

98Questions

3Topics

3Difficulty levels

Topics in DBMS & Software Engineering (Senior CI)

Paper - II (xii) — Software Engineering 51 questions Paper - II (xi) — Database Management System 44 questions DBMS 3 questions

Sample questions

1A Software Requirements Specification states: "The system shall respond quickly to every search request." Which criticism best explains why this requirement is weak?

A It is ambiguous because "quickly" does not define an objective response-time criterion.

B It should be moved to the design document because response time is never part of requirements.

C It describes a non-functional property rather than a functional service.

D It is invalid because an SRS may contain only data-flow diagrams and no textual requirements.

2In SQL integrity enforcement, which requirement is normally better expressed by a declarative constraint rather than a trigger?

A Populate a denormalized monthly summary after each invoice insert.

B Reject a row after comparing it with a dynamically computed aggregate over the table.

C Every order row must reference an existing customer row.

D Write an audit row with the old and new salary whenever salary changes.

3Which statement best distinguishes basic two-phase locking from strict two-phase locking in transaction processing?

A Strict two-phase locking holds exclusive locks until commit or abort, reducing cascading aborts beyond basic two-phase locking.

B Basic two-phase locking permits a transaction to acquire locks after it has released a lock; strict two-phase locking forbids locks entirely.

C Strict two-phase locking releases all shared locks immediately after each read operation.

D Basic two-phase locking guarantees view serializability but never conflict serializability.

4A trigger maintains Summary(total_marks) after inserts into Marks(student_id, paper_id, marks). Which design choice best avoids multi-row statement errors in an RDBMS that supports statement-level transition tables?

A Use a statement-level trigger that aggregates all inserted rows from the transition table and applies one grouped update per student

B Use an AFTER DELETE trigger, because insert effects are visible only after deletion

C Use a row-level trigger but read only the first inserted row from the base table

D Use a CHECK constraint on Summary.total_marks to compute the aggregate

5A database designer wants a rule that checks a cross-row business condition after each affected row is changed, but the check may be deferred until transaction commit. Which mechanism is the best fit in an SQL RDBMS that supports it?

A A unique index on the changed column

B A deferrable row-level constraint trigger

C A simple CHECK constraint with only column comparisons

D A NOT NULL column constraint

Topics in DBMS & Software Engineering (Senior CI)

Sample questions

Explore more subjects