Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

Online SQL Developer Subjective Test

Topics Covered

  • Concatenation Operator with joining
  • Arithmetic Operation
  • Joining with sorting
  • Aggregate Function
  • Joining with Sorting
  • Joining With Aggregate Function
  • Removing Duplicate Rows
  • Joining with conditional Statement
  • Joining with Concatenated Non-NULL Values From a Group
  • Comparison Conditions With Joining
  • Case Statement with Aggregate function
  • Nested Select Statements With Joining
  • Multiple Tables & Joining

Useful for hiring

  • SQL Server Developer
  • MS SQL Server developer
  • Database Application Developer

Start hiring job-fit candidates using this assessment

GET A DEMO

"We are impressed by the caliber, depth, and breadth of the assessments provided by Interview Mocha. With Interview Mocha's online proctoring & powerful reports, we are able to hire quality candidates overcoming geographical barriers."

Megan Akhras, J'Excelle,Canada,
Co-founder & director
Question

Write a query to find the email address and skill names of the each job seekers whose skills matches with the required skills for jobs posted one hour ago.
Few lines in the query are missing (//Write your query here).You need to complete the query to get the output.

Table: JobSeeker

JobSeekerID Name Email
1 Max max@gmail.com
2 Peter peter@yahoo.com
 
Table: Skills
SkillID SkillName
1 C#
2 PHP
3 Java
 
Table: JobSeekerSkills
ID JobSeekerID SkillID
1 1 2
2 2 1
3 2 3
 
 Table: JobAdvertisement
ID JobDescription RequiredSkillID PostingDate
1 Software development by C# 1 2017-02-20 03:15:34
2 Software development by PHP 2 2017-02-20 04:31:48
3 Software development by Java 3 2017-02-20 03:31:54


Complete the query given below: 

 "SELECT JobSeeker.Email,   AS 'Skill Name',

FROM  JobSeeker
INNER JOIN JobSeekerSkills ON JobSeekerSkills.JobSeekerID = JobSeeker.JobSeekerID

INNER JOIN JobAdvertisement ON JobAdvertisement.RequiredSkillID = JobSeekerSkills.SkillID
WHERE 
GROUP BY JobSeeker.Email "

Question

Write a query to find names the menus which are accessible to John.
Few things in the query are missing (//Write your query here); you need to complete the query to get the output.

Table: User

UserID UserName
1 Cristiano
2 John
 
Table: Role
RoleID RoleName
1 Admin
2 Client
 
Table: UserRole
ID UserID RoleID
1 1 1
2 2 2
3 1 2
 
Table: Menu
MenuID MenuName
1 Dashboard
2 Product
3 Reports 

Table: MenuPermission
ID MenuID RoleID Status
1 1 1 1
2 1 2 0
3 2 1 1
4 2 2 1
5 3 1 1
 
Complete the query given below:

SELECT  
FROM User
LEFT JOIN  UserRole ON user_role.UserID = User.UserID

LEFT JOIN MenuPermission ON MenuPermission.RoleID = Role.RoleID

 "

Test details:

SQL quiz advanced test enables employers and recruiters to identify potential SQL developers by evaluating working skills and job readiness. For this reason, we have moved on from the MCQ and developed a new simulator known as Descriptive Simulator which evaluates candidates Descriptive/Subjective Answers and grades them automatically.

Test Duration- 40 Minutes

10 Application Questions

Test description:

To solve this major problem of guesswork in tests, Interview Mocha has launched its unique innovative tool - “The Descriptive Test Simulator” that can evaluate essay type answers. By the use of online Descriptive test simulator, candidates will be able to write one-word answers, short essay type, and long essay type answers. These answers are evaluated through our descriptive assessment engine. This reduces guesstimates in online assessments and gives results sharper than ever. 

The SQL developer test is a subjective test which is specially designed and developed to effectively check the descriptive knowledge related to SQL through our proper descriptive simulator assessment. The SQL quiz online test is reviewed, qualified and validated by our Subject Matter Experts (SMEs).


SQL developer interview test contains questions on following Topics: 
 

  • Concatenation Operator with joining

  • Arithmetic Operation, Joining with sorting

  • Aggregate Function, Joining with Sorting

  • Joining With Aggregate Function

  • Removing Duplicate Rows, Joining with conditional Statement

  • Joining with Concatenated Non-NULL Values From a Group

  • Comparison Conditions With Joining

  • Case Statement with Aggregate function

  • Nested Select Statements With Joining

  • Multiple Tables & Joining

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO