Ruby, Rails & SQL Online Test

Q: What topics are covered in the Ruby, Rails & SQL Online Test?

红宝石基础知识 红宝石 铁轨基本面 铁轨MVC 轨道上的休息API SQL CRUD操作 SQL加入和索引 红宝石编码

About the test:

Ruby，Rails＆SQL Online测试使用基于方案的MCQ来评估候选者在Ruby编程语言，Rails Web Framework和SQL数据库中的熟练程度。该测试评估了候选人对诸如模型视图控制器架构，ActivereCord，数据库迁移，SQL查询和数据库设计原理等主题的理解。评估了候选人的使用Ruby和Rails与数据库，设计数据库模式以及编写优化且安全的SQL查询以进行数据操作和检索的能力。

Covered skills:

红宝石基础知识
铁轨基本面
轨道上的休息API
SQL加入和索引

红宝石
铁轨MVC
SQL CRUD操作
红宝石编码

Try practice test

Start 14-day free trial

9 reasons why

Adaface Ruby, Rails & SQL Test is the most accurate way to shortlist 红宝石开发人员s

Reason #1

Tests for on-the-job skills

The Ruby, Rails & SQL 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:

能够编写干净有效的红宝石代码
理解Ruby中面向对象的编程原理
熟练铁轨框架及其基础知识
铁轨中的模型视图控制器（MVC）体系结构
在铁轨中开发REST API的经验
熟悉SQL CRUD操作
了解SQL加入和索引
使用Ruby解决编码问题的能力

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多个问题的一个小样本。关于此的实际问题 Ruby，Rails＆SQL测试将是不可行的.

🧐 Question
Easy Arrays Strings Arrays Strings	Try practice test
Check the following Ruby code: We want the following execution result: - Commit - PR - Merge What should we replace __BLOCK__ with to achieve this?
Medium Class and Self OOPs	Try practice test
What is the execution result of the following Ruby code?
Easy Exceptions Exceptions OOPs	Try practice test
What is the result of following Ruby code:
Medium New Class OOPs Singleton	Try practice test
Check the following Ruby code: Which all of the following statements should replace __BLOCK__ to have "Marvel" as execution result? A: Sample.new.class.ciao B: Sample.class.new.ciao C: Sample.new.ciao D: Sample.ciao
Hard Movie query problem	Try practice test
Our intern created the following model scope and they want to use in this view: Which of these code snippets they use to fetch the correct results, and avoid the N+1 query issue?
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?
Easy Registration Queue Logic Queues	Solve
We want to register students for the next semester. All students have a receipt which shows the amount pending for the previous semester. A positive amount (or zero) represents that the student has paid extra fees, and a negative amount represents that they have pending fees to be paid. The students are in a queue for the registration. We want to arrange the students in a way such that the students who have a positive amount on the receipt get registered first as compared to the students who have a negative amount. We are given a queue in the form of an array containing the pending amount. For example, if the initial queue is [20, 70, -40, 30, -10], then the final queue will be [20, 70, 30, -40, -10]. Note that the sequence of students should not be changed while arranging them unless required to meet the condition. ⚠️⚠️⚠️ Note: - The first line of the input is the length of the array. The second line contains all the elements of the array. - The input is already parsed into an array of "strings" and passed to a function. You will need to convert string to integer/number type inside the function. - You need to "print" the final result (not return it) to pass the test cases. For the example discussed above, the input will be: 5 20 70 -40 30 -10 Your code needs to print the following to the standard output: 20 70 30 -40 -10
Medium Visitors Count Strings Logic	Solve
A manager hires a staff member to keep a record of the number of men, women, and children visiting the museum daily. The staff will note W if any women visit, M for men, and C for children. You need to write code that takes the string that represents the visits and prints the count of men, woman and children. The sequencing should be in decreasing order. Example: Input: WWMMWWCCC Expected Output: 4W3C2M Explanation: ‘W’ has the highest count, then ‘C’, then ‘M’. ⚠️⚠️⚠️ Note: - The input is already parsed and passed to a function. - You need to "print" the final result (not return it) to pass the test cases. - If the input is- “MMW”, then the expected output is "2M1W" since there is no ‘C’. - If any of them have the same count, the output should follow this order - M, W, C.

	🧐 Question	🔧 Skill
	Easy Arrays Strings Arrays Strings	2 mins Ruby	Try practice test
Check the following Ruby code: We want the following execution result: - Commit - PR - Merge What should we replace __BLOCK__ with to achieve this?
	Medium Class and Self OOPs	2 mins Ruby	Try practice test
What is the execution result of the following Ruby code?
	Easy Exceptions Exceptions OOPs	2 mins Ruby	Try practice test
What is the result of following Ruby code:
	Medium New Class OOPs Singleton	2 mins Ruby	Try practice test
Check the following Ruby code: Which all of the following statements should replace __BLOCK__ to have "Marvel" as execution result? A: Sample.new.class.ciao B: Sample.class.new.ciao C: Sample.new.ciao D: Sample.ciao
	Hard Movie query problem	4 mins Rails	Try practice test
