[Check Point 12.1] Simple Queries in SQL – Chapter 12 Sumita Arora

6. Which keyword eliminates the redundant data from a query result?

Solution: The keyword “DISTINCT” eliminates redundant (duplicate) data from a query result.

7. Which keyword retains duplicate output rows in a query result?

Solution: The keyword “ALL” retains duplicate output rows in a query result.

8. How would you display system date as the result of a query?

Solution: You can use the MySQL function “CURDATE()” to display the current system date as the result of a query.

9. How would you calculate 13 * 15 in SQL?

Solution: You can use the multiplication operator (*) in SQL. Taking AS keyword is not required. So, the query would be:

SELECT 13 * 15 AS Result;