Search test library by skills or roles
⌘ K

About the test:

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

Covered skills:

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

9 reasons why
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

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
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
Solve
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
Solve
You are managing a SQL Server database for a large e-commerce platform. The database contains the following tables:
 image
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
Solve
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
Solve
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
Solve
Consider the following SQL table:
 image
How many rows does the following SQL query return?
 image

Medium

nth highest sales
Nested queries
User Defined Functions
Solve
Consider the following SQL table:
 image
Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
 image

Medium

Select & IN
Nested queries
Solve
Consider the following SQL table:
 image
Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
 image

Medium

Sorting Ubers
Nested queries
Join
Comparison operators
Solve
Consider the following SQL table:
 image
What will be the first two tuples resulting from the following SQL command?
 image

Hard

With, AVG & SUM
MAX() MIN()
Aggregate functions
Solve
Consider the following SQL table:
 image
How many tuples does the following query return?
 image
🧐 Question🔧 Skill

Medium

Backup Strategy
Backups
Troubleshooting

3 mins

SQL Server
Solve

Medium

Optimizing Query Performance
Indexing
Join Optimization
Execution Plans

3 mins

SQL Server
Solve

Medium

Transaction Isolation
Transaction Isolation Levels
Snapshot Isolation

3 mins

SQL Server
Solve

Medium

Transaction Log Management
Performance Tuning
Log Management
is-not-mysql

3 mins

SQL Server
Solve

Medium

Multi Select
JOIN
GROUP BY

2 mins

SQL
Solve

Medium

nth highest sales
Nested queries
User Defined Functions

3 mins

SQL
Solve

Medium

Select & IN
Nested queries

3 mins

SQL
Solve

Medium

Sorting Ubers
Nested queries
Join
Comparison operators

3 mins

SQL
Solve

Hard

With, AVG & SUM
MAX() MIN()
Aggregate functions

2 mins

SQL
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Backup Strategy
Backups
Troubleshooting
SQL Server
Medium3 mins
Solve
Optimizing Query Performance
Indexing
Join Optimization
Execution Plans
SQL Server
Medium3 mins
Solve
Transaction Isolation
Transaction Isolation Levels
Snapshot Isolation
SQL Server
Medium3 mins
Solve
Transaction Log Management
Performance Tuning
Log Management
is-not-mysql
SQL Server
Medium3 mins
Solve
Multi Select
JOIN
GROUP BY
SQL
Medium2 mins
Solve
nth highest sales
Nested queries
User Defined Functions
SQL
Medium3 mins
Solve
Select & IN
Nested queries
SQL
Medium3 mins
Solve
Sorting Ubers
Nested queries
Join
Comparison operators
SQL
Medium3 mins
Solve
With, AVG & SUM
MAX() MIN()
Aggregate functions
SQL
Hard2 mins
Solve
Reason #4

1200+ customers in 75 countries

customers in 75 countries
Brandon

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


Brandon Lee, 人事主管, Love, Bonito

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.

invite candidates
Reason #7

Detailed scorecards & benchmarks

查看样本记分卡
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.

test completion rate
Reason #9

Advanced Proctoring


Learn more

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配置

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

  • 管理SQL Server的存储区域网络(SAN)
  • 具有1 - 3年经验的数据库的性能调整
  • 实施高可用性和灾难恢复解决方案
  • 配置和管理数据库镜像和可用性组
  • 实施分区和索引策略
  • 故障排除和解决数据库性能问题
  • 实施数据加密和数据掩盖技术
  • 优化查询执行计划并使用查询提示
  • 实施数据库快照和仅阅读复制品
  • 创建和管理SQL Server代理作业以进行自动化
Singapore government logo

招聘经理认为,通过小组面试中提出的技术问题,他们能够判断哪些候选人得分更高,并与得分较差的候选人区分开来。他们是 非常满意 通过 Adaface 筛选入围的候选人的质量。


85%
减少筛查时间

SQL Server Hiring Test 常见问题解答

什么是SQL Server在线测试?

SQL Server在线测试是一项技能评估,可评估候选人与Microsoft SQL Server相关的知识和技能,该技术是一种用于存储和检索数据的关系数据库管理系统。该测试通常包括有关SQL Server功能,数据库设计,SQL查询等的问题。

我可以将多个技能结合在一起,为一个自定义评估吗?

是的,一点没错。自定义评估是根据您的职位描述进行的,并将包括有关您指定的所有必备技能的问题。

您是否有任何反交换或策略功能?

我们具有以下反交易功能:

  • 不可解决的问题
  • IP策略
  • Web Protoring
  • 网络摄像头Proctoring
  • 窃检测
  • 安全浏览器

阅读有关[Proctoring功能](https://www.adaface.com/proctoring)的更多信息。

如何解释考试成绩?

要记住的主要问题是评估是消除工具,而不是选择工具。优化了技能评估,以帮助您消除在技术上没有资格担任该角色的候选人,它没有进行优化以帮助您找到该角色的最佳候选人。因此,使用评估的理想方法是确定阈值分数(通常为55%,我们为您提供基准测试),并邀请所有在下一轮面试中得分高于门槛的候选人。

我可以使用该测试的经验水平?

每个ADAFACE评估都是为您的职位描述/理想候选角色定制的(我们的主题专家将从我们的10000多个问题的图书馆中选择正确的问题)。可以为任何经验级别定制此评估。

每个候选人都会得到同样的问题吗?

是的,这使您比较候选人变得容易得多。 MCQ问题的选项和问题顺序是随机的。我们有[抗欺骗/策略](https://www.adaface.com/proctoring)功能。在我们的企业计划中,我们还可以选择使用类似难度级别的问题创建多个版本的相同评估。

我是候选人。我可以尝试练习测试吗?

不,不幸的是,我们目前不支持实践测试。但是,您可以使用我们的[示例问题](https://www.adaface.com/questions)进行练习。

使用此测试的成本是多少?

您可以查看我们的[定价计划](https://www.adaface.com/pricing/)。

我可以免费试用吗?

我刚刚搬到了一个付费计划。我如何要求自定义评估?

customers across world
Join 1200+ companies in 75+ countries.
立即尝试最候选的友好技能评估工具。
g2 badges
Ready to use the Adaface SQL Server测试?
Ready to use the Adaface SQL Server测试?
logo
40 min tests.
No trick questions.
Accurate shortlisting.
术语 隐私 信任指南

🌎选择您的语言

English Norsk Dansk Deutsche Nederlands Svenska Français Español Chinese (简体中文) Italiano Japanese (日本語) Polskie Português Russian (русский)
ada
Ada
● Online
Previous
Score: NA
Next
✖️