Aspirant Academy

MCQ

DBMS MCQ - Practice Questions with Answers

Solve 3 DBMS questions for RAS/RPSC preparation.

Practice questions

Q1Let relation R2 has a ‘foreign key’ that refers to primary key of relation R1. Which of the following operation may cause violation of referential integrity constraints?

A Insertion of new tuple into R2
B Deletion of tuple from R1
C Both option (A) and option (B)
D Neither option (A) nor option (B)
Explanation

A foreign key value in the child relation must match an existing primary-key value in the parent relation. Inserting a tuple into R2 can violate this if its foreign key has no matching R1 row, and deleting a tuple from R1 can violate it if R2 still refers to that parent row. Therefore, both operations may violate referential integrity, so option C is correct.

Q2An entity is represented by set of -

A Attributes
B Relationship
C Model
D None
Explanation

In the ER model, an entity is described by a set of attributes. Attributes store the properties of that entity, such as name, roll number, or address for a student entity. Relationships connect entities, so option B does not represent an entity by itself.

Q3Which of the following events is/are exposed by the DataTable object?

A RowChanged
B ColumnChanged
C RowChanging
D All of the above
Explanation

Microsoft's DataTable event list includes RowChanged, ColumnChanged, and RowChanging. Since all three listed events are exposed by the DataTable object, the combined choice is correct. Therefore, option D is correct.

You've seen 3 of 3 sample questions

Unlimited practice on DBMS comes with the RAS Test Series + Practice pack or Gate Pass.

More topics in DBMS & Software Engineering (Senior CI)

Explore other subjects