DBMS- Query, Transaction and Serurity Management Questions and Answers
The DBMS - Query, Transaction, and Security Management questions with answers focus on the advanced areas of database management systems crucial for programming and software development. Students preparing for DBMS programming questions and answers can learn about SQL queries, ACID properties, concurrency control, and database security models. These topics are frequently covered in TCS, Infosys, and Tech Mahindra placement papers and interviews. By understanding how to manage transactions and protect data integrity, aspirants can improve their command over practical database scenarios. The provided explanations make complex DBMS operations easier to grasp for both exams and projects.
DBMS- Query, Transaction and Serurity Management
Showing 10 of
16 questions
1. Query processing is the procedure of selecting the most appropriate plan that is used in responding to a database request
- TRUE
- FALSE
3. The cost of processing a query is usually dominated by secondary storage access, which is slow compared to memory access.
- TRUE
- FALSE
4. The transformed query is used to create a number of strategies called execution (or access) plans.
- TRUE
- FALSE
6. A Query is contradictory if its predicate cannot be satisfied by any tuple in the relation(s).
- TRUE
- FALSE
7. In which phase of the query processing are the queries that are incorrectly formulated or are contradictory are rejected ?
- TRUE
- FALSE
8. Heurisitic rules are used as an optimization technique to modify the internal representation of a query.
- TRUE
- FALSE
9. Transformation rules are used by the query optimiser to transform one relational algebra expression into an equivalent expression that is more efficient to execute.
- TRUE
- FALSE
10. Systematic query optimization is used for estimation of the cost of different execution strategies and choosing the execution plan with the lowest cost estimate.
- TRUE
- FALSE