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

Question 16

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 2.0 PYQ

Which of the following is an example of a derived attribute in a database relation?

A (A) Total_Marks computed from individual subject marks B (B) Age computed from Date_of_Birth and Current_Date C (C) Years_of_Service computed from Joining_Date D (D) More than one of the above E (E) None of the above

Question 17

MCQ · Single Correct 1 mark

When mapping a 1:1 binary relationship with total participation on one side (say E1) into relations, what is the most efficient schema design?

A (A) Embed the primary key of E2 as a foreign key in the table for E1 with a NOT NULL constraint B (B) Embed the primary key of E1 into E2 without NOT NULL constraint C (C) Always create a third separate junction table D (D) More than one of the above E (E) None of the above

Question 18

MCQ · Single Correct 1 mark

When mapping a multi-valued attribute of an entity into the relational model, how is it represented?

A (A) By storing a comma-separated string in a single column of the parent table B (B) As a separate relation containing the entity's primary key and the multi-valued attribute itself C (C) By allocating 10 fixed extra columns in the parent table D (D) More than one of the above E (E) None of the above

Question 19

MCQ · Single Correct 1 mark

Previous Year Question BPSC TRE 3.0 PYQ

Which of the following rules is part of E.F. Codd’s 12 Rules for Relational Databases?

A (A) Rule 6: View Updating Rule B (B) Rule 3: Systematic Treatment of Null Values C (C) Rule 1: The Information Rule (all information is represented explicitly at the logical level by values in tables) D (D) More than one of the above E (E) None of the above

Question 20

MCQ · Single Correct 1 mark

Which relational algebra operation produces all possible concatenated pairs of tuples from two relations regardless of common attributes?

A (A) Division (÷) B (B) Semi-Join (⋉) C (C) Natural Join (⋈) D (D) More than one of the above E (E) None of the above