SQL Server Quiz
Tests practical Microsoft SQL Server skill — writing T-SQL queries and transactions, designing indexes and tuning query performance, securing data with authentication, roles and encryption, and protecting databases with backups, recovery models and high availability. Pass to earn SQL Server SOA-MSQL.
- Intermediate difficulty.Assumes hands-on experience in the role.
- 20 scenario questions
- 20 minutes, timed
- 70% to pass · 90% for distinction
- Free no sign-up needed
- LinkedIn-ready · add it to your profile in one clickSee how ↓
What is the SQL Server Quiz?
The SQL Server Quiz is a free intermediate-level, 20-minute skill test from Science of Apps. It tests practical Microsoft SQL Server skill — writing T-SQL queries and transactions, designing indexes and tuning query performance, securing data with authentication, roles and encryption, and protecting databases with backups, recovery models and high availability. Score 70% or more on its 20 questions to earn a verifiable SQL Server certificate (SOA-MSQL). Every question is based on published standards and research — including Transact-SQL reference (Microsoft Learn), SQL Server index architecture and design guide (Microsoft Learn), Backup overview (SQL Server) (Microsoft Learn) — and each answer is explained with its source.
Built for your job title
SQL Server developer, Database administrator, BI developer, Backend developer and Data engineer — and anyone who wants quick, verifiable proof of SQL Server skills for a CV or LinkedIn.
- SQL Server developer
- Database administrator
- BI developer
- Backend developer
- Data engineer
What the quiz covers
Four skill areas with 5 questions each, drawn from a bank of 10 per area, so a retake brings questions you haven't seen.
- 01
T-SQL Queries and Transactions
25%- Querying
- Error handling
- Transactions
- 02
Indexes and Performance
25%- Clustered and nonclustered indexes
- Execution plans
- Query Store
- 03
Security
25%- Authentication and roles
- Encryption
- Fine-grained access
- 04
Backup, Recovery and High Availability
25%- Recovery models
- Backup types
- High availability
Independent skills test. Science of Apps is not affiliated with, endorsed by or sponsored by Microsoft. Product and exam names are trademarks of their owners. Passing earns a Science of Apps certificate, not a certification issued by Microsoft.
Based on published standards
The questions are original scenarios, and each one names the public standard, official guide or research it draws on — shown under the question while you answer, and linked in your review. These are the sources behind this quiz:
- Transact-SQL referenceMicrosoft Learn13 questions
- SQL Server index architecture and design guideMicrosoft Learn7 questions
- Backup overview (SQL Server)Microsoft Learn5 questions
- SET TRANSACTION ISOLATION LEVELMicrosoft Learn2 questions
- Monitor performance by using the Query StoreMicrosoft Learn2 questions
- Choose an authentication modeMicrosoft Learn2 questions
- What is an Always On availability group?Microsoft Learn2 questions
- Deadlocks guideMicrosoft Learn1 question
- Transparent data encryption (TDE)Microsoft Learn1 question
- Always EncryptedMicrosoft Learn1 question
- Dynamic data maskingMicrosoft Learn1 question
- Row-level securityMicrosoft Learn1 question
- Recovery models (SQL Server)Microsoft Learn1 question
- DBCC CHECKDBMicrosoft Learn1 question
Try a sample question
The T-SQL way to return only the first 10 rows of a query is
- SELECT ... LIMIT 10
- SELECT FIRST 10 ...
- SELECT TOP (10) ...
- SELECT ... ROWNUM <= 10
Show the answer
C. SELECT TOP (10) ... — LIMIT is MySQL and PostgreSQL syntax. The real quiz has 20 questions like this.
How the quiz works
20 minutes, 20 questions
One question per screen, with a progress bar and a countdown. Your progress is saved on this device if you need to pause.
Graded on our server
Answers reach the page only after you submit, so the certificate can only be earned by passing.
Every answer explained
Pass or not, you see every question with the right answer, why, and the source behind it. Pass mark 70%, distinction 90%.
Your certificate
Founder-signed, with a QR code and credential ID. Download PDF or PNG, add to LinkedIn, and it's emailed to you.
What you earn

