Measures of Query Cost Multiple Choice Questions (MCQ) PDF Download

MCQ 1: Tin the query-evaluation plan, the response time is merely dependent on the contents of the

1. Queue
2. Disk
3. Buffer
4. Pipeline

MCQ 2: For a query the evaluation plans can be

1. 1 only
2. 2 only
3. Multiple
4. 0

MCQ 3: In the query-evaluation plan, the wall-clock time required to execute the plan is called the

1. Response time
2. Latency time
3. Queuing time
4. Buffer time

MCQ 4: Instead of minimizing the response time, optimizers can minimize a query plan's

1. Disk usage
2. Resource consumption
3. Pipeline size
4. Indices length

MCQ 5: The cost of evaluation of query can be measured in terms of different resources, disk accesses and

1. CPU time
2. Distributed or parallel database system
3. Cost of communication
4. All of the above