In a project manager interview, you will be asked questions that will test your knowledge of people skills, technical abilities, and response to specific scenarios.
Oxane Partners Interview Rounds and Process
Basic Excel, Accounts and Critical Thinking MCQs
Acko General Insurance Interview Rounds and Process
Round duration – 75 Minutes Round difficulty – Medium
The round consisted of 2 Coding based based questions. These question were easy for as I have already done this while preparing.
Round duration – 60 Minutes Round difficulty – Easy
The interview started a bit late as I it to be at 11:30 am but started at 12:15pm So Had to wait. Apart from these the overall experience was great and the interviewer was also kind and had a smiling face.
Round duration – 30 Minutes Round difficulty – Easy
10:30 PM Interviewer was Cool.
Round duration – 5 minutes Round difficulty – Easy
At 10:00 am
What is an index?
Indexes help speed up searching in a database. If there is no index on a column in the WHERE clause, then the SQL Server has to skim through the entire table and check each and every row to find matches, which may result in slow operations in large data.
Indexes are used to find all rows matching with some columns and then to skim through only those subsets of the data to find the matches.
Syntax:
What do you know about magic tables in SQL Server?
A magic table can be defined as a provisional logical table that is developed by an SQL Server for tasks such as insert, delete, or update (DML) operations. The operations recently performed on the rows are automatically stored in magic tables. Magic tables are not physical tables; they are just temporary internal tables.
1 What are the techniques you may use to define the scope of a project?Â
With this question, the interview panel is trying to understand your knowledge in the concerned domain. You can explain these various concepts involved in defining the scope of the project that include â Product Breakdown, Requirement Analysis, Systems Engineering, Systems Analysis, Value Engineering, Value Analysis, and Alternatives Analysis.Â