DBMS & Software Engineering (Senior CI) MCQ — Practice Questions for RAS Exam

DBMS & Software Engineering (Senior CI) is a crucial component of the RAS/RPSC exam syllabus. Practice 98 multiple-choice questions across 4 topics with detailed explanations to strengthen your preparation.

Total Questions

Topics Covered

Difficulty Levels

Topics in DBMS & Software Engineering (Senior CI)

Paper - II (xi) — Database Management System

44 questions

Paper - II (xii) — Software Engineering

44 questions

Software Engineering

7 questions

DBMS

3 questions

Sample Questions

Try these DBMS & Software Engineering (Senior CI) questions. Click "Show Answer" to reveal the explanation.

A 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.

In 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.

Which 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.

A 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

A 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

Ready to Practice DBMS & Software Engineering (Senior CI)?

Test your knowledge with 98 questions. Choose your difficulty, set the question count, and start practicing.

Frequently Asked Questions

How many DBMS & Software Engineering (Senior CI) MCQ questions are available for RAS preparation?

Aspirant Academy offers 98 DBMS & Software Engineering (Senior CI) multiple-choice questions across 4 topics, designed specifically for RAS/RPSC exam preparation.

What topics are covered under DBMS & Software Engineering (Senior CI)?

The DBMS & Software Engineering (Senior CI) section covers 4 topics including Paper - II (xi) — Database Management System, Paper - II (xii) — Software Engineering, Software Engineering, DBMS. Each topic contains practice MCQs with detailed explanations.

Are the DBMS & Software Engineering (Senior CI) MCQs aligned with the RAS/RPSC syllabus?

Yes, all DBMS & Software Engineering (Senior CI) questions are curated to match the official RAS/RPSC exam syllabus and pattern. Questions cover the difficulty levels you can expect in the actual exam.

Are detailed explanations provided for DBMS & Software Engineering (Senior CI) MCQs?

Yes, every question includes a detailed explanation of the correct answer, helping you understand the concept rather than just memorize answers.

Can I practice DBMS & Software Engineering (Senior CI) MCQs in Hindi?

Yes, Aspirant Academy supports bilingual practice. You can switch between English and Hindi for DBMS & Software Engineering (Senior CI) questions, options, and explanations.

Explore More Subjects

The RAS/RPSC exam covers a wide range of subjects. Strengthen your overall preparation by practicing across all areas.

Current Affairs Reasoning & Mental Ability Indian Economy Science & Technology Indian Constitution & Governance Rajasthan History, Art & Culture Environment & Ecology Geography of Rajasthan Indian History (Ancient & Medieval) General Hindi child-development-pedagogy Geography of India Indian History (Modern) Economy of Rajasthan General English social-studies Rajasthan Political & Administrative System World Geography Basic Computer Soc Sci Part-I Sec/Sr.Sec (Senior Teacher) Sanskrit Part-I Sec/Sr.Sec (Senior Teacher) Science Part-II Graduation (Senior Teacher) Hindi Part-I Secondary/Sr.Sec (Senior Teacher) Science Part-I Secondary/Sr.Sec (Sr Teacher) Maths Part-I Secondary/Sr.Sec (Senior Teacher) PE Theory & Methods (PTI Paper-II) English Part-I Secondary/Sr.Sec (Sr Teacher) Maths Part-II Graduation (Senior Teacher) Hindi Part-II Graduation (Senior Teacher) Sanskrit Part-II Graduation (Senior Teacher) Soc Sci Part-II Graduation (Senior Teacher) Maths Part-III Teaching Methods (Senior Teacher) Sanskrit Part-III Teaching Methods (Sr Teacher) English Part-II Graduation (Senior Teacher) Hindi Part-III Teaching Methods (Sr Teacher) Soc Sci Part-III Teaching Methods (Sr Teacher) Computer Systems (Senior CI) Programming & Data Structures (Senior CI) Nutrition & Health (Mahila Supervisor) English Part-III Teaching Methods (Sr Teacher) mathematics-science Physical Education GK (PTI Paper-II) Networking & Web (Senior CI) Sports & PE Applications (PTI Paper-II) Science Part-III Teaching Methods (Sr Teacher) language-hindi Anatomy, Physiology & Health (PTI Paper-II) DBMS, SAD & IoT (Basic CI) language-english Computer Pedagogy & Fundamentals (Senior CI) Networking & Security (Basic CI) Educational Psychology (Senior Teacher) Data Structures & Organization (Basic CI) Recreation, Camp & Yoga (PTI Paper-II) Everyday Science (Vanpal) Mathematics (Vanpal) environmental-studies language-sanskrit mathematics-elementary Data Processing & Programming (Basic CI) Early Childhood Care & Edu (Mahila Sup) Managerial Aptitude (Mahila Supervisor) Environment Economy Science and Technology Polity International Relations Sports Rajasthan Current Affairs Governance Rajasthan Polity and Governance Geography Rajasthan GK Defence