Question1. What is structured query language (SQL) performance tuning?
Question2. In an RDBMS, how are the three phases parsing, execution, and fetching-- carried out? In general, in which phase would you tune a database?
Question3. What are database statistics and why are they important?
Question4. What are the different types of database requests and transactions?
Question5. Discuss why is there a need for a two-phase commit protocol? What are their two phases?
Question6. What are decision support systems? What role do they play in a business environment?
Question7. What is a data warehouse and what are its main characteristics?