SQL Objective Type Question and Answers

Database Objective Type  Question and Answers

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) processes

a. (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 design

a. (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 designed

Ans: c