SQL Server Online Test

Q: What topics are covered in the SQL Server Online Test?

交易数据库 配置 数据库和数据库对象 安装 同步 事务日志 数据库监视和维护 备份和恢复 SQL Server数据库安全性和故障排除 存储区网络（SAN）

About the test:

SQL Server Online测试使用基于方案的MCQ来评估候选者对SQL Server的了解，包括他们编写复杂SQL查询，管理SQL Server实例和管理数据的熟练程度。此外，该测试评估了候选人对SQL Server安全性，性能优化和灾难恢复的理解。该测试旨在评估候选人在各种现实情况下有效，有效地与SQL Server合作的能力。

Covered skills:

交易数据库
数据库和数据库对象
同步
数据库监视和维护
SQL Server数据库安全性和故障排除

配置
安装
事务日志
备份和恢复
存储区网络（SAN）

Try practice test

Start 14-day free trial

9 reasons why

Adaface SQL Server Test is the most accurate way to shortlist 数据库管理员s

Reason #1

Tests for on-the-job skills

The SQL Server Online Test helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

设计和实施交易和关系数据库的能力
能够配置SQL Server设置和优化
能够创建和管理数据库对象
能够安装SQL Server并执行必要的配置
能够在多个数据库之间同步数据
有效管理交易日志的能力
能够监视和维护数据库
备份和恢复数据库的能力
能够解决SQL Server数据库安全问题的能力
与存储区网络（SAN）合作的能力

Reason #2

No trick questions

Traditional assessment tools use trick questions and puzzles for the screening, which creates a lot of frustration among candidates about having to go through irrelevant screening assessments.

View sample questions

The main reason we started Adaface is that traditional pre-employment assessment platforms are not a fair way for companies to evaluate candidates. At Adaface, our mission is to help companies find great candidates by assessing on-the-job skills required for a role.

Why we started Adaface

Try practice test

Start 14-day free trial

Reason #3

Non-googleable questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

How we design questions

这些只是我们库中有10,000多个问题的一个小样本。关于此的实际问题 SQL Server测试将是不可行的.

