CS409 Quiz 3 Jan 2026

Quiz 1 - CS409

Question:

________ are the basic unit of data storage in an Oracle Database.

A. Tables

B. Data C. Index D. Views Copied: 1/2/2026, 8:32:45 PM

Quiz 2 - CS409

Question:

The database can _______ space within an index block.

A. Update

B. Reuse

C. Insert D. Delete Copied: 1/2/2026, 8:32:59 PM

Quiz 3 - CS614

Question:

In case of multiple sources for the same data element, we need to prioritize the source systems per element bases, the process is called:

A. Element Selection

B. Ranking

C. Prioritization

D. Measurement Selection Copied: 1/2/2026, 8:33:28 PM

Quiz 4 - CS614

Question:

Which is the most complex type of transformation in the following?

1. One-to-one scalar transformation
2. Many-to-many element transformation
3. One-to-many element transformation
4. All the given option

Correct answer: Many-to-many element transformation

Copied: 1/2/2026, 8:34:14 PM

Quiz 5 - CS614

Question:

As the number of processors increase, the speedup should also increase. Thus we should have linear speedup. Which of the following is NOT one of the barriers to achieve this linear speed-up?

1. Startup
2. Amdahl’ Law
3. No Interference
4. Skew

Correct answer: Amdahl’ Law

Copied: 1/2/2026, 8:34:53 PM

Quiz 6 - CS614

Question:

Which Logical Data Extraction has significant performance impacts on the data warehouse server?

1. Offline Extraction
2. Legacy vs. OLTP
3. Incremental Extraction
4. Online Extraction

Correct answer: Online Extraction

Copied: 1/2/2026, 8:35:32 PM

Quiz 7 - CS614

Question:

Which of the following is not an activity of Data Quality Analysis Project?

1. “Compression”
2. “Measure”
3. “Define”
4. “Analyze”

Correct answer: “Compression”

Copied: 1/2/2026, 8:36:08 PM

Quiz 8 - CS614

Question:

Most DWH implementations today do not use ______________ enforced by the database, but as TQM methods improve overall data quality and database optimizers.