DBMS-Query Processing and Optimization Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q1
During the query processing the syntax of the query is checked by
  • A parser
  • B compiler
  • C syntax checker
  • D none of these
Answer: Option A
Q2
A query execution strategy is evaluated by
  • A access or execution plan
  • B query tree
  • C database catalog
  • D none of these
Answer: Option A
Q3
The first phase of query processing is
  • A decomposition
  • B restructuring
  • C analysis
  • D none of these
Answer: Option A
Q4
In which phase of the query processing is the query lexically nd syntactically analysed using prsers to find out any syntax errors ?
  • A Normalization
  • B semantic analysis
  • C analysis
  • D all of these
Answer: Option C
Q5
Which of the following represents the results of a query in a query tree ?
  • A root node
  • B leaf node
  • C intermediate node
  • D none of these
Answer: Option A
Q6
Which of the following represents the result of a query in a query tree ?
  • A root node
  • B leaf node
  • C intermediate node
  • D none of these
Answer: Option A
Q7
In which of the query processing are the queries that are incorrectly formulated or are contradictory are rejected ?
  • A simplification
  • B semantic analysis
  • C analysis.
  • D none of these
Answer: Option C
Q8
The objective of  query simplifier is
  • A transformation of the query to a semantically equivalent and more efficient form.
  • B detection of redundant qualifications
  • C elimination of common sub-expressions.
  • D all of these.
Answer: Option D
Q9
The objective of query simplifier is
  • A transformation of the query to a semantically equivalent and more efficient form.
  • B detection of redundant qualifications.
  • C elimination of common sub-expressions
  • D all of these
Answer: Option D
Q10
Which of the following will produce and efficient execution strategy ?
  • A performing Projection operations as early as possible.
  • B performing Selection operations as early as possible
  • C computing common expressions only once
  • D all of these
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test