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×

Database, SQL Online Test

Topics Covered

  • SQL Data Types and Literals
  • SQL Operators
  • Views
  • Indexes
  • Nulls
  • SQL Functions
  • SQL Tables
  • Queries
  • Commands and clause
  • PL/SQL
  • DBMS Concepts
  • DDL
  • DML
  • DTL(TCL)

Useful for hiring

  • Junior SQL Developer
  • SQL Programmer
  • SQL Coder
  • SQL Database Administrator
  • SQL Admin

Start hiring job-fit candidates using this assessment


"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

SELECT name, course_id 
FROM instructor, teaches 
WHERE instructor_id = teaches_id; 

This query can be replaced by which one of the following query?

    • SELECT name, course_id 
      FROM   teaches, instructor 
      WHERE  instructor_id = course_id; 

    • SELECT name, course_id 
      FROM   instructor 
             natural JOIN teaches; 

    • SELECT name, course_id 
      FROM instructor; 

    • SELECT course_id 
      FROM instructor 
      JOIN teaches;


The table below shows a relationship for Prince University student database:

As a user and administrator of the prince university database and certain information are required from you from the database. Which is less likely viable?

    • The user of the database should be able to ask for a list of courses taken by a specific student

    • Ask for a list of students currently enrolled in a specific course

    • Ask for a list of students currently enrolled in all courses

    • Ask for a list of students not enrolled in all the courses

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

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates