Search Adaface test library by skills or roles
⌘ K

Adaface Sample MySQL Questions

Here are some sample MySQL questions from our premium questions library (10273 non-googleable questions).

Skills

🧐 Question

Medium

Count, Distinct, SubQuery
Solve
                                    Consider the following MySQL tables:
                                    
 image
                                    What will be the output of the following MySQL query?
                                    
 image

Options:

  • Second highest score
  • Two distinct score of students
  • Student with third highest score
  • Student with second highest score

Medium

Having, Group By
Solve
                                    Consider the following MySQL table. 
                                    
 image
                                    How many rows are returned for following MySQL query?
                                    
 image

Options:

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6

Medium

Exists Where
Solve
                                    Consider the following MySQL tables:
                                    
 image
                                    What cids are returned by the following MySQL query for the above instance of the tables?
                                    
 image

Options:

  • 0, 2
  • 0. 3
  • 0, 5
  • 1, 0
  • 1, 2
  • 1, 3
  • 1, 5
🧐 Question🔧 Skill

Medium

Count, Distinct, SubQuery
2 mins
MySQL
Solve

Medium

Having, Group By
2 mins
MySQL
Solve

Medium

Exists Where
2 mins
MySQL
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Count, Distinct, SubQuery
MySQL
Medium2 minsSolve
Having, Group By
MySQL
Medium2 minsSolve
Exists Where
MySQL
Medium2 minsSolve

Adaface questions are trusted by enterprises globally

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

We evaluated several of their competitors and found Adaface to be the most compelling. Great default library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
Join 1200+ companies in 75+ countries.
Essayez l'outil d'évaluation des compétences le plus candidat aujourd'hui.
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
Discute avec nous