CS614 Quiz 1 Set 2

Q1. De-normalization may be in the form of, combining tables, adding data or _____________.

1. Duplicating tables
2. Sharing tables
3. Deleting tables
4. Splitting tables

Correct answer: Splitting tables

Q2. The main goal of normalization is to eliminate ____________.

1. Data sharing
2. Data consistency
3. Data security
4. Data redundancy

Correct answer: Data redundancy

Q3. This technique can be used when a column from one table is frequently accessed in a large scale join in conjunction with a column from another table.

1. Derived attributes
2. Horizontal splitting
3. Adding redundant column
4. Pre-joining

Correct answer: Adding redundant column

Q4. Which of the following is not a technique of ‘De-Normalization’?

1. ER Modeling
2. Splitting Tables
3. Pre-joining
4. Adding Redundant Columns

Correct answer: ER Modeling

Q5. For good decision making, one should be able to integrate data across the organization to give the _____________ of organization.

1. Brief view
2. Partial view
3. Undermine view
4. Total view

Correct answer: Total view

Q6. The relation R will be in 2nd Normal Form if

1. It is in 1NF and Primary key is composite.
2. It is in 1NF and each non key attribute is dependent upon entire primary key.
3. It is in 1NF and each non key attribute is dependent upon a single column of composite primary key.
4. It is in 1NF and each cell contains single value.

Correct answer: It is in 1NF and each non key attribute is dependent upon entire primary key.

Q7. Identify data warehouse query from the following:

1. Total number of students that have 3.5 CGPA
2. Factors which can affect students’ performance
3. List of students belong to Lahore city
4. Number of students studying CS614 course

Correct answer: Factors which can affect students’ performance

Q8. Table collapsing technique is applied in case of:

1. Many-to-one relation
2. One-to-one relation or many-to-many relation
3. One-to-many relation
4. None of the given options

Correct answer: One-to-one relation or many-to-many relation

Q9. _______________ segregates data into separate partitions so that queries do not need to examine all data in the table.

1. Pre-joining technique
2. Collapsing tables technique
3. Vertical splitting technique
4. Horizontal splitting technique

Correct answer: Horizontal splitting technique

Q10. _______ can be used when some columns are rarely accessed rather than other columns or when the table has wide rows or header or both.

1. Derived attributes
2. Horizontal splitting
3. Pre-joining
4. Vertical splitting

Correct answer: Vertical splitting