Bank IT OFFICER / Specialist Exam PracticePaper -7 (DBMS -Database Management Systems )

1 In SQL the statement select * from R, S is equivalent to
(A) Select * from R natural join S. (B) Select * from R cross join S.
(C) Select * from R union join S. (D) Select * from R inner join S.


2 Which of the following is not a consequence of concurrent operations?
(A) Lost update problem. (B) Update anomaly.
(C) Unrepeatable read. (D) Dirty read.


3 As per equivalence rules for query transformation, selection operation distributes over
(A) Union. (B) Intersection.
(C) Set difference. (D) All of the above.


4 The metadata is created by the
(A) DML compiler (B) DML pre-processor
(C) DDL interpreter (D) Query interpreter


5 When an E-R diagram is mapped to tables, the representation is redundant for
(A) weak entity sets (B) weak relationship sets
(C) strong entity sets (D) strong relationship sets


6 When ∩ S = φ R , then the cost of computing R >< S is
 (A) the same as R × S (B) greater the R × S (C) less than R × S (D) cannot say anything
 

7 .In SQL the word ‘natural’ can be used with
(A) inner join (B) full outer join
(C) right outer join (D) all of the above


8 The default level of consistency in SQL is
(A) repeatable read (B) read committed
(C) read uncommitted (D) serializable


9 If a transaction T has obtained an exclusive lock on item Q, then T can
(A) read Q (B) write Q
(C) both read and write Q (D) write Q but not read Q


10 .Shadow paging has
(A) no redo (B) no undo
(C) redo but no undo (D) neither redo nor undo


11 . If the closure of an attribute set is the entire relation then the attribute set is a
(A) superkey (B) candidate key
(C) primary key (D) not a key


12 .DROP is a ______________ statement in SQL.
(A) Query (B) Embedded SQL
(C) DDL (D) DCL


13 .If two relations R and S are joined, then the non matching tuples of both R and S are
ignored in
(A) left outer join (B) right outer join
(C) full outer join (D) inner join


14 . The keyword to eliminate duplicate rows from the query result in SQL is
(A) DISTINCT (B) NO DUPLICATE
(C) UNIQUE (D) None of the above
`

15 .In 2NF
(A) No functional dependencies (FDs) exist.
(B) No multivalued dependencies (MVDs) exist.
(C) No partial FDs exist.
(D) No partial MVDs exist. AC14/AT11


16 . Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) Changing storage medium
(A) (i) and (ii) (B) (iv) only, (C) (i) and (iv) (D) (ii) and (iii)


17 . In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the
following is incorrect :
(A) Operationally, if Y is deleted, so is X
(B) existence is dependent on Y.
(C) Operationally, if X is deleted, so is Y.
(D) Operationally, if X is deleted, & remains the same.


18 .Relational Algebra is
(A) Data Definition Language .
(B) Meta Language
(C) Procedural query Language
(D) None of the above


19. Which of the following aggregate functions does not ignore nulls in its results?.
(A) COUNT . (B) COUNT (*)
(C) MAX (D) MIN


20 .R (A,B,C,D) is a relation. Which of the following does not have a lossless join
dependency preserving BCNF decomposition
(A) A B, B CD (B) A B, B C, C D .
(C) AB C, C AD (D) A BCD