Creating SQL Questions: A Comprehensive Guide

Creating SQL questions on CodeJudge.io is a straightforward process that empowers recruiters to design assessments tailored to specific database query skills. Follow these steps to create SQL questions:

Step 1: Log in to the Codejudge recruiter page. Click on the “Questions” icon. Then go to the “My Company Questions” tab and in the filter section choose “SQL ”.

Then click on “Create Question”. 

Step 2: Click on Create Question button, which displays a pop-up showing different question type options and then select SQL.

Step 3: On selecting the SQL, it will display the Information page where you can enter Test Name,  Short Description and Duration of the test.

‍

Step 4: On clicking the “Next”, it will display the Question HTML page where you can enter the question in the Problem Description, enter the Test Case Name and points for test case. And write Description for the above questions.

‍

Step 5: Recruiters can set Query execution time Limit and give Examples of  Input and Output  with explanations for the better understanding of the questions.

‍

Step 6: You can enter important details for the candidate. Then save the information and you can preview the question in HTML. Then click on “Next”.

‍

Step 7: On clicking the Next button, you will be redirected to the Schema and Table page. Here you can option to select language(My SQL 5.6 and 8.0) and you can upload SQL File(max size 300kb).  And click on the “Next”.

‍

Step 8: You will be redirected to the Output and Tags page. It will display the Languages and solutions. You have the option to choose “Ignore row order while matching output”. Here you can see the output.

‍

Step 9: On clicking the Next button, it will display the Tags page which helps you in searching and organizing the questions by entering Job Role, Difficulty, Experience and Technology. And finally click on the ”Save Tags and Publish” button.

‍

Creating SQL questions on Codejudge allows recruiters to assess candidates' database query skills effectively. By following the steps outlined in this article, you can design SQL questions that accurately evaluate candidates' SQL proficiency.