Creating a SQL Question In Code Type Question

Creating a SQL Question In Code Type Question

Create new question

  1. Go to Question list page and click Create New button
  2. Then you will be redirected to question creation page, where you will be able to see different question types to select from.


  3. Select Coding Question type to create a coding question.

Question Content

  1. First of all, you can enter a title for your question. Title is not a required field. It is auto-generated from the content of the question if left empty. 



  2. After adding question title you can start on adding content to your question
     


    1. Using the add icon button we can add various types of content to our question as mentioned below.
    2. Text:- This options helps us add normal text to the question
    3. Code:- This options helps us add any code content to the question
    4. Image:- This options helps us add image to the question from our system storage
    5. Audio:- This option helps us add any audio url to the question
    6. Video:- This option helps us add any video url to the question
    7. Paste as Image:- This option helps us paste any copied image to the question from the clipboard
    8. Next button:- Using this button we can save the question content and then move to the next steps



    9. Using the three dot icon button on the right side of each input field we can manage the order of question content or delete the content.
    10. Using the arrow up icon button we can shift that content up by one block.
    11. Using the cross icon button we can remove that content block.
    12. Using the arrow down icon button we can shift that content up by one block.

Solutions (Optional) 

  1. Using the Add Solution button we can add a new solution to the question. It is optional step but really helpful in validating test cases. On clicking this button you will be able to see a pop up where you can fill details related to the solution you want to add.



  2. Solution Name:- You can specify the name you want to give to your solution. It is a required field.
  3. Language:- This dropdown menu will help you select the language for your solution among various programming languages options. This is also a required field. Select SQLite language.
  4. Solution Description:- You can add description for your solution.
  5. Solution:- You can enter the solution written in the selected language here.
  6. Save:- This button helps us to save the solution to the question.



  7. Visible to Candidate:- If we want the solution to be visible to the candidate while viewing the results we can check this checkbox or leave it unchecked if we don't want the solution to be visible to the candidate.
  8. Is Best solution:- We can select the best solution among all the added solutions using this radio button. By default this option is checked if only one solution is added.
  9. Using the eye-icon button we can view the solution.
  10. Using the play-icon button we can execute a solution against the testcases added to the question. This button will remain disabled if no testcases are present. 
  11. Using the edit-icon button we can edit a solution.
  12. Using the delete-icon button we can delete a solution.
  13. Previous:- This button helps us to go back to previous step.
  14. Next:- This button helps us to save the question.is button helps us to go to the next step.

Code Languages


  1. Select Programming Languages:- We can select all the listed programming languages or atleast one among them. Candidate will be able to code in any of the selected languages. By default C language is selected. All languages have a default template which candidates are able to see while attempting the question. We can always edit default language templates as per our need. So, for this question unselect other languages and select SQLite.
  2. Using the eye-icon button we can preview the language template that will be visible to the user while giving the assessment.
  3. Using the play-icon button we can run the language template against the testcases added to the question. This button remains disabled if no testcases are present.
  4. Using the edit-icon button we can edit a language's template. 



  5. Pre-Code Area:- Candidates are NOT able to edit this part of the template.
    Add applicable imports, class and data structure declarations here.
  6. Stub area:- Candidates are able to edit this part of the template.
    Add the code / function that candidate should work on here.
  7. Post-Code Area:- Candidates are NOT able to edit this part of the template.
    Add the driver code, main function here.
  8. Save:- Click on the save button to save the language template.

Test Cases     



  1. Name:- Title of the test case. This is a required field.
  2. Weight:- We can assign weightage to the test case according to the complexity of the test case. This is a required field.
  3. Test Case Type:- This dropdown menu helps us to set or limit the visibility of the test case.
    We can choose between the following options-
    Visible to candidate with full details:- Test case will be visible to the candidate with full details when he executes his solution while giving the assessment.
    - Partially visible to candidate (only pass/fail):- Only the Test case result, i.e., pass/fail will be visible to the candidate when he executes his solution while giving the assessment.
    - Not Visible:- Test case will not be visible to the candidate when he executes his solution while giving the assessment.
  4. Test Case Description:- We can add description to the test case.
  5. Inline/Upload:- This dropdown menu gives us the ability to either enter inline testcase's input/output text or upload a text file if the input/output text is too long.
  6. Test Case Input:- Test case input text. Any solution which is run against this testcase will consider this text as an input. This is a required field. 
    1. Table Creation Part:- Create the tables which are required according to the question.
      Example:- 
      CREATE TABLE employee (
          Employee_id int NOT NULL,
          Name varchar(255),
          Manager int
      );
    2. Data Insertion Part:- Then write the commands to insert the data in the tables according to the testcase.
      Example:-
      INSERT INTO employee (Employee_id, Name, Manager)
      VALUES (1, 'Rose', NULL),
      (2, 'Angela', 1),
      (3, 'Patrick', 2),
      (4, 'Lisa', 2),
      (5, 'Kimberly', 1),
      (6, 'Bonnie', NULL),
      (7, 'Michael', NULL),
      (8, 'Tod', NULL)
      ;

  7. Test Case Output:- Test case output text. Any solution which is run against this testcase will compare it's output with this output text in order to decide whether the testcase is passed or failed. This is a required field.

    View of final Testcase:


  8. Upload Test Case:- Click this button to upload a text file from your system storage.
  9. Using this cross-icon button we can remove the added text file.
  10. Generate Output:- Click this button to generate the output corresponding to the given input. Best solution is executed against the given input to get the output.
  11. Save:- Click this button to save the test case.



  12. Validate Testcases:- Click here to validate all testcases against the best solution added to the question.



Question Config

  1. Access Type:- This dropdown menu helps us limit the access of the question we are creating. This is a required field and by default access is provided to Public - All Admins
    1. Private - Collaborators Only
    2. Public - All Admins
  2. Complexity Level:- This dropdown menu helps us select the complexity level of the question. This is an optional field.
  3. Topics:- This input field helps us to create tags of the topics covered in the question. This is an optional field.
  4. Concepts:- This input field helps us to create tags of the concepts covered in the question. This is an optional field.
  5. Tags:- This input field helps us to create general tags for the question. This is an optional field.

Preview

You can now finally have a look and feel of the question in the preview step. After reviewing the question you can click on the Save button to save the question and redirect to question-details page:-.



 


    • Related Articles

    • Creating a code type question

      Create new question Go to Question list page and click Create New button Then you will be redirected to question creation page, where you will be able to see different question types to select from. 1. Single Select: Question with multiple options ...
    • Coding Question Time and Memory Specifications

      Code Runner Time and Memory Specifications Language Version Exec Time Limit (secs) Memory limit (MB) Bash Bash 5.0 30 512 C GCC 9.2.0, C11 standard 30 512 C++ GCC 9.2.0, C++11 standard 30 512 C# Mono 6.6.0.161 30 512 Go Go 1.13.5 30 512 Java OpenJDK ...
    • List of URLs to Whitelist in Firewall

      This following URLs should be allowed to pass through your firewall, these URLs are necessary for Pod to work properly: pod.ai pod-cdn.com api.pod.ai blogs.pod.ai cms.pod.ai deeplink.pod.ai event-api.pod.ai help.pod.ai notifications-api.pod.ai ...