In the processing of an SQL statement by the DBMS,a relational algebra query is the output of:
A) Code generation
B) Query transformation
C) Syntax and semantics analysis
D) Access plan evaluation

Question

Quizplus · Accepted Answer

Relational algebra query is the output of query transformation, which involves converting the SQL statement into an equivalent form that can be executed by the DBMS. Code generation involves generating executable code, syntax and semantics analysis involves checking the syntax and meaning of the SQL statement, and access plan evaluation involves optimizing the execution plan for the query.

In the Processing of an SQL Statement by the DBMS,a