PrepAway - Latest Free Exam Questions & Answers

which of the following represent implementation procedu…

In regards to the query function of relational database operations, which of the following represent
implementation procedures that correspond to each of the low-level operations in the query?

PrepAway - Latest Free Exam Questions & Answers

A.
query plan

B.
relational plan

C.
database plan

D.
structuring plan

Explanation:
A query plan (or query execution plan) is an ordered set of steps used to access data in a SQL relational
database management system. This is a specific case of the relational model concept of access plans.
Since SQL is declarative, there are typically a large number of alternative ways to execute a given query, with
widely varying performance. When a query is submitted to the database, the query optimizer evaluates some of
the different, correct possible plans for executing the query and returns what it considers the best option.
Incorrect Answers:
B: Relational plan is not the correct term to describe implementation procedures that correspond to each of the
low-level operations in the query.
C: Database plan is not the correct term to describe implementation procedures that correspond to each of the
low-level operations in the query.
D: Structural plan is not the correct term to describe implementation procedures that correspond to each of the
low-level operations in the query.

https://en.wikipedia.org/wiki/Query_plan


Leave a Reply