Q.1 In the relational modes, cardinality is termed as:(A) Number of tuples. (B) Number of attributes.(C) Number of tables. (D) Number of constraints.Ans: A
Q.2 A data dictionary has consolidated list of data contained in(i) dataflows (ii) data stores (iii) data outputs (iv) processesa. (i) and (iii)b. (i) and (ii)c. (ii) and (iv)d. (i) and (iv)Ans: b
Q.3 Relational calculus is a(A) Procedural language. (B) Non-Procedural language.(C) Data definition language. (D) High level language.Ans: B
Q.4 A data dictionary is useful as(i) it is a documentation aid(ii) it assists in designing input forms(iii) it contains al data in an application including temporary data used in processes(iv) it is a good idea in system designa. (i) and (ii)b. (i) and (iv)c. (i),(ii) and (iii)d. (i) and (iv)Ans.: c
Q.5 The view of total database content is (A) Conceptual view. (B) Internal view. (C) External view. (D) Physical View. Ans: A
Q.6 By metadata we mean a. very large data b. data about data c. data dictionary d. meaningful data Ans: b
Q.7 Cartesian product in relational algebra is (A) a Unary operator. (B) a Binary operator. (C) a Ternary operator. (D) not defined. Ans: B Cartesian product in relational algebra is a binary operator. (It requires two operands. e.g., P X Q)
Q.8 A data dictionary is usually developed a. At requirements specification phase b. During feasibility analysis c. When DFD is developed d. When a datadase is designedAns: c
No comments:
Post a Comment