Our intern created the following model scope and they want to use in this view: Which of these code snippets they use to fetch the correct results, and avoid the N+1 query issue?
	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?
	Easy Registration Queue Logic Queues	30 mins Coding	Solve
We want to register students for the next semester. All students have a receipt which shows the amount pending for the previous semester. A positive amount (or zero) represents that the student has paid extra fees, and a negative amount represents that they have pending fees to be paid. The students are in a queue for the registration. We want to arrange the students in a way such that the students who have a positive amount on the receipt get registered first as compared to the students who have a negative amount. We are given a queue in the form of an array containing the pending amount. For example, if the initial queue is [20, 70, -40, 30, -10], then the final queue will be [20, 70, 30, -40, -10]. Note that the sequence of students should not be changed while arranging them unless required to meet the condition. ⚠️⚠️⚠️ Note: - The first line of the input is the length of the array. The second line contains all the elements of the array. - The input is already parsed into an array of "strings" and passed to a function. You will need to convert string to integer/number type inside the function. - You need to "print" the final result (not return it) to pass the test cases. For the example discussed above, the input will be: 5 20 70 -40 30 -10 Your code needs to print the following to the standard output: 20 70 30 -40 -10
	Medium Visitors Count Strings Logic	30 mins Coding	Solve
A manager hires a staff member to keep a record of the number of men, women, and children visiting the museum daily. The staff will note W if any women visit, M for men, and C for children. You need to write code that takes the string that represents the visits and prints the count of men, woman and children. The sequencing should be in decreasing order. Example: Input: WWMMWWCCC Expected Output: 4W3C2M Explanation: ‘W’ has the highest count, then ‘C’, then ‘M’. ⚠️⚠️⚠️ Note: - The input is already parsed and passed to a function. - You need to "print" the final result (not return it) to pass the test cases. - If the input is- “MMW”, then the expected output is "2M1W" since there is no ‘C’. - If any of them have the same count, the output should follow this order - M, W, C.

	🧐 Question	🔧 Skill	💪 Difficulty	⌛ Time
	Arrays Strings Arrays Strings	Ruby	Easy	2 mins	Try practice test
Check the following Ruby code: We want the following execution result: - Commit - PR - Merge What should we replace __BLOCK__ with to achieve this?
	Class and Self OOPs	Ruby	Medium	2 mins	Try practice test
What is the execution result of the following Ruby code?
	Exceptions Exceptions OOPs	Ruby	Easy	2 mins	Try practice test
What is the result of following Ruby code:
	New Class OOPs Singleton	Ruby	Medium	2 mins	Try practice test
Check the following Ruby code: Which all of the following statements should replace __BLOCK__ to have "Marvel" as execution result? A: Sample.new.class.ciao B: Sample.class.new.ciao C: Sample.new.ciao D: Sample.ciao
	Movie query problem	Rails	Hard	4 mins	Try practice test
Our intern created the following model scope and they want to use in this view: Which of these code snippets they use to fetch the correct results, and avoid the N+1 query issue?
	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?
	Registration Queue Logic Queues	Coding	Easy	30 mins	Solve
We want to register students for the next semester. All students have a receipt which shows the amount pending for the previous semester. A positive amount (or zero) represents that the student has paid extra fees, and a negative amount represents that they have pending fees to be paid. The students are in a queue for the registration. We want to arrange the students in a way such that the students who have a positive amount on the receipt get registered first as compared to the students who have a negative amount. We are given a queue in the form of an array containing the pending amount. For example, if the initial queue is [20, 70, -40, 30, -10], then the final queue will be [20, 70, 30, -40, -10]. Note that the sequence of students should not be changed while arranging them unless required to meet the condition. ⚠️⚠️⚠️ Note: - The first line of the input is the length of the array. The second line contains all the elements of the array. - The input is already parsed into an array of "strings" and passed to a function. You will need to convert string to integer/number type inside the function. - You need to "print" the final result (not return it) to pass the test cases. For the example discussed above, the input will be: 5 20 70 -40 30 -10 Your code needs to print the following to the standard output: 20 70 30 -40 -10
	Visitors Count Strings Logic	Coding	Medium	30 mins	Solve
A manager hires a staff member to keep a record of the number of men, women, and children visiting the museum daily. The staff will note W if any women visit, M for men, and C for children. You need to write code that takes the string that represents the visits and prints the count of men, woman and children. The sequencing should be in decreasing order. Example: Input: WWMMWWCCC Expected Output: 4W3C2M Explanation: ‘W’ has the highest count, then ‘C’, then ‘M’. ⚠️⚠️⚠️ Note: - The input is already parsed and passed to a function. - You need to "print" the final result (not return it) to pass the test cases. - If the input is- “MMW”, then the expected output is "2M1W" since there is no ‘C’. - If any of them have the same count, the output should follow this order - M, W, C.

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 Ruby，Rails＆SQL测试 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 Ruby，Rails＆SQL测试 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 Ruby, Rails & SQL Assessment Test

Why you should use Pre-employment Ruby, Rails & SQL Online Test?

