MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following are steps in query processing?
A
Parsing and translation
B
Optimization
C
Evaluation
D
All of the mentioned
Explanation: 

Detailed explanation-1: -Which of the following are steps in query processing? Explanation: Parsing and translation, optimization, evaluation are all the basic steps to process a query.

Detailed explanation-2: -Query Processing is a translation of high-level queries into low-level expression. It is a step wise process that can be used at the physical level of the file system, query optimization and actual execution of the query to get the result. It requires the basic concepts of relational algebra and file structure.

Detailed explanation-3: -The first step in query processing is Parsing and Translation.

Detailed explanation-4: -Three different phases during the query processing in DBMS which are as follows: • Parsing and translation • Optimization • Evaluation. Usually, user queries are submitted to DBMS as SQL queries. During the parsing and translation phase, the given query is translated into its internal form.

There is 1 question to complete.