MCQs > IT & Programming > Microsoft SQL Server MCQs > General MCQs

General MCQ for Microsoft SQL Server

1. What is the correct syntax for a CTE?

2. What is the basic difference between varchar and nvarchar?

3. What does 'UDF' stand for?

4. The SETCERT.EXE utility can be used to do what?

5. Which of the following statements regarding 'views' are incorrect?

6. Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005?

7. Which of the following options is not correct about the DATEDIFF() function?

8. The simplest query must include at least ________ and _________.

9. Which operator will be evaluated first in the following statement:

select (age + 3 * 4 / 2 - 8) from emp

10. Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if all the parentheses are removed from the calculation?

11. Which of the following are not date parts?

12. Which of the following statements is not true about the table object in SQL Server?

13. What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;

14. Which of the following is not a SQL operator?

15. You have a database named 'marketnikkie', the backup of which is stored at 'D:\marketnikkie.bak' location on your server. Due to some electric fluctuations, the database gets corrupt. Which of the following is the correct query to restore your database?

16. How is the following query incorrect? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

17. Which of the following clauses are not allowed in a single row sub-query?

Microsoft SQL Server MCQs | Topic-wise

MCQ on Basic Microsoft SQL Server General Microsoft SQL Server MCQs
Buy us a coffee
Microsoft SQL Server Subjects
Basic Microsoft SQL Server MCQs
More Resources
Microsoft SQL Server Skill Assessment
Microsoft SQL Server PDF
Related MCQs
Mobile App Design
Mobile App Testing
Mobile Web Authoring
MongoDB
MySQL
search
Buy us a coffee
Microsoft SQL Server Subjects
Basic Microsoft SQL Server MCQs
More Resources
Microsoft SQL Server MCQ
Microsoft SQL Server Skill Assessment
Microsoft SQL Server PDF
Related MCQs
Mobile App Design
Mobile App Testing
Mobile Web Authoring
MongoDB
MySQL
Logo

Join our newsletter for the latest updates.

play store app store
Coming Soon

Our Products

Skill Assessment
Categories
MCQs
PDFs
Buy us a coffee

Company

About
Advertising
Privacy Policy
Terms & Conditions
Sitemap
Contact
Blog
Back to top back to top
Logo
play store app store
Coming Soon
Buy us a coffee

© Copyrights 2025 Quizack.com