Amity University Interview Questions, Process, and Tips

Write a pivot dinamic column from rows in SQL server.

Q1. Clustered and non clustered indexing in SQL server
Ans. 
Clustered indexing physically reorders the data in the table, while non-clustered indexing creates a separate structure.
• Clustered indexing determines the physical order of data rows in a table based on the indexed column.

• Non-clustered indexing creates a separate structure that contains the indexed column's values and pointers to the actual data rows.

• Clustered indexes are faster for retrieval but slower for inserts and ...read more
Answered by AI
Add your answer
Q2. Nested loops in SQL server
Ans. 
Nested loops in SQL server are used to iterate through multiple levels of data.
• Nested loops are used when you need to iterate through a set of data within another set of data.

• They can be implemented using nested SELECT statements or JOIN clauses.

• Example: SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id WHERE t1.column = 'value'
Answered by AI
Add your answer

Repository pattern in asp.net core API

Q1. Tell me about yourself and your achievements so far.
Add your answer
Q2. "What percentage of your work was in talent acquisition and operations, respectively?"
Add your answer
Q3. What is the best way to source candidates through headhunting or other channels and how soon can you join?
Ans. 
The best way to source candidates is through a combination of headhunting and other channels, such as job boards and social media. I can join within a reasonable notice period.
• Utilize headhunting firms to target passive candidates with specific skill sets

• Post job openings on relevant job boards and company website to attract active candidates

• Utilize social media platforms like LinkedIn to network and engage with potent...read more
Answered by AI
Add your answer

Q1. Vice Chancellor / VP HR
Add your answer
Q2. Introduce yourself
Add your answer
Q3. Why do you want to join amity, tell 5 reasons.
Add your answer

Q1. They called me to finalize the emolument and sign the proposed offer letter.
Ans. I have been waiting for my offer letter for two weeks, even after signing all the necessary documents
Answered Anonymously
Add your answer

The first round was aptitude and it has 3 sections

They gave coding regarding java

Q1. Tell about Oops concepts
Ans. 
OOPs concepts are fundamental principles in object-oriented programming, including inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class. Example: class Dog extends Animal.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables and public methods.

• Polymorphism: Ability to present...read more
Answered by AI
Add your answer
Q2. Difference between method overloading and method overriding
Ans. 
Method overloading is having multiple methods in the same class with the same name but different parameters. Method overriding is having a method in a subclass with the same name and parameters as a method in its superclass.
• Method overloading is resolved at compile time based on the method signature, while method overriding is resolved at runtime based on the object type.

• Method overloading is used to provide different ...read more
Answered by AI
Add your answer

Q1. ChatGPT User Describe interview process ChatGPT The interview process typically consists of several stages designed to evaluate a candidate's suitability for a role. While the specifics can vary dependi...read more
Add your answer