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
11. Usually, heuristic rules are used in the form of query tree or query graph data structure.
- TRUE
- FALSE
12. The heuristic optimization algorithm utilize some of the transformation rules to tranform an initial query tree into an optimised and efficiently executable query tree.
- TRUE
- FALSE
13. The emphasis of cost minimisation depends on the size and type of database applications.
- TRUE
- FALSE
14. The success of estimating size and cost of intermediate relational algebra operations depends on the amount and accuracy of the statistical data information stored with the database management system (DBMS).
- TRUE
- FALSE
15. The cost of materialised evaluation includes the cost of writing the result of each operation to the secondary storage and reading them back for the next operation.
- TRUE
- FALSE
16. Combining operations into a pipeline eliminates the cost of reading and writting temporary relations.
- TRUE
- FALSE