CS403 Final Term Quiz 3 July 2023 Set 2 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

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

Q1. General reasoning for horizontal or vertical partitioning is: Options:

1. Increasing the consistency
2. Increase data communication
3. Decreasing the query response time
4. Smaller tables are more efficient to process as compared to the larger tables.

Correct option: C) Decreasing the query response time

Q2. ____________ are the structure defined for placing data in the attributes while designing the physical design of the database.

1. Variables
2. Attributes
3. Data types
4. Objects

Correct option: B) Attributes

Q3. Normalization is a process of restructuring a relation to:

1. Maximize duplication of data to ensure reliability
2. Make it of uniform size
3. Allow addition of data
4. Minimize duplication of data in a database

Correct option: D) Minimize duplication of data in a database

Q4. Functional dependencies under reflexivity inference rule are called __________ dependencies. Options:

1. Augmentation
2. Trivial
3. Projectivity
4. Transitivity

Correct option: B) Trivial

Q5. Which of the following is NOT a valid data type in SQL?

1. Capital
2. int
3. Money
4. Text

Correct option: A) Capital

Q6. While converting to 2NF, all the columns are deleted from the original table except for the determinant, which will serve as a ____________ key.

1. Super key
2. Foreign key
3. Primary key
4. Composite key

Correct option: C) Primary key

Q7. Which of the following is one of the purposes of using DDL commands? Options:

1. Updating records into databases
2. Creating and destroying databases
3. Inserting records into databases
4. Manipulating databases

Correct option: B) Creating and destroying databases

Q8. In which of the following situations is clustering more suitable? Options:

1. Access of data is not frequent
2. Relatively static situations