APPSTEK SOLUTIONS Interview Questions and Answers

Q1. Basic questions about the experience and the product worked on
Add your answer

1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.

Q1. Self introduction
Add your answer
Q2. Okay with the SLA
Ans. 
SLA stands for Service Level Agreement, which outlines the level of service expected from a vendor.
• SLA defines the agreed upon level of service between a provider and a customer.

• It includes metrics like response time, uptime, and resolution time.

• SLAs are important for ensuring accountability and quality of service.

• Example: An SLA might specify that the vendor will respond to support tickets within 24 hours.
Answered by AI
Add your answer

Q1. What is the difference between DDL and DML?
Ans. 
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
• DDL is used to create, modify, and delete database objects such as tables, indexes, and views.

• DML is used to insert, update, delete, and retrieve data from database tables.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE...read more
Answered by AI
Add your answer
Q2. How to fetch a employee record with the second highest salary from the employees table?
Add your answer
Q3. What was one of the trickiest incident you have faced and how did you counter it?
Add your answer
Q4. How SQL is divided?
Ans. 
SQL is divided into Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL).
• Data Definition Language (DDL) - used to define the structure of database objects like tables, indexes, and views. Examples include CREATE, ALTER, DROP.

• Data Manipulation Language (DML) - used to manipulate data stored in the database. Examples include SELECT, INSERT, ...read more
Answered by AI
Add your answer
Q5. How would prepare an emplyees attendance record? Create charts and graphs regarding it.
Ans. 
To prepare an employee's attendance record, I would gather data on their attendance, create charts and graphs to visualize trends and patterns.
• Gather attendance data including dates, times, and reasons for absence or tardiness

• Create a spreadsheet or database to organize the data

• Use software like Excel or Tableau to create charts and graphs showing attendance trends

• Include metrics such as overall attendance rate, late a...read more
Answered by AI
Add your answer
Q6. Difference between SQL and MYSQL
Ans. 
SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.
• SQL is a standard language used to interact with databases, while MySQL is a specific database management system.

• SQL is an ANSI (American National Standards Institute) standard language, while MySQL is an open-source relational database management system.

• SQL can be used with various database ma...read more
Answered by AI
Add your answer
Q7. Define joins using examples.
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Joins are used in SQL to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: INNER JOIN retrieves rows from both tables where the join condition is met.

• Example: LEFT JOIN retrieves all rows from the left table and the matched rows ...read more
Answered by AI
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Why did you living your current organization?
Add your answer
Q3. What is your expected CTC?
Ans. 
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
• Research industry standards for similar positions

• Consider cost of living in the area

• Factor in benefits and bonuses offered by the company

• Be prepared to negotiate based on your value to the organization
Answered by AI
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a results-driven executive with over 10 years of experience in leading teams and driving business growth.
• Experienced executive with a proven track record of success

• Skilled in team leadership and business development

• Strong focus on achieving results and driving growth
Answered by AI
Add your answer
Q2. Why did you living your current organization?
Add your answer
Q3. How did you manage the night shift and traveling?
Ans. 
I managed the night shift and traveling by prioritizing rest, staying organized, and utilizing technology.
• Prioritized rest by ensuring adequate sleep during the day

• Stayed organized by planning ahead and packing essentials in advance

• Utilized technology for efficient communication and navigation while traveling
Answered by AI
Add your answer
Q4. What do you know about the EXL?
Ans. 
EXL is a leading operations management and analytics company that helps businesses improve performance.
• EXL offers services in areas such as finance and accounting, healthcare, insurance, and more

• They use advanced analytics and technology to drive business transformation

• EXL has a global presence with offices in multiple countries
Answered by AI
Add your answer
Q5. What is Insurance?
Ans. 
Insurance is a financial product that provides protection against potential risks and losses.
• Insurance involves an agreement between an individual or entity and an insurance company.

• The individual or entity pays a premium in exchange for coverage against specific risks, such as property damage, illness, or liability.

• Examples of insurance include health insurance, car insurance, life insurance, and property insurance.
Answered by AI
Add your answer
Q6. What do you know about the premium?
Ans. 
Premium refers to the amount of money an individual or business pays for an insurance policy.
• Premium is the cost of purchasing an insurance policy

• It is typically paid on a regular basis, such as monthly or annually

• The premium amount is determined by factors such as the type of insurance, coverage amount, and the individual's risk profile
Answered by AI
Add your answer
Q7. What is your current CTC and expectation?
Ans. 
My current CTC is $100,000 and I am looking for a 15% increase in my next role.
• Current CTC: $100,000

• Expectation: 15% increase

• Looking for opportunities in the range of $115,000 - $120,000
Answered by AI
Add your answer

Aptitude test to check grammar and English fluency. It has different types of questions like passage reading and give the answers of questions from the passage, email writing, essay, grammar sections with fill in the blanks and picture based scenario in which you have to write the steps.

Q1. Speed minimum 30.
Add your answer
Q2. Accuracy minimum 90 percent.
Add your answer

Q1. Discussion about the salary.
Add your answer
Q2. Fixing the package.
Add your answer

Easy Level DS Questions - 30 mins

Q1. Cloud Services related questions
Add your answer
Q2. ETL Based question
Add your answer

A comprehensive coding test which included job role simulation.

Advanced Cloud Services questions

Q1. Introduce yourself
Ans. 
I am a Senior Software Developer with 8 years of experience in full-stack development, specializing in Java and Angular.
• 8 years of experience in full-stack development

• Specialize in Java and Angular

• Strong problem-solving skills

• Experience working in agile environments
Answered by AI
Add your answer
Q2. Why did you leave your last organisation
Add your answer

It was Very Easy and HR was Very Friendly Nature

Q1. What Is OOOps and explain those?
Ans. 
OOOps stands for Out Of Order packets. It refers to packets that arrive at their destination out of sequence.
• OOOps can occur in network communication when packets are sent out of order and arrive at the destination in a different order than they were sent.

• This can lead to issues in data transmission and can cause delays in processing the information.

• One way to handle OOOps is by using sequence numbers in packets to ens...read more
Answered by AI
Add your answer
Q2. What is Exception Handling ?
Ans. 
Exception handling is a mechanism to handle runtime errors and prevent program crashes.
• It is a way to deal with unexpected errors or exceptional conditions in a program.

• Exceptions can be caught and handled using try-catch blocks.

• Common exceptions include NullPointerException, ArrayIndexOutOfBoundsException, and IOException.

• Handling exceptions properly can improve the robustness and reliability of a software application
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and experienced Virtual Relationship Manager with a passion for building strong connections and providing excellent customer service.
• Over 5 years of experience in virtual relationship management

• Skilled in communication, problem-solving, and relationship-building

• Proven track record of exceeding customer satisfaction goals

• Proficient in CRM software and virtual communication tools
Answered by AI
Add your answer
Q2. Why do you want to join
Ans. 
I am passionate about leveraging technology to enhance customer relationships and provide personalized solutions.
• Passionate about using technology to improve customer relationships

• Excited about providing personalized solutions

• Believe in the importance of virtual communication in today's digital world
Answered by AI
Add your answer