CS403 Quiz 3 by Iqra Azhar

If A -> B and A -> C, then A -> BC The Inference Rule applies is;

union

Which of the following is NOT the type of horizontal partitioning?

Denormalization is required to enhance _________.Select the correct option Performance

Data transmission · Data communication · Sharing of data · Performance

Data type “BLOB” in database management system stands for ________________. Binary Large Object.

Denormalization process is applied for developing a physical data model from_______. Select the correct option

An object oriented data model · A logical data model · A semantic data model · A conceptual form · A logical data model

________________ is state of database where a “course” cannot be inserted in the table, because this course has not been registered to any “student”.

referential integrity constraint violation

Which of the following normal form deals with possible loss less decompositions?

5NF

____________ are used by database administrator in situations where we have large number of records and wastage of small amount of space in each record can lead to loss of huge amount of data storage space.

codes

Which of the following is NOT the valid data type in SQL?Select the correct option Smallint

Money · Capitalint · Text · "Capitalint"