MSSQL Objective Questions and Answers for Beginners Set-3
corpline

1. What is a foreign key in a database table?


2. Which SQL data type would you use to store a fixed-length string of characters?


3. What is the purpose of the SQL BETWEEN operator?


4. What is the purpose of the SQL NULL value?


5. What is the purpose of the SQL TOP clause?


6. Which SQL data type would you use to store large text data, such as paragraphs or documents?


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


8. What is the purpose of the SQL AVG() function?


9. Which SQL data type would you use to store a date and time value in MSSQL?


10. What is the purpose of the SQL SUM() function?


11. Which SQL data type would you use to store monetary values in MSSQL?


12. What is the purpose of the SQL AS keyword in a SELECT statement?


13. What is the purpose of the SQL UNION operator?


14. What is the purpose of the SQL CASE statement?


15. What is the purpose of the SQL CHECK constraint?


Online Tests
Read more

Oracle Database
Read more

MSSQL Database
Read more

PostGres Database
Read more

Linux
Read more

ASP/C#
Read more

Navigation Panel