WeCP lets you create a programming question on MS SQL Server so that you can ask candidates to write actual code and query a database to solve a problem, rather than just selecting a correct answer from a list of options.
To create a Database Programming Question on Microsoft SQL Server
Go to WeCP and log in to your account.
Click on the "Questions" tab at left menu bar
Click on the "Create a New Question" button on the top right.
Select "Database" as the question type.
Select the appropriate programming languages, in this case, MS SQL Server.
Enter the question statement, which should clearly explain the problem to the candidate. Make sure to provide all necessary information such as schema, sample database and any constraints or limitations.
Add any additional information or context to help the candidate better understand the question.
Create test cases to evaluate the candidate's solution. You should include edge cases and common scenarios to ensure that the candidate has written a robust solution.
Determine the evaluation criteria and assign points to each test case. You should also consider the quality of the code, such as readability, efficiency, and scalability.
Save your question and preview it to make sure it appears correctly.
Here are some tips to keep in mind when creating a database programming question on Microsoft SQL Server:
Clearly define the problem and any constraints or limitations.
Use real-world scenarios to make the question more relevant.
Provide sample data and expected output to help the candidate understand the problem.
Use test cases to evaluate the candidate's solution thoroughly.
Assign appropriate point values to each test case to reflect its difficulty and importance.
Consider factors such as code quality, efficiency, and scalability when evaluating the candidate's solution.
By following the above steps and guidelines on WeCP, you can create a high-quality database programming question on Microsoft SQL Server that will accurately assess a candidate's skills and knowledge.