Query Process and OptimizationOnline version Project Based Learning - II Thakur College of Engineering and Technology Information Technology Department Game - Subjective Questions Database Management System (DBMS) by Dilip Jain 1 Explain the methods for implementing Joins. Written answer 2 Write the query from the following: Written answer 3 How would you choose an appropriate algorithm for implantation of a Query? Written answer 4 Is Single-operator-at-a-time appropriate? Explain. Why? And mention other alternatives. Written answer 5 List the steps involved for performing heuristic based optimization. Written answer 6 How can we compare two query processing methods? Written answer 7 How do you identify and organize the shared memory and semaphores of a particular DB instance if there are running multiple servers? Written answer 8 Write the algorithm for External Sorting with suitable example. Written answer 9 Compare different types of selection algorithms and state the best algorithm for query processing. Written answer 10 How do you analyse an explain plan? Consider different areas where Query optimization can be implemented Written answer Feedback 1 3
New game