Search test library by skills or roles
⌘ K

Adaface Sample SQL Questions

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

Skills

Others

Embedded Systems Agile/Scrum Cyber Security SAP ABAP SAP HANA SAP Fiori SAP GRC SAP QM SAP SuccessFactors Salesforce Developer Salesforce Administrator Boomi Dynamics 365 SCM Dynamics 365 Finance Dynamics 365 Customer Service Dynamics 365 Sales Dynamics 365 Customer Voice Dynamics 365 Commerce Dynamics AX Spark Adobe InDesign Oracle Hyperion Planning Customer Support ITIL Blue Prism SAS SCCM SSAS SSIS SSRS Citrix Google AdWords Weblogic Talend UML Human Resource Management Talent Acquisition Power Apps RPA CISCO CISCO DCIM French Apache NiFi Apache Pig TIBCO Spotfire TIBCO Business Studio TIBCO Administration TIBCO ActiveMatrix BPM TIBCO Hawk TIBCO Apache Tomcat Oracle Hyperion Financial Management Oracle Fusion Oracle AIA Oracle APEX Oracle BPM Oracle Apps Oracle Financial Apps Oracle OAF Oracle SOA SAP Hybris SAP BusinessObjects SAP BI SAP PowerDesigner SAP PowerBuilder SAP Leonardo SAP MDM SAP MDG SAP BW SAP SRM SAP UI5 SAP MM SAP HCM SAP BTP (SCP) SAP PI SAP PP SAP Basis SAP SD SAP WM SAP PS SAP BODS SAP DBM SAP Litmos SAP FICO Loadrunner WPF WebFOCUS Ranorex Informatica Data Quality GDPR RabbitMQ Gradle Grunt EJB SnapLogic SharePoint Progress (OpenEdge) Informatica B2B Data Exchange Informatica MDM Joomla Ionic Liferay Sqoop Computer Literacy Communication Skills Technical Support Ecommerce Analytics Software Support Growth Marketing Marketing Analysis Digital Marketing Product Marketing SEO Outreach Market Research Jira German Italian Spanish Grammar & Vocabulary Listening Comprehension Reading Comprehension Sentence Structure
🧐 Question

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

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

Trusted by recruitment teams in 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 library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
customers across world
Join 1500+ companies in 80+ countries.
Try the most candidate friendly skills assessment tool today.
g2 badges
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
logo
40 min tests.
No trick questions.
Accurate shortlisting.
ada
Ada
● Online
Previous
Score: NA
Next
✖️