Learn with Anil · TGPSC HMWSSB Manager (Engineering) PYQsPractise online →Subscribe ₹149

TGPSC HMWSSB Manager Database Management Systems previous year questions with answers

Every Database Management Systems question asked in the TGPSC HMWSSB Manager (Engineering) papers on this site, grouped by topic. Answers come from TSPSC's final key; each has a short explanation (free here for a sample, all of them in the practice app).

Practise Database Management Systems online

ER & Relational Model

  1. Manager 2015 Paper 2 (CS & IT) · Q38 · Database Management Systems · ER & Relational Model

    The referential integrity rule requires that

    1. Every null foreign key value must reference an existing primary key value.
    2. It makes it possible for an attribute to have a corresponding value.
    3. Every non-null foreign key value must reference an existing primary key value.
    4. It makes it possible to delete a row in one table whose primary key does not have a matching foreign key value in another table.
    Show answer

    Answer: (3) Every non-null foreign key value must reference an existing primary key value.

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

  2. Manager 2015 Paper 2 (CS & IT) · Q70 · Database Management Systems · ER & Relational Model

    The entity integrity rule requires that

    1. All primary key entries are unique
    2. A part of the key may be null
    3. Foreign key values do not reference primary key values
    4. Duplicate object values are allowed
    Show answer

    Answer: (1) All primary key entries are unique

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

SQL & Relational Algebra

  1. Manager 2015 Paper 2 (CS & IT) · Q34 · Database Management Systems · SQL & Relational Algebra

    Consider relations R(A,B) and S(C,D); and the following SQL query.

    Select distinct A,B,
    from R,S

    Under what conditions the result is guaranteed to be same as R.

    1. R has no duplicate and S is non-empty
    2. R and S have no duplicates
    3. S has no duplicates and R is non-empty
    4. R and S have the same number of tuples
    Show answer

    Answer: (1) R has no duplicate and S is non-empty

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

  2. Manager 2015 Paper 2 (CS & IT) · Q36 · Database Management Systems · SQL & Relational Algebra

    Which one of the following relational algebra transformations is incorrect?

    1. σ_C1(σ_C1(R)) → σ_C2(σ_C2(R))
    2. σ_C(π_A(R)) → π_A(σ_C(R))
    3. σ_C(R ∪ S) → σ_C(R) ∪ σ_C(S)
    4. σ_C(R) → π_A(R)
    Show answer

    Answer: (4) σ_C(R) → π_A(R)

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

  3. Manager 2015 Paper 2 (CS & IT) · Q37 · Database Management Systems · SQL & Relational Algebra

    If relation R has m tuples and S has n tuples, what is the maximum and minimum number of tuples in R ⋈ S?

    1. m + n and 0
    2. mn and 0
    3. m + n and |m − n|
    4. mn and m + n
    Show answer

    Answer: (2) mn and 0

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

Normalisation

  1. Manager 2015 Paper 2 (CS & IT) · Q32 · Database Management Systems · Normalisation

    Which of the following normal forms eliminates the anomalies of multivalued dependencies?

    1. 3NF
    2. BCNF
    3. 4NF
    4. 5NF
    Show answer

    Answer: (3) 4NF

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

  2. Manager 2015 Paper 2 (CS & IT) · Q35 · Database Management Systems · Normalisation

    Let R = (A, B, C, D) and F = {A → B, A → C, BC → D}, then which of the following is correct?

    1. B → D
    2. A → B
    3. A → D
    4. D → A
    Show answer

    Answer: (3) A → D

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

  3. Manager 2015 Paper 2 (CS & IT) · Q39 · Database Management Systems · Normalisation

    Which of the following statements is correct?

    1. Every relation in 2NF is also in BCNF
    2. Every relation in BCNF is also in 3NF
    3. No relation can be in both BCNF and 3NF
    4. Every relation is ZNF is also in 3 NF
    Show answer

    Answer: (2) Every relation in BCNF is also in 3NF

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

Transactions, Concurrency & Indexing

  1. Manager 2015 Paper 2 (CS & IT) · Q33 · Database Management Systems · Transactions, Concurrency & Indexing

    Which one of the following state transitions is made when the transaction has been rolled back and the database is restored to the state prior to the start of the transition?

    1. Active→Partially Committed
    2. Active→Committed
    3. Active→Aborted
    4. Partially Committed→Committed
    Show answer

    Answer: (3) Active→Aborted

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

  2. Manager 2015 Paper 2 (CS & IT) · Q40 · Database Management Systems · Transactions, Concurrency & Indexing

    Consider the schedule S and determine which one of the following schedules is conflict equivalent schedule to S. S: R₁(X); R₂(Z); R₁(Z); R₃(X); R₃(Y); W₁(X); W₃(Y); R₂(Y); W₂(Z); W₂(Y)

    1. T1→T2→T3
    2. T2→T1→T3
    3. T3→T1→T2
    4. T3→T2→T1
    Show answer

    Answer: (3) T3→T1→T2

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.

  3. Manager 2015 Paper 2 (CS & IT) · Q41 · Database Management Systems · Transactions, Concurrency & Indexing

    Which one of the following file organization techniques provides very fast direct access?

    1. Hashed File Organization
    2. B-Tree Organization
    3. B+ Tree Organization
    4. Indexed-Sequential File Organization
    Show answer

    Answer: (1) Hashed File Organization

    Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.