Home > SQL Server > Quizzes > Microsoft SQL Server Fundamentals Test
Microsoft SQL Server Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 30% • Most missed: “What clause allows you to filter the result of a column that has been aggregated…”
Microsoft SQL Server Fundamentals Test
Time left 00:00
25 Questions

1. The command DBCC CHECKDB allows you to do what?
2. Which of the following SQL Server built-in functions is nondeterministic?
3. Which of the following indices does NOT change the physical order of the rows in the table?
4. What is the default port of Microsoft SQL Server (for TCP)?
5. A sysadmin password requires at least 8 characters and which of the following character types?
6. Data Transformation Services do what?
7. To Improve stored procedure performance - which statement below is used to write beginning of SP?
8. a FOREIGN KEY constraint can reference a UNIQUE constraint
9. What clause allows you to filter the result of a column that has been aggregated?
10. What would be the output of following statement: Select * from tbl_Employee where Emp_Name=NULL
11. Which of the following are not default database schemas?
12. When retrieving data - which command may be used to rotate a set of column names from horizontal across the top to vertically - appearing as values among the result set
13. Which of the following acts as the Database Engine's security system?
14. 'Unique Constraint' can be created on a column that accepts NULL
15. When creating indexes in SQL - what two main factors must be considered?
16. What is the 'WITH RECOMPILE' statement used for?
17. True or false: A stored procedure can recursively call itself.
18. Which of the following is a benefit of SQL Server replication?
19. GETDATE() is a ....... function?
20. A ________ is an alphanumerical - hexadecimal - or numberic constant.
21. What is the basic difference between varchar and nvarchar?
22. In SQL Server 2012 introduces what new feature?
23. True or False? Every row in a FileTable represents a file or a directory.
24. True or false? Adding TOP to a select always improves performance.
25. What is CTE

⚡ Recently practiced quizzes in this topic
Live quiz activity
SQL Server Practice Test: Business Intelligence SQL Server Practice Test: Data Definition Language (DDL) SQL Server Practice Test: Views SQL Server Practice Test: Stored Procedure SQL Server Practice Test: Performance Tuning and Optimization SQL Server Practice Test: Data Types SQL Server Practice Test: Security SQL Server Practice Test: Monitoring and Auditing SQL Server Practice Test: SQL Basics SQL Server Practice Test: SQL Fundamentals
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.