🧐 Question
Medium Backup Strategy Backups Troubleshooting	Try practice test
As a DBA, you receive an alert notifying you that the production database has gone offline due to a severe issue. Fortunately, you have a proper backup strategy in place. The backups are performed as follows: 1. Full database backup every Sunday at 2:00 AM. 2. Differential backup every day at 2:00 AM, except Sunday. 3. Transaction log backup every hour. Today is Wednesday, and the failure occurred at 10:15 AM. You have the following backup files available: 1. Full backup: Full_Backup_Sun.bak taken on Sunday 2:00 AM. 2. Differential backups: Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak taken at 2:00 AM on their respective days. 3. Transaction log backups: Hourly backups from Sunday 3:00 AM until Wednesday 10:00 AM, like TLog_Backup_Wed_09.bak, TLog_Backup_Wed_10.bak. Given the RPO (Recovery Point Objective) of 15 minutes, which of the following sequences of restore operations would ensure minimal data loss? A: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then all Transaction Log backups from Wednesday. B: Full_Backup_Sun.bak, Diff_Backup_Tue.bak, then all Transaction Log backups from Tuesday and Wednesday. C: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM. D: Full_Backup_Sun.bak, then all Transaction Log backups from Sunday to Wednesday 10:00 AM. E: Full_Backup_Sun.bak, Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM.
Medium Optimizing Query Performance Indexing Join Optimization Execution Plans	Try practice test
You are managing a SQL Server database for a large e-commerce platform. The database contains the following tables: Users often run a query to retrieve all orders from a specific date along with customer details and a breakdown of each order. Lately, this query has been performing poorly, especially on days with a high volume of orders. Given this schema, which of the following changes would MOST LIKELY enhance the performance of this query? A: Create a non-clustered index on Orders(OrderDate, OrderID) and a clustered index on OrderDetails(OrderID). B: Create a clustered index on Orders(CustomerID, OrderDate) and a non-clustered index on OrderDetails(ProductName). C: Increase the size of the OrderDetails(ProductName) column and add more RAM to the SQL Server machine. D: Create a clustered index on Orders(OrderDate) and a non-clustered index on OrderDetails(OrderID, Quantity). E: Partition the Orders table on OrderDate and create a non-clustered index on OrderDetails(DetailID, Price).
Medium Transaction Isolation Transaction Isolation Levels Snapshot Isolation	Try practice test
You are managing a SQL Server instance that is experiencing performance degradation. After some analysis, you realize that the TempDB is under heavy stress due to numerous long-running transactions. Users have reported that some SELECT queries on a large table, named SalesData, are slower than expected. You consider implementing Snapshot Isolation to mitigate blocking issues. You're aware that Snapshot Isolation uses TempDB to store row versions. Given the situation, which combination of actions will help alleviate the stress on TempDB and enhance the performance of SELECT queries on SalesData? A: Move TempDB to a faster storage subsystem and enable Snapshot Isolation for SalesData. B: Increase the number of TempDB data files, shrink TempDB size, and enable Snapshot Isolation for the database. C: Implement Read Committed Snapshot Isolation (RCSI) for the database and partition the SalesData table. D: Reduce the TempDB size, implement table partitioning on SalesData, and enable Read Uncommitted isolation level for the SELECT queries. E: Create a non-clustered index on frequently queried columns of SalesData and enable row versioning for the entire database.
Medium Transaction Log Management Performance Tuning Log Management is-not-mysql	Try practice test
You are a DBA at a large company managing an SQL Server database which is crucial for daily operations. The database is configured with the Full recovery model. The database is experiencing considerable transaction log growth during business hours, which is impacting the disk space and performance. The following operations are performed on this database: 1. A large ETL process that runs every night, which transforms and loads data into several tables. 2. A data archiving job that runs every night, which removes old data from several tables. 3. Frequent read/write operations during the day as part of normal business operations. Given this scenario, which of the following strategies could help manage the transaction log growth effectively? A: Switch to the Simple recovery model. B: Schedule frequent log backup and cleanups during business hours. C: Shrink the transaction log file size during business hours. D: Increase the database file size.
Medium Multi Select JOIN GROUP BY	Try practice test
Consider the following SQL table: How many rows does the following SQL query return?
Medium nth highest sales Nested queries User Defined Functions	Try practice test
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
Medium Select & IN Nested queries	Try practice test
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
Medium Sorting Ubers Nested queries Join Comparison operators	Try practice test
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
Hard With, AVG & SUM MAX() MIN() Aggregate functions	Try practice test
Consider the following SQL table: How many tuples does the following query return?

	🧐 Question	🔧 Skill
	Medium Backup Strategy Backups Troubleshooting	3 mins SQL Server	Try practice test
As a DBA, you receive an alert notifying you that the production database has gone offline due to a severe issue. Fortunately, you have a proper backup strategy in place. The backups are performed as follows: 1. Full database backup every Sunday at 2:00 AM. 2. Differential backup every day at 2:00 AM, except Sunday. 3. Transaction log backup every hour. Today is Wednesday, and the failure occurred at 10:15 AM. You have the following backup files available: 1. Full backup: Full_Backup_Sun.bak taken on Sunday 2:00 AM. 2. Differential backups: Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak taken at 2:00 AM on their respective days. 3. Transaction log backups: Hourly backups from Sunday 3:00 AM until Wednesday 10:00 AM, like TLog_Backup_Wed_09.bak, TLog_Backup_Wed_10.bak. Given the RPO (Recovery Point Objective) of 15 minutes, which of the following sequences of restore operations would ensure minimal data loss? A: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then all Transaction Log backups from Wednesday. B: Full_Backup_Sun.bak, Diff_Backup_Tue.bak, then all Transaction Log backups from Tuesday and Wednesday. C: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM. D: Full_Backup_Sun.bak, then all Transaction Log backups from Sunday to Wednesday 10:00 AM. E: Full_Backup_Sun.bak, Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM.
	Medium Optimizing Query Performance Indexing Join Optimization Execution Plans	3 mins SQL Server	Try practice test
You are managing a SQL Server database for a large e-commerce platform. The database contains the following tables: Users often run a query to retrieve all orders from a specific date along with customer details and a breakdown of each order. Lately, this query has been performing poorly, especially on days with a high volume of orders. Given this schema, which of the following changes would MOST LIKELY enhance the performance of this query? A: Create a non-clustered index on Orders(OrderDate, OrderID) and a clustered index on OrderDetails(OrderID). B: Create a clustered index on Orders(CustomerID, OrderDate) and a non-clustered index on OrderDetails(ProductName). C: Increase the size of the OrderDetails(ProductName) column and add more RAM to the SQL Server machine. D: Create a clustered index on Orders(OrderDate) and a non-clustered index on OrderDetails(OrderID, Quantity). E: Partition the Orders table on OrderDate and create a non-clustered index on OrderDetails(DetailID, Price).
	Medium Transaction Isolation Transaction Isolation Levels Snapshot Isolation	3 mins SQL Server	Try practice test