The Ruby，Rails＆SQL测试 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:

能够编写干净有效的红宝石代码
理解红宝石中面向对象的编程概念
使用Ruby在Rails框架上构建Web应用程序的经验
熟悉铁轨中的模型视图控制器（MVC）体系结构
在铁轨中设计和实施REST API的知识
熟练使用SQL执行CRUD操作
了解SQL连接和索引，以进行有效的数据库查询
使用Ruby解决复杂的编码问题的能力
具有代码管理版本控制系统的经验
精通编写可测试代码和单位测试用例

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 Ruby, Rails & SQL Online Test?

Ruby OOPS
Ruby Oops（object-obside-面向编程）是指候选人在Ruby中理解和应用面向对象的原理的能力，例如封装，继承和多态性。这项技能对于评估很重要，因为Ruby在很大程度上依赖于面向对象的编程概念并鼓励使用类和对象。
Rails基础
rails rails rails基础知识评估候选人对核心的了解Ruby在Rails框架上的概念和特征。这包括了解模型视图控制器（MVC）体系结构，路由，数据库迁移以及导轨中的基本CRUD操作。评估此技能至关重要，因为Rails是一个流行的Web应用程序框架。在Ruby中实现Ruby在Rails应用程序上使用的建筑模式。这包括设计和操纵模型，渲染视图以及通过控制器处理用户输入。评估这项技能有助于衡量候选人对Rails MVC结构的理解及其开发结构良好且可维护的Web应用程序的能力。
Rails中的REST API
Rails中的REST APIS评估候选人对使用Ruby在Rails上的Ruby进行建筑，消费和测试REST的API的知识。这包括了解REST原理，设计API端点，处理HTTP方法以及实施身份验证和授权。衡量此技能很重要，因为API在现代应用程序开发和集成中起着至关重要的作用。
sql crud操作
sql crud操作是指执行，读取，更新，更新，更新，更新，更新，更新，更新，更新，并使用SQL在数据库上删除操作。该技能应在测试中衡量，以评估候选人在编写SQL查询方面的熟练程度，以操纵数据并有效与数据库进行互动。
sql Joins and Indexes
<p> sql Joins and Indexes评估候选人对加入表的理解和使用SQL中的索引优化查询性能。这包括对不同类型的联接（内联接，外部连接等）的知识以及用于改善查询执行时间的索引的使用。评估此技能很重要，因为SQL是一种广泛用于关系数据库的语言，并且有效的查询对于确保数据库性能至关重要。
Ruby编码
Ruby编码是指候选人的能力编写干净，高效且结构良好的红宝石代码。这包括遵循编码约定，利用适当的数据结构和算法以及在Ruby开发中采用最佳实践。评估此技能有助于衡量候选人生产高质量代码和可维护软件解决方案的能力。
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 Ruby，Rails＆SQL测试 to be based on.
红宝石语法
Ruby中的变量和数据类型
红宝石中的控制流
Ruby中的功能和方法
Ruby中的类和对象
红宝石的遗传和多态性
导轨目录结构
铁轨中的路线
导轨中的模型和数据库
轨道上的景观和模板
控制器和铁轨中的行动
与Rails中的Restful API合作
铁轨中的用户身份验证和授权
使用SQL创建和操纵数据库表
在SQL中选择和过滤数据
在SQL中更新和删除数据
在SQL中加入多个表
索引和优化SQL查询
实施基本的红宝石编码问题
使用红宝石库和宝石
调试红宝石代码
Ruby中的错误处理和异常
使用RSPEC等框架测试红宝石代码
了解红宝石块和迭代器
在红宝石中使用阵列和哈希
文件I/O在Ruby中的操作
了解红宝石课程和模块
在铁轨模型之间实施关联
在铁轨项目中使用GIT版本控制
将铁轨应用程序部署到生产服务器
在铁轨中使用会议和饼干
在铁轨中实施分页和分类
SQL中的查询优化
在铁轨中创建数据库索引
在铁轨中部署安息的API
在铁轨中配置和使用缓存
创建和利用导轨插件
在铁轨中实施背景工作
与导轨中的外部API相互作用
处理铁轨中的数据库迁移
在Rails视图中创建和使用部分
在铁轨中实施嵌套资源
在铁轨中建造搜索功能
在导轨中实施文件上传
在铁轨中实施国际化
确保铁轨申请免受常见漏洞
在铁轨中使用JSON数据
优化红宝石代码以进行性能
在Rails视图中创建和使用辅助方法
在铁轨应用中使用环境变量
在铁轨中实施API版本控制
处理红宝石的并发和线程安全性
与Activerecord协会合作
在铁轨模型中实施数据验证
在铁轨中创建和消费网络服务
使用索引优化SQL查询
在SQL中实现全文搜索
了解SQL中的数据库归一化
在铁轨中实施交易管理
在Ruby中与时间和日期合作

Try practice test

Start 14-day free trial

What roles can I use the Ruby, Rails & SQL Online Test for?

红宝石开发人员
铁路开发商
ROR开发人员

How is the Ruby, Rails & SQL 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