Welcome to your SSMS Intermediate
1.
Which statement is used to retrieve data from a SQL Server database?
2.
What does SSMS stand for?
3.
Which SQL function is used to find the length of a string?
4.
Which SQL clause is used to filter records based on a specified condition?
5.
Which SQL keyword is used to retrieve unique records from a table?
6.
What does the SQL keyword 'JOIN' do?
7.
Which SQL statement is used to modify data in a table?
8.
What is the purpose of the SQL function 'SUM()'?
9.
Which SQL clause is used to sort the result set in ascending or descending order?
10.
What is the purpose of the SQL keyword 'HAVING'?
11.
Which SQL function is used to return the current date and time?
12.
What is the purpose of the SQL keyword 'AS'?
13.
Which SQL clause is used to limit the number of rows returned in a result set?
14.
What does the SQL function 'AVG()' do?
15.
Which SQL statement is used to add a new column to an existing table?
16.
What does the SQL keyword 'GROUP BY' do?
17.
Which SQL clause is used to combine the results of two or more SELECT statements?
18.
What is the purpose of the SQL function 'MAX()'?
19.
Which SQL statement is used to delete rows from a table?
20.
What is the purpose of the SQL keyword 'DISTINCT'?
Leave a Reply