You are managing a SQL Server instance that is experiencing performance degradation. After some analysis, you realize that the TempDB is under heavy stress due to numerous long-running transactions. Users have reported that some SELECT queries on a large table, named SalesData, are slower than expected. You consider implementing Snapshot Isolation to mitigate blocking issues. You're aware that Snapshot Isolation uses TempDB to store row versions. Given the situation, which combination of actions will help alleviate the stress on TempDB and enhance the performance of SELECT queries on SalesData? A: Move TempDB to a faster storage subsystem and enable Snapshot Isolation for SalesData. B: Increase the number of TempDB data files, shrink TempDB size, and enable Snapshot Isolation for the database. C: Implement Read Committed Snapshot Isolation (RCSI) for the database and partition the SalesData table. D: Reduce the TempDB size, implement table partitioning on SalesData, and enable Read Uncommitted isolation level for the SELECT queries. E: Create a non-clustered index on frequently queried columns of SalesData and enable row versioning for the entire database.
	Medium Transaction Log Management Performance Tuning Log Management is-not-mysql	3 mins SQL Server	Try practice test
You are a DBA at a large company managing an SQL Server database which is crucial for daily operations. The database is configured with the Full recovery model. The database is experiencing considerable transaction log growth during business hours, which is impacting the disk space and performance. The following operations are performed on this database: 1. A large ETL process that runs every night, which transforms and loads data into several tables. 2. A data archiving job that runs every night, which removes old data from several tables. 3. Frequent read/write operations during the day as part of normal business operations. Given this scenario, which of the following strategies could help manage the transaction log growth effectively? A: Switch to the Simple recovery model. B: Schedule frequent log backup and cleanups during business hours. C: Shrink the transaction log file size during business hours. D: Increase the database file size.
	Medium Multi Select JOIN GROUP BY	2 mins SQL	Try practice test
Consider the following SQL table: How many rows does the following SQL query return?
	Medium nth highest sales Nested queries User Defined Functions	3 mins SQL	Try practice test
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
	Medium Select & IN Nested queries	3 mins SQL	Try practice test
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
	Medium Sorting Ubers Nested queries Join Comparison operators	3 mins SQL	Try practice test
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
	Hard With, AVG & SUM MAX() MIN() Aggregate functions	2 mins SQL	Try practice test
Consider the following SQL table: How many tuples does the following query return?

	🧐 Question	🔧 Skill	💪 Difficulty	⌛ Time
	Backup Strategy Backups Troubleshooting	SQL Server	Medium	3 mins	Try practice test
As a DBA, you receive an alert notifying you that the production database has gone offline due to a severe issue. Fortunately, you have a proper backup strategy in place. The backups are performed as follows: 1. Full database backup every Sunday at 2:00 AM. 2. Differential backup every day at 2:00 AM, except Sunday. 3. Transaction log backup every hour. Today is Wednesday, and the failure occurred at 10:15 AM. You have the following backup files available: 1. Full backup: Full_Backup_Sun.bak taken on Sunday 2:00 AM. 2. Differential backups: Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak taken at 2:00 AM on their respective days. 3. Transaction log backups: Hourly backups from Sunday 3:00 AM until Wednesday 10:00 AM, like TLog_Backup_Wed_09.bak, TLog_Backup_Wed_10.bak. Given the RPO (Recovery Point Objective) of 15 minutes, which of the following sequences of restore operations would ensure minimal data loss? A: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then all Transaction Log backups from Wednesday. B: Full_Backup_Sun.bak, Diff_Backup_Tue.bak, then all Transaction Log backups from Tuesday and Wednesday. C: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM. D: Full_Backup_Sun.bak, then all Transaction Log backups from Sunday to Wednesday 10:00 AM. E: Full_Backup_Sun.bak, Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM.
	Optimizing Query Performance Indexing Join Optimization Execution Plans	SQL Server	Medium	3 mins	Try practice test
