SQL Server Intermediate Welcome to your SQL Server Intermediate Quiz 1. What is the purpose of an SQL JOIN operation? To filter rows in a table. To combine rows from two or more tables. To sort the result set. To insert new rows into a table. None 2. Which SQL command is used to retrieve unique values from a column? SELECT DISTINCT SELECT UNIQUE SELECT UNIQUEVALUES SELECT UNIQUE RECORDS None 3. In SQL, what is the purpose of the GROUP BY clause? To sort the result set. To combine multiple tables. To group rows with similar values and perform aggregate functions. To filter rows based on a condition. None 4. Which SQL command is used to change existing data in a table? MODIFY UPDATE ALTER CHANGE None 5. What does the SQL term "Normalization" refer to? The process of making data more complex. The process of organizing data in a database to reduce redundancy and improve data integrity. The process of creating indexes on columns. The process of sorting data in ascending order. None 6. Which SQL function is used to return the current date and time? NOW() GETDATE() CURRENT_TIMESTAMP DATE() None 7. What is the purpose of the SQL ORDER BY clause? To specify the table's primary key. To filter rows based on a condition. To sort the result set in ascending and descending order. To group rows based on a common column. None 8. Which SQL command is used to add a new table to an existing database? INSERT TABLE CREATE TABLE ADD TABLE NEW TABLE None 9. What is the purpose of the SQL HAVING clause? To specify a filter condition for rows. To sort the result set. To specify conditions for grouping rows. To filter rows after grouping based on aggregate functions. None 10. Which SQL data type is used to store variable-length character strings of a maximum length? INT VARCHAR DATE DECIMAL None 1 out of 10 Please fill out the form to view your results! We appreciate your participation in the Knowledge Challenge. Please complete the form to view your results. A copy will also be sent to your email shortly after submission. Name Email Phone Time's up
