Backend

 60 Minutes
 5 Questions


This test will assess a candidate's ability to write and execute Transact-SQL queries on a SQL Server database, Also, this test will assess a candidate's knowledge of the basics of Spring Boot. It will cover topics such as creating a Spring Boot application, configuring the application, and deploying the application. And finally, this test will assess a candidate's ability to work with data structures and manipulate data in Java. It will cover topics such as creating and manipulating arrays, linked lists, stacks, queues, and trees. It will also cover topics such as sorting and searching algorithms.


Example Question:

Coding
Consider the following Employee schema:
TABLE Employee
EmployeeID int NULL,
EmployeeName nvarchar(50) NULL,
ManagerID int NULL,
DepartmentID int NULL,
Salary float NULL
Please write a T-SQL query to display every employee along with his manager.
The following columns should be displayed
EmployeeName EmployeeName
Note:
- The manager is also an employee
- To view the table data, type: "select * from Employee" and press on Run SQL