CS614 Quiz 1 by Arsal Shani and Aina Malik

CS614 QUIZ 1

& MCS FAMILY GROUP TEAM

Q1. _____ is known as state of being only one of its kinds or being without an equal or parallel.

1. Completeness
2. Uniqueness 185
3. Accessibility
4. Consistency

Q2. One of the preconditions to decide about operations to be parallelized is that;

1. Operations can be implemented independent of each other. Page 201
2. Output of one operation become input of other
3. Operations share same memory location
4. Operations share same namespace

Q3. In context of joining tables, the join condition is specified in _____ clause

1. FROM
2. SELECT
3. WHERE page 239
4. GROUP BY

Q4. _______ do not (typically) keep the index values in sorted order

1. Dense index
2. Sparse index
3. B- Tree index
4. Hash based index page 227

Q5. In _____ index , the ith bit is set to “1” if the ith row of the base table has the value for the indexed column.

1. Inverted index
2. Bitmap index page 233
3. Cluster index
4. Join index

Q6. Parallelism can be exploited , if there is:

1. Symmetric multi-processors (SMP)
2. Sufficient I/O bandwidth
3. Underutilized or intermittently used CPUs
4. All of the given options page 202

Q7. _________ is the degree to which data accurately reflects the real-world object that the data represents.

1. Intrinsic Data Quality page 181
2. Realistic Data Quality
3. String Data Quality
4. Weak Data Quality

Q8. ________ is making all efforts to increase effectiveness and efficiency in meeting accepted customer expectations.

1. Quality assurance
2. Quality improvement page 183
3. Quality maintenance
4. Quality establishment

Q9. “More resources means proportionally less time for given amount of data”. The statement refers to:

1. Scale-up
2. Speed-up page 203
3. Size-up
4. Over-utilized system

Q10. Which of the following is NOT one of the parallel hardware architecture?

1. Symmetric Multi-Processing
2. Massively Parallel Processing
3. Non-uniform Memory Access
4. Shared Memory page 206
5. __________ is the extent to which data is regarded as true and credible.