MSSQL Objective Questions and Answers for Beginners Set-2

1. Which SQL function is used to find the minimum value in a column?


2. Which SQL statement is used to create a new database?


3. What is the purpose of the SQL DISTINCT keyword?


4. Which SQL statement is used to create a new table?


5. What is the purpose of the SQL LIKE operator?


6. Which SQL function is used to find the maximum value in a column?


7. What is the purpose of the SQL NULL keyword?


8. Which SQL statement is used to delete a table from the database?


9. What is the purpose of the SQL COUNT() function?


10. Which SQL statement is used to change the data type of a column in a table?


11. Which SQL function is used to find the length of a string?


12. Which SQL function is used to convert a string to uppercase characters?


13. What is the purpose of the SQL LIMIT clause?


14. What is the purpose of the SQL GROUP BY clause when used with the GROUP_CONCAT() function?


15. What is the purpose of the SQL TRUNCATE TABLE statement?




Rate Your Experience

: 89 : 1


Last updated in November, 2024

Online Tests
Read more

Cloud Technology
Read more

Oracle Database
Read more

MSSQL Database
Read more

PostGres Database
Read more

Linux
Read more

ASP/C#
Read more

Quick Access