In HackerRank Tests, Database (DB) Engineering questions assess the candidates' database querying knowledge in Microsoft SQL, MySQL, Oracle, or DB2 databases. The test setter designs these questions to understand the level of database programming skills in their candidates to store, modify or retrieve data by writing efficient queries.
Typically, the test setter defines the problem statement along with the data schema required to answer the question. It is recommended that you read the problem statement carefully before answering the question.
The HackerRank Test interface has an in-built database query editor and supports programming in Microsoft SQL, MySQL, Oracle, or DB2 databases.
Answering Database Questions
Here is a quick video to get you started with the Answering Database programming questions workflow.
- In your Test, select the Database Engineer question or click Solve.
- Read the problem statement carefully and refer to the given data schema, if any.
- In the code editor, choose the DB language. Only the permitted languages are displayed in this list. For example, if the test setter wants to assess your DB programming skills in SQL, you may see only the Microsoft SQL Server option available to answer the question.
- Write your query in the editor and click Run Query. Your answer is validated to return the expected output.
- Click Submit answer & continue to save your answer. You can revisit this question and change your submitted answer any number of times by clicking on Modify before the Test ends.
Note: Your test setter may organize the questions across different sections in the Test, and these sections can have specific time limits to complete and submit the answers. In some cases, if the time allocated for a section has elapsed or you have already submitted the answer, you will not be allowed to change the answer submissions.
See the following topics for detailed information: