Arcadia interview questions

The interview is pretty straightforward and it’s split by up to 3 parts: 1) SQL and database theory, pretty easy but it depends on interviewers, some of them may ask tricky questions. Apart from that: Indexes, tables, relations. You will be given a schema with two tables like Users and Logins and the interviewer can ask you to build some queries. 2) C# questions. This starts from Entity Framework questions and LINQ. Pretty simple, IEnumarable vs IQueryable, when the evaluation happens. Then goes basics of C# language itself. Common question set is: IDisposable, GC, reference vs value types with a question about strings, async/await, delegates. And some ASP.NET questions with HTTP methods/status codes 3) Frontend part. May include Angular, React or other framework based on a job requirement. VanillaJs and typescript questions like scopes, closures, object narrowing. RxJs question or two. That’s practically it.