Databases

This page covers the databases that our platform offers. Many databases use SQL query language, so questions from one database to another might look similar. For databases that offer more than one query language, the exam will specify at the beginning which language will be used.

As with all our exams, the website will monitor the user by recording their webcam and screen. Both videos will be merged into one, allowing the employer to observe the candidate throughout the entire exam. This process helps prevent cheating by using chatbots, friends, or unauthorized resources. At the end of the exam, our AI will analyze the candidate's performance and compile a PDF report with relevant statistics to provide insights about the candidate. Additionally, a global PDF report will compare the results of all your candidates, create a ranking, and identify which candidate shows the most potential for your job offer.

There are several ways to send exams in this section to a candidate or potential employee:

1. Job Offer: You can attach any exam to your job offers. The candidate must pass the exam to be eligible to apply.
2. Email: You have the option to send the exam link directly to a candidate’s email. Once they click on the link, they can take the exam, and you will receive both the video and the PDF report.
3. Direct Messaging: On the message page or within the WorkFrater chat box, you can send the exam directly to your candidate. By clicking on the exam link, the candidate can complete the exam, and you will receive both the video and the PDF report.

The link to all our exams is here . Most of the following exams consist of multiple-choice questions. The user can select one correct answer from several options. Each question has a time limit, and users cannot skip a question to return to it later.

At the beginning of the exam, the website asks users general questions about their knowledge of the database and the query languages it uses. It will also ask users about examples of projects using that database they have worked on. The website will also ask users what fields they need to improve.

After this interview step, the real questions begin. For Level 1 Databases, the questions are generally divided as follows:

• Fundamentals: Types (SQL vs. NoSQL), basic structures (tables, documents, databases)
• Data Types: Types (integer, string, boolean, JSON, etc.), constraints (primary keys, not null)
• Basic Queries: CRUD (CREATE, READ, UPDATE, DELETE), syntax
• Filtering/Conditions: Filtering an SQL or NoSQL database with keywords and conditions
• Indexes: Performance improvements with indexes

Depending on the query languages and file formats a database uses, the questions will vary. Level 1 database exams do not require candidates to write queries or code in a compiler.

For Level 2 Databases, candidates typically encounter questions on:

• Advanced Querying: Joins (inner, left, right, full outer)
• Subqueries: Single-value subqueries, multi-value subqueries, correlated subqueries, etc.
• Optimization: Advanced indexes (B-tree, hash, bitmap), EXPLAIN statements
• Security and Access Control: Privileges, connections, SQL injections
• Backup and Recovery: Backup strategies, restoration, replication

Additionally, Level 2 programming language tests include simulated compiler questions, where users must input code to produce a specified output in the console.