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.