BPSC TRE – DBMS | Full Length Mock Test 2 ⋆ CSE Study247

BPSC TRE – DBMS | Full Length Mock Test 2

Questions 11-15 of 100

0% completed (0/100 answered)

Question 11

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 2.0 PYQ

In an Entity-Relationship (ER) diagram, what does a double diamond represent?

A (A) A strong entity set participating totally in a relationship B (B) Multi-valued attribute set C (C) Total participation constraint of strong entities D (D) More than one of the above E (E) None of the above

Question 12

MCQ · Single Correct 1 mark

In EER modeling, the bottom-up process of synthesizing multiple entity sets with common features into a higher-level entity set is termed:

A (A) Aggregation B (B) Specialization C (C) Decomposition D (D) More than one of the above E (E) None of the above

Question 13

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 3.0 PYQ

In an ER diagram, an abstraction through which relationships are treated as higher-level entities is called:

A (A) Aggregation B (B) Realization C (C) Specialization D (D) More than one of the above E (E) None of the above

Question 14

MCQ · Single Correct 1 mark

If an entity can belong to at most one subclass within a specialization hierarchy, the constraint is classified as:

A (A) Partial participation constraint B (B) Disjoint constraint C (C) Overlapping constraint D (D) More than one of the above E (E) None of the above

Question 15

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 1.0 PYQ

Which of the following attributes cannot be broken down into simpler constituent components?

A (A) Multivalued attribute B (B) Composite attribute C (C) Atomic attribute D (D) More than one of the above E (E) None of the above