CS614 Quiz 1 Set 3

Q1. Consider the following Student table and identify the column which causes that the table is not in first normal form (1NF). Student (Std_ID, Std_Name, Std_CGPA, Std_Hobbies)

1. Std_ID
2. Std_Hobbies
3. Std_Name
4. Std_CGPA

Correct answer: Std_Hobbies

Q2. Which one among the following is not an advantage of horizontal splitting?

1. Increase I/O Overhead
2. Organize tables for different queries
3. Fast data retrieval
4. Enhance security

Correct answer: Increase I/O Overhead

Q3. ____________ is applicable in Profitability analysis.

1. Information System (IS)
2. Management Information System (MIS)
3. OLTP
4. Data warehouse

Correct answer: Data warehouse

Q4. One goal of horizontal splitting is spreading rows of a table for exploiting ___________.

1. Randomness
2. Parallelism
3. All of the given options
4. Sequentialism

Correct answer: Parallelism

Q5. In ________ nested-loop join of quadratic time complexity does not hurt the performance

1. OLAP
2. Typical OLTP environments
3. DSS
4. Data warehouse

Correct answer: Typical OLTP environments

Q6. Ad-hoc access of data warehouse means:

1. That could be accessed by any user
2. That have predefined database access pattern
3. That could not be accessed by any user
4. That does not have predefined database access pattern

Correct answer: That does not have predefined database access pattern

Q7. Decision support system (DSS) is a/an _________________.

1. Collection of relational database management systems
2. Interactive system which enable decision makers to use databases and solve un-structured problems
3. Decision tree where each node represent a decision
4. Single database of an organization

Correct answer: Interactive system which enable decision makers to use databases and solve un-structured problems

Q8. One of the fundamental purpose of de-normalization is to _____________ a number of physical tables which ultimately reduce the number of joins to answer a query.

1. Decrease
2. Increase
3. Delete
4. Share

Correct answer: Decrease

Q9. In a fully normalized database, too many _____________ are required.

1. Values
2. Joins
3. Queries
4. Conditions

Correct answer: Joins

Q10. Data warehouse stores _____________.

1. Log files data
2. Operational data
3. Meta data
4. Historical Data

Correct answer: Historical Data