Restricting SQL variants in assessments

Restricting SQL variants in assessments

While creating assessments with database query questions, the SQL variants available to the test takers can be restricted.

To restrict SQL variants while creating assessments, follow the below steps (as shown in the images):
  1. Click on "Advanced Options" and then click on "Database Questions Settings"

  1. Select the option "Restrict SQL variants for questions"


  1. Select the required SQL variants from list and then click on "Apply"


Now test takers will only see the SQL variants restricted by you.

Please note that restricting SQL variants will only work properly in the restricted variants are present in the question. Following are the possible cases and their corresponding behavior:

All restricted SQL variants are available in a question 
In this case all selected (restricted) SQL variants will be available for the test takers. The not-restricted (not-selected) SQL variants will not be available. 
 
Some of the SQL variants are available in a question 
In this case all selected and available (in question) SQL variants will be available for the test takers. The not-selected SQL variants will not be available. 
 
Some of the SQL variants are NOT available in a question 
In this case all selected and available (in question) SQL variants will be available for the test takers. The not-selected SQL variants will not be available. 
 
None of the restricted SQL variants are available in a question 
In this case all available (in question) SQL variants will be available for the test takers. No restriction will be applied.