You are managing a SQL Server database for a large e-commerce platform. The database contains the following tables: Users often run a query to retrieve all orders from a specific date along with customer details and a breakdown of each order. Lately, this query has been performing poorly, especially on days with a high volume of orders. Given this schema, which of the following changes would MOST LIKELY enhance the performance of this query? A: Create a non-clustered index on Orders(OrderDate, OrderID) and a clustered index on OrderDetails(OrderID). B: Create a clustered index on Orders(CustomerID, OrderDate) and a non-clustered index on OrderDetails(ProductName). C: Increase the size of the OrderDetails(ProductName) column and add more RAM to the SQL Server machine. D: Create a clustered index on Orders(OrderDate) and a non-clustered index on OrderDetails(OrderID, Quantity). E: Partition the Orders table on OrderDate and create a non-clustered index on OrderDetails(DetailID, Price).
	Transaction Isolation Transaction Isolation Levels Snapshot Isolation	SQL Server	Medium	3 mins	Try practice test
You are managing a SQL Server instance that is experiencing performance degradation. After some analysis, you realize that the TempDB is under heavy stress due to numerous long-running transactions. Users have reported that some SELECT queries on a large table, named SalesData, are slower than expected. You consider implementing Snapshot Isolation to mitigate blocking issues. You're aware that Snapshot Isolation uses TempDB to store row versions. Given the situation, which combination of actions will help alleviate the stress on TempDB and enhance the performance of SELECT queries on SalesData? A: Move TempDB to a faster storage subsystem and enable Snapshot Isolation for SalesData. B: Increase the number of TempDB data files, shrink TempDB size, and enable Snapshot Isolation for the database. C: Implement Read Committed Snapshot Isolation (RCSI) for the database and partition the SalesData table. D: Reduce the TempDB size, implement table partitioning on SalesData, and enable Read Uncommitted isolation level for the SELECT queries. E: Create a non-clustered index on frequently queried columns of SalesData and enable row versioning for the entire database.
	Transaction Log Management Performance Tuning Log Management is-not-mysql	SQL Server	Medium	3 mins	Try practice test
You are a DBA at a large company managing an SQL Server database which is crucial for daily operations. The database is configured with the Full recovery model. The database is experiencing considerable transaction log growth during business hours, which is impacting the disk space and performance. The following operations are performed on this database: 1. A large ETL process that runs every night, which transforms and loads data into several tables. 2. A data archiving job that runs every night, which removes old data from several tables. 3. Frequent read/write operations during the day as part of normal business operations. Given this scenario, which of the following strategies could help manage the transaction log growth effectively? A: Switch to the Simple recovery model. B: Schedule frequent log backup and cleanups during business hours. C: Shrink the transaction log file size during business hours. D: Increase the database file size.
	Multi Select JOIN GROUP BY	SQL	Medium	2 mins	Try practice test
Consider the following SQL table: How many rows does the following SQL query return?
	nth highest sales Nested queries User Defined Functions	SQL	Medium	3 mins	Try practice test
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
	Select & IN Nested queries	SQL	Medium	3 mins	Try practice test
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
	Sorting Ubers Nested queries Join Comparison operators	SQL	Medium	3 mins	Try practice test
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
	With, AVG & SUM MAX() MIN() Aggregate functions	SQL	Hard	2 mins	Try practice test
Consider the following SQL table: How many tuples does the following query return?

Reason #4

1200+ customers in 75 countries

借助 Adaface，我们能够将初步筛选流程优化高达 75% 以上，为招聘经理和我们的人才招聘团队节省了宝贵的时间！

Brandon Lee, 人事主管, Love, Bonito

Try practice test

Start 14-day free trial

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment SQL Server测试 in your hiring process is that it is an elimination tool, not a selection tool. In other words: you want to use the test to eliminate the candidates who do poorly on the test, not to select the candidates who come out at the top. While they are super valuable, pre-employment tests do not paint the entire picture of a candidate’s abilities, knowledge, and motivations. Multiple easy questions are more predictive of a candidate's ability than fewer hard questions. Harder questions are often "trick" based questions, which do not provide any meaningful signal about the candidate's skillset.

Science behind Adaface tests

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the SQL Server测试 from your dashboard by entering their email address.

Public link: You can create a public link for each test that you can share with candidates.

API or integrations: You can invite candidates directly from your ATS by using our pre-built integrations with popular ATS systems or building a custom integration with your in-house ATS.

Reason #7

Detailed scorecards & benchmarks

查看样本记分卡

Try practice test

Start 14-day free trial

Reason #8

High completion rate

Adaface tests are conversational, low-stress, and take just 25-40 mins to complete.

