221. | In SQL, .................. is an Aggregate function. |
a. | SELECT |
b. | CREATE |
c. | AVG |
d. | MODIFY |
View Answer Report Discuss Too Difficult! |
Answer: (c).AVG
|
222. | Match the following with respect to RDBMS:
List - I (a) Entity integrity (b) Domain integrity (c) Referential integrity (d) Userdefined integrity List - II (i) enforces some specific business rule that do not fall into entity or domain (ii) Rows can't be deleted which are used by other records (iii) enforces valid entries for a column (iv) No duplicate rows in a table Code: (a) (b) (c) (d) |
a. | (iii) (iv) (i) (ii) |
b. | (iv) (iii) (ii) (i) |
c. | (iv) (ii) (iii) (i) |
d. | (ii) (iii) (iv) (i) |
View Answer Report Discuss Too Difficult! |
Answer: (b).(iv) (iii) (ii) (i)
|
223. | In RDBMS, different classes of relations are created using ................... technique to prevent modification anomalies. |
a. | Functional Dependencies |
b. | Data integrity |
c. | Referential integrity |
d. | Normal Forms |
View Answer Report Discuss Too Difficult! |
Answer: (d).Normal Forms
|
224. | .................. SQL command changes one or more fields in a record. |
a. | LOOK-UP |
b. | INSERT |
c. | MODIFY |
d. | CHANGE |
View Answer Report Discuss Too Difficult! |
Answer: (c).MODIFY
|
225. | If every non-key attribute is functionally dependent on the primary key, then the relation is in .................... |
a. | First normal form |
b. | Second normal form |
c. | Third normal form |
d. | Fourth normal form |
View Answer Report Discuss Too Difficult! |
Answer: (c).Third normal form
|
226. | Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.
CH → G A → BC B → CFH E → A F → EG The relation R is .................... |
a. | in 1NF but not in 2NF |
b. | in 2NF but not in 3NF |
c. | in 3NF but not in BCNF |
d. | in BCNF |
View Answer Report Discuss Too Difficult! |
Answer: (a).in 1NF but not in 2NF
|
227. | Given two relations R1(A, B) and R2(C, D), the result of following query
Select distinct A, B from R1, R2 is guaranteed to be same as R1 provided one of the following condition is satisfied. |
a. | R1 has no duplicates and R2 is empty. |
b. | R1 has no duplicates and R2 is non - empty. |
c. | Both R1 and R2 have no duplicates. |
d. | R2 has no duplicates and R1 is non - empty. |
View Answer Report Discuss Too Difficult! |
Answer: (b).R1 has no duplicates and R2 is non - empty.
|
228. | Consider a schema R(A, B, C, D) and following functional dependencies.
A → B B → C C → D D → B Then decomposition of R into R1(A, B), R2(B, C) and R3(B, D) is .................. |
a. | Dependency preserving and lossless join. |
b. | Lossless join but not dependency preserving. |
c. | Dependency preserving but not lossless join. |
d. | Not dependency preserving and not lossless join. |
View Answer Report Discuss Too Difficult! |
Answer: (a).Dependency preserving and lossless join.
|