SQL Quiz Welcome to your SQL Quiz 1. Which SQL statement is used to return only different values? SELECT DIFFERENT ColumnName FROM TableName; SELECT DISTINCT ColumnName FROM TableName; SELECT UNIQUE ColumnName FROM TableName; None of the above None 2. Which SQL keyword is used to sort the data in ascending or descending order, based on one or more columns SORT SORT BY ORDER ORDER BY None 3. The table rows are also known as Records Attributes Fields None of the above None 4. The table columns are also known as Records Attributes Fields None of the above None 5. Which of the following keyword you use to modify the existing value in an UPDATE query? EDIT UPDATE SET VALUE None 6. Which of the following is not an SQL Aggregate function AVG() ABS() COUNT() SUM() None 7. The UNION operator is used to Combine the result-set of no more than two SELECT statements and must have the same number of columns Combine the result-set of no more than two SELECT statements and doesn't have the same number of columns Combine the result-set of two or more SELECT statements and must have the same number of columns Combine the result-set of two or more SELECT statements and doesn't have the same number of columns None 8. The MIN() function returns the smallest value of the selected column and The MAX() function returns the largest value of the selected column True False None 9. Which SQL statement is used to remove rows from a table? DELETE DROP ELIMINATE REMOVE None 10. A NULL value is different than a zero value or a field that contains spaces True False None 11. Which of the following is not a RDBMS? MySQL MongoDB NexusDB PostgreSQL None 12. Subqueries can be nested multiple times True False None 13. Which of the following is not a part of SQL Data Control Language Data Definition Language Data Manipulation Language Data Structured Language None 14. What is the keyword you use to group the result by a column's values? GROUP BY ORDER BY None 15. Which statement is correct To sort in ascending or descending order we can use the keywords ASC or DESC respectively To sort in ascending or descending order we can use the keywords DESC or ASC respectively To sort in ascending or descending order we can use the keywords AESC or DSC respectively To sort in ascending or descending order we can use the keywords DSC or AESC respectively None 16. The result of a SELECT statement can contain duplicate rows True False None 17. Which SQL statement is used to delete complete data from an existing table & table structure from the database? DROP DELETE TRUNCATE None of the above None 18. Which SQL statement is used to delete complete data from an existing table? DELETE REMOVE TRUNCATE None of the above None 19. The AND operator displays a record if all the conditions separated by AND are TRUE True False None 20. With SQL, how do you select all the columns from a table named "Employees"? SELECT FROM Employees SELECT * Employees SELECT * FROM Employees SELECT [all] FROM Employees None 21. Which of the following is not a Data Definition Language (DDL) statement? ALTER CREATE RENAME UPDATE None 22. Which type of database management system represents relations using tables? Hierachical DBMS Object Oriented DBMS Relational DBMS None of the above None 23. What does SQL stand for? Structured Query Language Structured Queries Language Structured Question Language None of the above None 24. Which SQL statement is used to modify the existing records in a table? UPDATE MODIFY EDIT SAVE None of the above None 25. Which SQL statement is used to insert new rows of data to a table in a database ADD APPEND ADJUST INSERT None 26. Which SQL statement is used to extract data from a database? EXTRACT GET SELECT None of the above None 27. Which function returns the difference between two dates DATEDIFFERENCE() DATEDIFF() DATESUB() DATESUBTRACT() None 28. Which SQL keyword you use to merge two tables based on a matching column? AND ATTACH JOIN MERGE None 29. The OR operator displays a record if any of the conditions separated by OR is TRUE True False None 30. With SQL, how do you select a column named "FirstName" from a table named "Employees"? SELECT * FROM Employees SELECT FirstName FROM Employees SELECT FROM Employees.FirstName SELECT * FirstName FROM Employees None Time's up
