In the Online SQL Server Test, for every correct answer, you will be given 2 points. There will also be negative marking of -1 for every wrong answer. So, you will have to be more careful in choosing the answers to the question in your online examination. If needed, you should skip to the next question and come back to the previous question later so that you can do proper time management for the online mock tests.
Based on your score, you would be given one of the following Grades:
Grade A* - Genius (You scored 100%)
Grade A - Excellent (Your score is in the range of 80% to 99%)
Grade B - Good (Your score is in the range of 60% to 80%)
Grade C - Average (Your score is in the range of 40% to 60%)
Grade D - Poor (Your score is in the range of 0% to 40%)
There will be 5 types of SQL Server Tests. The details of each of these tests are as follows:
For every "SQL Server Practice Test", Total Questions: 20, Total Time: Unlimited.
For every "SQL Server Mock Test", Total Questions: 20, Total Time: 20 Minutes.
For "SQL Server Certification Test", Total Questions: 50, Total Time: 1 hour.
For "SQL Server Internship Test", Total Questions: 50, Total Time: 1 hour.
For "SQL Server Job Test", Total Questions: 50, Total Time: 1 hour.
Before you get started on these series of online tests on SQL Server, you should learn, study and practice our collection of 1000 MCQs (Multiple Choice Questions and Answers) on SQL Server here. We also prefer that you should practice SQL Server practice tests and mock tests completely before attempting the certification test.
Here is the list of online practice tests and mock tests on SQL Server. Each online test focuses on a "Specific chapter of SQL Server". So, you should try both practice test and mock test on every chapter to do a self-assessment of your knowledge (along with time-limit constraints) in every area or sub-topic of SQL Server. SQL Server Certification test, Internship test, and Job Test are mentioned at the end of this list.
1. SQL Server Test 1 – This set of online test on “SQL Server” tests your skills on Introduction, Management Studio – 1, Management Studio – 2, Data Types, Builtin Functions, Basic SQL – 1, Basic SQL – 2, Basic SQL – 3, Joins, Views.
2. SQL Server Test 2 – This set of online test on “SQL Server” tests your skills on Aggregation of Data, Powershell, Windowing, Ranking, Subqueries, Modifying Data – 1, Modifying Data – 2, Constraints, Hierarchies, Working With XML Data – 1.
3. SQL Server Test 3 – This set of online test on “SQL Server” tests your skills on Working With XML Data – 2, Working With XML Data – 3, Xquery, Full Text Search, Data Definition Language – 1, Data Definition Language – 2, Data Definition Language – 3, Transact SQL, Procedural Flow, Variables.
4. SQL Server Test 4 – This set of online test on “SQL Server” tests your skills on Cursor, Error Handling, Stored Procedure – 1, Stored Procedure – 2, Builtin Stored Procedures, User Defined Functions – 1, User Defined Functions – 2, DML Triggers, DDL Triggers, Dynamic SQL.
5. SQL Server Test 5 – This set of online test on “SQL Server” tests your skills on SQL Injection, Bulk Operations, Distributed Queries, ADO.NET, LINQ – 1, LINQ – 2, Service Broker, Replication, Integration Services – 1, Integration Services – 2.
6. SQL Server Test 6 – This set of online test on “SQL Server” tests your skills on Access With SQL Server, Enterprise Data Management, Policy Based Management, Recovery, Backup, Database Maintenance, SQL Server Agent, Transferring Database, Database Snapshots, Log Shipping.
7. SQL Server Test 7 – This set of online test on “SQL Server” tests your skills on Database Mirroring, Clustering, Authentication, Securables, Data Cryptography, Row Level Security, Data Audit, Schema Audit, Performance Monitoring, Profiling.
8. SQL Server Test 8 – This set of online test on “SQL Server” tests your skills on Wait States, Extended Events, Change Tracking, Change Data Capture, SQL Audit, Management Data Warehouse, Query Execution Plan, Indexing Strategies – 1, Indexing Strategies – 2, Query Plan Reuse.
9. SQL Server Test 9 – This set of online test on “SQL Server” tests your skills on Transaction – 1, Transaction – 2, Locking, Blocking, Working With Transaction Log, Data Compression, Partitioning, Resource Governor, Business Intelligence, Analysis Services – 1.
10. SQL Server Test 10 – This set of online test on “SQL Server” tests your skills on Analysis Services – 2, Analysis Services – 3, MDX – 1, MDX – 2, Reporting Services – 1, Reporting Services – 2, Analyzing Data With Excel, Specifications – 1, Specifications – 2, System Databases.
Sanfoundry will issue a Certificate of Merit to Top 5 Rankers for a given month provided that they have scored either A* or A Grade in the Contest. If you are interested, then kindly register below. After registration, you can take the test anytime (24x7).