The SQL ____________ clause is used to specify the order in which data should be retrieved, potentially impacting query performance.
- ORDER BY
- GROUP BY
- WHERE
- HAVING
The correct option is ORDER BY. This clause is used in SQL queries to sort the result set based on specified columns either in ascending or descending order. It's crucial for performance optimization as it influences how data is fetched from the database.
Loading...
Related Quiz
- You are conducting security testing on a database application. You discover that the application is vulnerable to SQL injection attacks. What should be the immediate action to mitigate this vulnerability?
- During stress testing, if the system fails to recover gracefully after reaching its limits, what type of issue is likely occurring?
- One of the challenges in ETL testing is dealing with ____________ data sources and complex transformations.
- Which testing technique is used to evaluate the performance of a database under heavy loads?
- Data consistency testing verifies that data across different parts of the database is ____________ and accurate.