Virtual Employee Senior Consultant Interview Questions and Answers

Q1. Excel formulas i.e countif sumifs
Add your answer

Normal test with VARC Maths

Q1. About Principle consultancy
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Tell me about yourself Why HR after completing Bsc Computer Technology What do you know about Careernet Technologies Why are you look a job change?
Add your answer
Q2. Confirmation about the documents and salary discussion session
Add your answer

Q1. Related voip engineering
Add your answer
Q2. Related experience
Add your answer

Q1. Related knowledge
Add your answer
Q2. Related experience
Add your answer

Q1. Basic about HRMS process and policy Technical knowledge about SQL integrations How we deal with project management Customer Management
Add your answer

Q1. Question related to your work profile
Add your answer

Aptitude Test logical reasoning and grammatical

Q1. Explain the Big O n solution for finding second largest element in a integer array with out sorting
Ans. 
Use two variables to keep track of the largest and second largest elements in the array.
• Iterate through the array and update the variables accordingly.

• Handle edge cases like duplicates and empty arrays.

• Time complexity is O(n) as we only iterate through the array once.
Answered by AI
Add your answer
Q2. How do you get one to many mapping of permissions and user count from bridge table with many to many mapping of users to permissions
Ans. 
Use SQL query to join bridge table with users and permissions tables to get one to many mapping
• Join the bridge table with users table using user_id

• Join the bridge table with permissions table using permission_id

• Group by user_id and count the number of permissions for each user
Answered by AI
Add your answer

Q1. How do you store integer with any number greater than maximum integer possible for the RAM
Ans. 
Use external storage like hard drive or cloud storage to store integers exceeding RAM capacity.
• Store the integers in an external storage device such as a hard drive or cloud storage.

• Implement a paging system to swap data between RAM and external storage as needed.

• Use specialized data structures like B-trees or hash tables to efficiently access the stored integers.
Answered by AI
Add your answer
Q2. When do you choose Entity framework over ADO.NET and why
Ans. 
Entity framework is preferred for rapid development, code-first approach, and ORM capabilities.
• Entity Framework is preferred for rapid development as it eliminates the need to write SQL queries manually.

• Entity Framework supports code-first approach, allowing developers to define the model first and generate the database schema from it.

• Entity Framework provides Object-Relational Mapping (ORM) capabilities, making it eas...read more
Answered by AI
Add your answer