Quiz – SQL Server Basics – Part 2 Quiz – SQL Server Basics – Part 2 This is is the 2nd part of the SQL Server Basics Quiz where you will be tested on various basics concepts of Microsoft Server. 1 / 10 Which SQL Server keyword is used to limit the number of rows returned by a SELECT statement? FETCH OFFSET TOP LIMIT 2 / 10 Which SQL Server keyword is used to retrieve all columns from a table? ALL EVERY * ANY 3 / 10 Which SQL Server operator is used to search for a specific pattern in a column? BETWEEN EXISTS LIKE IN 4 / 10 Which SQL Server keyword is used to retrieve distinct values from a column? GROUP BY DISTINCT ORDER BY UNIQUE 5 / 10 Which SQL Server function is used to find the maximum value in a column? MAX AVG SUM MIN 6 / 10 What is the purpose of the SELECT statement in SQL Server? To update data in a table To retrieve data from a table To delete data from a table To insert data into a table 7 / 10 Which SQL Server clause is used to join two or more tables in a SELECT statement? ORDER BY JOIN WHERE GROUP BY 8 / 10 Which SQL Server keyword is used to sort the result set of a SELECT statement in ascending order? ORDER BY GROUP BY ASC DESC 9 / 10 What is the basic syntax for a simple SELECT statement in SQL Server? SELECT columns WHERE table; SELECT columns FROM table; SELECT table WHERE columns; SELECT table FROM columns; 10 / 10 Which SQL Server function is used to count the number of rows returned by a SELECT statement? MAX COUNT SUM AVG Your score is Share LinkedIn Facebook Twitter VKontakte 0% Tag:sql-server-quiz Share: admin Previous post How do you handle working with legacy code? March 11, 2023 Next post Quiz - SQL Server Basics - Part 3 March 11, 2023 You may also like Microsoft Excel Quiz #10 17 May, 2023 Microsoft Excel Quiz #9 17 May, 2023 Microsoft Excel Quiz #8 17 May, 2023