This is why Adaface has the highest test-completion rate (86%), which is more than 2x better than traditional assessments.

Reason #9

Advanced Proctoring

Learn more

Preview this test

查看样本记分卡

About the SQL Server Assessment Test

Why you should use Pre-employment SQL Server Online Test?

The SQL Server测试 makes use of scenario-based questions to test for on-the-job skills as opposed to theoretical knowledge, ensuring that candidates who do well on this screening test have the relavant skills. The questions are designed to covered following on-the-job aspects:

编写有效的SQL查询并优化数据库性能
设计和实施数据库表，视图和存储过程
管理交易数据并确保数据完整性
配置和调整SQL Server以获得最佳性能
安装，升级和配置SQL Server实例
实施数据库同步和复制
理解和管理交易日志
监视和维护数据库绩效和健康
实施备份和恢复策略
确保SQL Server数据库并进行故障排除安全问题

Once the test is sent to a candidate, the candidate receives a link in email to take the test. For each candidate, you will receive a detailed report with skills breakdown and benchmarks to shortlist the top candidates from your pool.

What topics are covered in the SQL Server Online Test?

配置
此技能涵盖了配置SQL Server设置的知识，例如作为内存分配，网络协议和服务器选项。测量此技能很重要，因为它评估了候选人优化SQL Server安装的性能和安全性的能力。
数据库和数据库对象
此技能评估了候选人在创建，创建，，修改，管理数据库和数据库对象，例如表，视图和存储过程。评估此技能至关重要，因为它反映了候选人在SQL Server环境中有效组织和操纵数据的能力。
安装
此技能涉及安装SQL Server的过程，包括选择适当的安装选项并配置必要的组件。重要的是要衡量这项技能，因为它评估了候选人对安装过程的理解，以确保SQL Server成功而可靠的部署。
同步
此技能包括同步的能力使用复制或镜像等技术跨多个服务器或数据库的数据。衡量此技能至关重要，因为它证明了候选人在分布式数据库环境中保持一致和最新数据的能力。
交易日志
此技能与管理和分析有关SQL Server数据库中的事务日志。评估这项技能很重要，因为它可以确保候选人在系统故障中进行故障排除和恢复，并通过适当的日志管理维持数据完整性。
数据库监视和维护
此技能涉及使用各种工具和技术监视SQL Server数据库的性能，可用性和健康。衡量这项技能至关重要，因为它反映了候选人主动识别和解决性能问题的能力，确保了最佳数据库性能和可用性。
备份和恢复
此技能包括创建和创建和执行备份和恢复策略，以保护SQL Server数据库免受数据丢失，并在发生故障时恢复它们。评估这项技能很重要，因为它评估了候选人在保护关键数据和最大程度地减少停机时间方面的知识和熟练程度。
SQL Server数据库数据库安全性和故障排除
此技能涉及实施和维持可靠的安全性测量为了保护SQL Server数据库免于未经授权的访问并确保数据机密性。衡量此技能至关重要，因为它评估了候选人的能力，可以有效地识别和解决安全漏洞并解决问题。
存储区域网络（SAN）
此技能与SQL Server的合作有关利用存储区域网络（SAN）进行存储配置的数据库。评估此技能很重要，因为它反映了候选人对SAN技术的理解，确保了SQL Server环境的高效可靠存储管理。
Full list of covered topics
The actual topics of the questions in the final test will depend on your job description and requirements. However, here's a list of topics you can expect the questions for SQL Server测试 to be based on.
交易管理
数据建模
正常化
索引
查询优化
存储程序
视图
触发器
加入
子征服
表设计
服务器配置
查询执行计划
聚类和非簇索引
数据库安装过程
SQL Server实例
数据库镜像
日志运输
复制
数据库维护任务
监视工具和技术
备份策略
恢复模型
数据库安全措施
用户访问管理
SQL注射预防
加密和解密
高可用性技术
灾难恢复
SAN配置

Try practice test

Start 14-day free trial

What roles can I use the SQL Server Online Test for?

数据库管理员
SQL开发人员
PostgreSQL开发人员
数据分析师
软件工程师
商业智能分析师
数据工程师
数据架构师
数据仓库开发人员
ETL开发人员

How is the SQL Server Online Test customized for senior candidates?

For intermediate/ experienced candidates, we customize the assessment questions to include advanced topics and increase the difficulty level of the questions. This might include adding questions on topics like