Pass, then add it to LinkedIn in one click
No typing. The Add to LinkedIn button opens your profile’s Licenses & certifications form already filled in: the certificate name, Science of Apps as the issuer, the issue date, your credential ID and a link recruiters can use to verify it.
- 1Take the 20-minute test
- 2Score 70% or more
- 3Click Add to LinkedIn

SQL Server
Science of Apps
Show credential ↗Try another skill test
- 10 minSOA-HTML
HTML and CSS Fundamentals Certification
Tests modern HTML and CSS — semantic elements, forms, accessibility basics, the box model, Flexbox, Grid, responsive design and newer features like container queries.
Difficulty: BeginnerTake the 10-minute test → - 10 minSOA-JS
JavaScript Fundamentals Certification
Tests core modern JavaScript — variables and scope, types and equality, functions and closures, arrays and objects, promises and async/await, modules and the DOM.
Difficulty: BeginnerTake the 10-minute test → - 15 minSOA-TS
TypeScript Fundamentals Certification
Tests practical TypeScript — types and interfaces, unions and narrowing, generics, utility types, strict mode, the satisfies operator and typing real-world code.
Difficulty: IntermediateTake the 15-minute test →
Frequently asked questions
What is the SQL Server Quiz?
The SQL Server Quiz is a free intermediate-level, 20-minute skill test from Science of Apps. It tests practical Microsoft SQL Server skill — writing T-SQL queries and transactions, designing indexes and tuning query performance, securing data with authentication, roles and encryption, and protecting databases with backups, recovery models and high availability. Score 70% or more on its 20 questions to earn a verifiable SQL Server certificate (SOA-MSQL). Every question is based on published standards and research — including Transact-SQL reference (Microsoft Learn), SQL Server index architecture and design guide (Microsoft Learn), Backup overview (SQL Server) (Microsoft Learn) — and each answer is explained with its source.
How do I take the SQL Server Quiz for free?
Read the four skill areas on this page, then take the 20-minute quiz online — no fee, course or sign-up. You see every answer explained when you finish. Score 70% or more and you get a SQL Server certificate straight away, on screen, as a PDF and by email, with a credential ID anyone can verify.
Are the SQL Server Quiz questions based on real standards?
Yes. The questions are original scenarios written by Science of Apps, and each one is based on a public source you can read: Transact-SQL reference (Microsoft Learn); SQL Server index architecture and design guide (Microsoft Learn); Backup overview (SQL Server) (Microsoft Learn); SET TRANSACTION ISOLATION LEVEL (Microsoft Learn); Monitor performance by using the Query Store (Microsoft Learn); Choose an authentication mode (Microsoft Learn). The source is shown under each question and linked in the answer review. Science of Apps doesn't copy questions from other tests.
What does the SQL Server Quiz cover?
Four skill areas with five questions each, drawn from a bank of 10 per area so a retake brings new questions: T-SQL Queries and Transactions (Querying, Error handling and Transactions); Indexes and Performance (Clustered and nonclustered indexes, Execution plans and Query Store); Security (Authentication and roles, Encryption and Fine-grained access); Backup, Recovery and High Availability (Recovery models, Backup types and High availability). Every question is an original scenario based on a published standard, official documentation or research, named under the question.
Who should take the SQL Server Quiz?
SQL Server developer, Database administrator, BI developer, Backend developer and Data engineer. It suits anyone who wants a quick, verifiable way to show SQL Server skills, from students and career switchers to experienced professionals.
Can I use this for SQL server interview questions, t-sql quiz or mssql test?
Yes. The SQL Server Quiz is free and covers all of these: 20 scenario questions in 20 minutes, each answer explained with the source it comes from, so it works as interview and exam practice. It isn't a full course, so use the areas you miss as your study list. Scoring 70% or more earns a verifiable certificate.
Can I take the SQL Server Quiz from any country?
Yes. The quiz is online, in English and free everywhere — people take it from India, the US, the UK, Europe, Africa, Latin America and Asia-Pacific. Your certificate is dated with your own local date and can be verified from anywhere at scienceofapps.com/certification/verify/.
How long is the SQL Server Quiz?
20 questions — 5 from each of 4 skill areas — with a 20-minute limit. You need 70% (14 of 20) to pass and 90% for distinction.
How hard is the SQL Server Quiz?
We rate it Intermediate: assumes hands-on experience in the role. It has 20 scenario questions — 5 from each of 4 skill areas — and a 20-minute limit. You need 70% (14 of 20) to pass and 90% for distinction.
How much do Science of Apps certifications cost?
Nothing. There is no fee to take a test, to receive the certificate, to have it emailed or to verify it, and no sign-up.
How are the tests graded?
On our server, not in your browser. The answers never reach the page until you submit, so a certificate can only be earned by passing. Each certificate gets a unique credential ID stored by Science of Apps.
What happens if I don't pass?
You see your score for each area and every question with the correct answer and why, with the published source behind it. You can retake after 30 minutes, and the retake draws questions you haven't seen yet.
Do the certificates expire?
No. Every certificate is dated, so it always shows when you passed. Retake a test any time for a newer date or a higher score.
Can I add the certificate to LinkedIn?
Yes. After you pass, Add to LinkedIn opens the Licenses & certifications form with the certificate name, Science of Apps as the issuer, the issue date, your credential ID and the verification link filled in. You can also download it as a PDF or PNG, and it's emailed to you as a PDF.
How can an employer verify my certificate?
Every certificate has a credential ID and a QR code. Scanning it, or entering the ID at scienceofapps.com/certification/verify/, shows the holder's name, the certification, the score and the issue date from our records.
Are these accredited qualifications?
No. They are Science of Apps' own assessments of applied skill. They aren't issued by a university or standards body, and they work best alongside a portfolio that shows the skills in real work.
990 more certifications to collect
Software Engineering & Web Development
- HTML and CSS Fundamentals Certification10 min · Beginner
- JavaScript Fundamentals Certification10 min · Beginner
- TypeScript Fundamentals Certification15 min · Intermediate
- Front-End Development Certification15 min · Intermediate
- Back-End Development Certification15 min · Intermediate
- Full-Stack Web Development Certification15 min · Intermediate
- React Developer Assessment15 min · Intermediate
- Angular Developer Assessment15 min · Intermediate
- Vue.js Developer Assessment15 min · Intermediate
- Next.js Development Certification15 min · Intermediate
- Python Programming Certification10 min · Beginner
- Java Programming Certification15 min · Intermediate
- C++ Programming Certification20 min · Advanced
- C# and .NET Development Certification15 min · Intermediate
- PHP and Laravel Development Certification15 min · Intermediate
- Node.js Development Certification15 min · Intermediate
- API Design and Integration Certification15 min · Intermediate
- REST API Testing Certification15 min · Intermediate
- GraphQL Fundamentals Certification15 min · Intermediate
- Git and GitHub Proficiency Certification10 min · Beginner
- Data Structures and Algorithms Certification20 min · Advanced
- Object-Oriented Programming Certification15 min · Intermediate
- Software Architecture Fundamentals Certification20 min · Advanced
- Code Review and Code Quality Certification15 min · Intermediate
- Secure Coding Fundamentals Certification15 min · Intermediate
- AI-Assisted Software Development Certification15 min · Intermediate
- Technical Problem-Solving Assessment15 min · Intermediate
- Software Engineering Interview Readiness15 min · Intermediate
- Mobile App Development Fundamentals Certification10 min · Beginner
- React Native Development Certification15 min · Intermediate
- Android Development with Kotlin Certification15 min · Intermediate
- iOS Development with Swift Certification15 min · Intermediate
- API Documentation Certification15 min · Intermediate
- Go Programming Test20 min · Intermediate
- Rust Programming Test20 min · Intermediate
- Kotlin Programming Test20 min · Intermediate
- Flutter & Dart Certification20 min · Intermediate
- WordPress Developer Certification20 min · Intermediate
- Web Performance & Core Web Vitals Test20 min · Intermediate
- System Design Certification (Interview Practice)25 min · Advanced
- Unit Testing & TDD Test20 min · Intermediate
- ISTQB Foundation Level Practice Test20 min · Intermediate
- Playwright Testing Test20 min · Intermediate
- Selenium Test20 min · Intermediate
- Performance & Load Testing Test20 min · Intermediate
- Database Design & Normalization Test20 min · Intermediate
- PostgreSQL Test20 min · Intermediate
- MongoDB Test20 min · Intermediate
- Redis Test20 min · Intermediate
- Microservices Architecture Test25 min · Advanced
- WebSockets & Real-Time Apps Test20 min · Intermediate
- WebAssembly Test20 min · Intermediate
- Compiler Design Test25 min · Advanced
- Open Source Contribution Test15 min · Beginner
- MySQL Quiz15 min · Beginner
- SQL Server QuizYou're here
- Oracle SQL Quiz20 min · Intermediate
- Django Test20 min · Intermediate
- Flask Quiz20 min · Intermediate
- FastAPI Test20 min · Intermediate
- Spring Boot Test20 min · Intermediate
- Bash Quiz20 min · Intermediate
- QA Tester Certification Test15 min · Beginner
- Engineering Manager Test25 min · Advanced
- SSMS Quiz15 min · Beginner
- NoSQL Quiz20 min · Intermediate
- Elasticsearch Test20 min · Intermediate
- Firebase Quiz20 min · Intermediate
- Django REST Framework Test20 min · Intermediate
- Express JS Test20 min · Intermediate
- Ruby on Rails Test20 min · Intermediate
- ASP.NET Core Test20 min · Intermediate
- jQuery Quiz15 min · Beginner
- Bootstrap Quiz15 min · Beginner
- Regex Quiz20 min · Intermediate
- Salesforce Apex Test20 min · Intermediate
- Clean Code Quiz20 min · Intermediate
- Debugging Quiz20 min · Intermediate
- Embedded Systems Test25 min · Advanced
- Data Structures Quiz20 min · Intermediate
- WooCommerce Quiz20 min · Intermediate
- Webflow Certification Test20 min · Intermediate
- Framer Certification Test15 min · Beginner
- MariaDB Quiz20 min · Intermediate
- Ajax Quiz15 min · Beginner
- Ionic Framework Quiz20 min · Intermediate
- Solidity Quiz25 min · Advanced
- Android Quiz20 min · Intermediate
- Web Accessibility Quiz20 min · Intermediate
- Drupal Quiz20 min · Intermediate
- Magento 2 Certification Test20 min · Intermediate
- WordPress Quiz15 min · Beginner
Foundation
AI & Generative AI
- AI UX Design Certification30 min · Advanced
- Prompt Engineering Certification30 min · Intermediate
- AI Product Manager Certification30 min · Advanced
Data Analytics & Business Intelligence
- Product Analytics Certification30 min · Advanced
- Data Literacy Certification10 min · Beginner
- Microsoft Excel Fundamentals Certification10 min · Beginner
Digital Marketing, SEO, AEO & Growth
- Conversion Rate Optimization (CRO) Certification30 min · Advanced
- App Store Optimization (ASO) Certification30 min · Intermediate
- Growth Marketing Certification30 min · Intermediate
UX/UI, Design, Research & Creative
- UX Design Certification30 min · Intermediate
- UI Design Certification30 min · Intermediate
- Product Design Certification30 min · Intermediate
Product, Project Management & Business Analysis
- Product Manager Certification30 min · Intermediate
- Design Leadership Certification30 min · Advanced
- Agile Product Owner Certification30 min · Intermediate
Cybersecurity, IT, Cloud & DevOps
- Cybersecurity Fundamentals Certification10 min · Beginner
- Security Awareness and Phishing Detection Certification10 min · Beginner
- Network Security Fundamentals Certification15 min · Intermediate
Sales, Customer Success & Support
- Sales Fundamentals Certification10 min · Beginner
- Consultative Selling Certification15 min · Intermediate
- B2B Sales Development Representative Certification10 min · Beginner
Human Resources & People Management
- Human Resources Fundamentals Certification10 min · Beginner
- Talent Acquisition and Recruitment Certification10 min · Beginner
- Technical Recruitment Certification15 min · Intermediate
Finance, Accounting, Operations & Entrepreneurship
- Financial Literacy for Professionals Certification10 min · Beginner
- Accounting Fundamentals Certification10 min · Beginner
- Bookkeeping Fundamentals Certification10 min · Beginner
Communication, Leadership & Transferable Skills
- Critical Thinking Test10 min · Beginner
- Attention to Detail Test10 min · Beginner
- Cognitive Bias Test10 min · Beginner
Languages
- English Level Test30 min · Beginner
- American Sign Language (ASL) Foundations Test25 min · Intermediate
- App & Software Localization Test25 min · Intermediate
Healthcare, Education, Legal Operations & Sustainability
- Healthcare Administration Fundamentals Certification10 min · Beginner
- Medical Office Administration Certification10 min · Beginner
- Healthcare Data Privacy Awareness Certification10 min · Beginner
Test Prep, Academics & Aptitude
- SAT Math Practice Test20 min · Advanced
- SAT Reading and Writing Practice Test20 min · Advanced
- ACT Practice Test (English, Math, Reading & Science)20 min · Advanced
Language Exam Prep
- IELTS Academic Practice Test with Band Score20 min · Advanced
- IELTS General Training Practice Test20 min · Advanced
- TOEFL iBT Practice Test20 min · Advanced
Office & Productivity Software
- Microsoft Word Skills Certification15 min · Intermediate
- Microsoft PowerPoint Skills Certification15 min · Intermediate
- Microsoft Outlook Skills Certification10 min · Beginner
Engineering, Architecture, Construction & Safety
- Mechanical Engineering Practice Test (FE-Style)20 min · Advanced
- Electrical Engineering Practice Test (FE-Style)20 min · Advanced
- Civil Engineering Practice Test (FE-Style)20 min · Advanced
Hospitality, Travel & Retail
- Hospitality Management Certification10 min · Beginner
- Food Safety Certification10 min · Beginner
- Hotel Revenue Management Certification15 min · Intermediate
Cognitive Ability & Pre-Employment Tests
- IQ Test20 min · Intermediate
- Numerical Reasoning Test20 min · Intermediate
- Verbal Reasoning Test20 min · Intermediate
Read before you test
- Career guidesAdvanced SQL interview questions for data jobs in 2027: window functions, CTEs, performance and the patterns senior roles testAdvanced SQL interview questions for senior analyst, analytics engineer and data engineer jobs in 2027: window functions, CTEs, gaps and islands, performance.
- Career guidesHow to get a back-end developer job in 2027: APIs, databases and the design round that decides itHow to get a back-end developer job in 2027: the API, database, security and system-design skills employers test, the interview loop, pay in India and a plan.
- Career guidesSQL for data analyst jobs in 2027: what employers test, the questions they ask and how to prove you're readySQL for data analyst jobs in 2027: which roles need it, how employers test it, real interview questions with answers, the traps that fail candidates and a plan.
- Career guidesAdvanced Excel test for jobs in 2027: XLOOKUP, dynamic arrays, Power Query and what analyst interviews really checkHow to pass an advanced Excel test for analyst jobs in 2027: XLOOKUP, dynamic arrays, LET, Power Query, data models, real test tasks with answers and a plan.
- Career guidesHow to get a data engineer job in 2027: pipelines, modelling and the system-design round that decides itHow to get a data engineer job in 2027: the SQL, Python and pipeline-design skills employers test, the interview loop, India and global pay, and a 12-week plan.
- Career guidesSearch analytics and Google Search Console skills employers want in 2027: performance data, indexing reports, diagnosis and reporting that drives decisionsGoogle Search Console skills employers want in 2027: performance reports, filters and comparisons, indexing, page experience, data limits and reporting.
Get the ideas, not the noise.
Sign up with Google and we’ll send you short UX psychology tips by email — why people tap, stall and leave, and what to do about it. Unsubscribe anytime. Prefer something to keep? Get the free Laws of UX guide as a PDF.
Founder, Science of Apps




