CS403 Final Term Quiz 3 July 2023 by Miss Mehwish

We also provide Past papers for Mids. and Finals Cross Check your answers before submitting directly from the file. We are not responsible for 100% correction as human error exists

ِِبِسْم · ِِالل · ِِالرَّحْمٰن · ِِالرَّحِيْم

MCQ 1: ____________are the structures defined for placing data in the attributes while designing the physical design of a database. a) Data types b) Variables c) Attributes d) Objects

Correct option: c) Attributes

MCQ 2: If A → B and CB → D, then AC → D. The above rule follows _____________ inference rule. Options: a) Decomposition b) Additivity c) Augmentation d) Pseudo transitivity

Correct option: d) Pseudo transitivity

MCQ 3: Which of the following is NOT related to partitioning and placement in a database? Options: a) Speed up the rate of useful work b) Balance workload c) Reduce workload d) Speed up data transmission

Correct option: d) Speed up data transmission

MCQ 4: Atomicity is a feature of ______. a) BCNF b) 1NF c) 2NF d) 3NF

Correct option: a) BCNF

MCQ 5: Which of the following is a correct syntax of selecting all the columns from a table called PERSONS? Options: a) SELECT * FROM Persons b) SELECT FROM * Persons c) SELECT WHERE * Persons d) SELECT * WHERE Persons

Correct option: a) SELECT * FROM Persons MCQ 6: Denormalization is required to enhance _________. a) Performance b) Sharing of data c) Data transmission d) Data communication

Correct option: a) Performance

MCQ 7: Which of the following is NOT related to data manipulation language? Options: a) Insertion of information b) Retrieval of information c) Modification to the information d) Control access to the information

Correct option: d) Control access to the information

MCQ 8: The database design prevents some data from being stored due to _______. Options: a) Redundancy b) Insertion anomalies c) Deletion anomalies