DBMS- Query, Transaction and Serurity Management Questions and Answers

Practice Mode
Showing 10 of 16 questions
Q1
Query processing is the procedure of selecting the most appropriate plan that is used in responding to a database request
  • A TRUE
  • B FALSE
Answer: Option A
Q2
Execution plan is a series of query complication steps.
  • A TRUE
  • B FALSE
Answer: Option A
Q3
The cost of processing a query is usually dominated by secondary storage access, which is slow compared to memory access.
  • A TRUE
  • B FALSE
Answer: Option A
Q4
The transformed query is used to create a number of strategies called execution (or access) plans.
  • A TRUE
  • B FALSE
Answer: Option A
Q5
The internal query representation is usually a binary query tree.
  • A TRUE
  • B FALSE
Answer: Option A
Q6
A Query is contradictory if its predicate cannot be satisfied by any tuple in the relation(s).
  • A TRUE
  • B FALSE
Answer: Option A
Q7
In which phase of the query processing are the queries that are incorrectly formulated or are contradictory are rejected ?
  • A TRUE
  • B FALSE
Answer: Option A
Q8
Heurisitic rules are used as an optimization technique to modify the internal representation of a query.
  • A TRUE
  • B FALSE
Answer: Option A
Q9
Transformation rules are used by the query optimiser to transform one relational algebra expression into an equivalent expression that is more efficient to execute.
  • A TRUE
  • B FALSE
Answer: Option A
Q10
Systematic query optimization is used for estimation of the cost of different execution strategies and choosing the execution plan with the lowest cost estimate.
  • A TRUE
  • B FALSE
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