Arevuk Advisory Services Interview Questions and Answers

A basic aptitude test was conducted comprising of java logical resoaning and maths.

It was a GD where along with discussion of particular topic some tech questions were also asked.

Q1. SQL type of joints.
Ans. 
SQL joints are used to combine rows from two or more tables based on a related column between them.
• Types of SQL joints include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left t...read more
Answered by AI
Add your answer

Q1. What was your last project and the tables that were in the database.
Ans. 
My last project was a web application for a retail company. The database had tables for customers, products, orders, and inventory.
• Tables in the database: customers, products, orders, inventory

• Example: customers table had columns for customer ID, name, email, and address

• Example: products table had columns for product ID, name, price, and quantity

• Example: orders table had columns for order ID, customer ID, product ID, a...read more
Answered by AI
Add your answer

Q1. Life cycle of thread
Ans. 
Thread life cycle includes new, runnable, running, blocked, and terminated states.
• Thread is created in 'new' state

• It becomes 'runnable' when start() method is called

• Thread enters 'running' state when CPU starts executing its run() method

• It can go to 'blocked' state if it's waiting for a resource

• Finally, thread reaches 'terminated' state when run() method completes or stop() method is called
Answered by AI
Add your answer
Q2. İnternal working of hash map
Ans. 
Hash map is a data structure that stores key-value pairs and uses a hash function to map keys to their corresponding values.
• Hash map consists of an array of buckets, each containing a linked list of key-value pairs.

• When inserting a key-value pair, the hash function is used to determine the index of the bucket where the pair should be stored.

• To retrieve a value, the hash function is used to find the corresponding bucket...read more
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer
Q2. Why I want to change the job
Ans. 
Seeking new challenges, growth opportunities, and a better work-life balance.
• Looking for new challenges and opportunities to learn and grow

• Seeking a better work-life balance

• Interested in working with new technologies or in a different industry

• Wanting to advance career progression
Answered by AI
Add your answer

Q1. Operation of management
Ans. 
Operation of management involves planning, organizing, leading, and controlling resources to achieve organizational goals.
• Planning involves setting goals and determining the best course of action to achieve them.

• Organizing involves arranging resources and tasks to achieve the goals efficiently.

• Leading involves motivating and guiding employees to work towards the goals.

• Controlling involves monitoring progress and making...read more
Answered by AI
View 1 more amswer
Q2. Fild problem today days complete
Ans. 
The problem of today's society is complex and multifaceted.
• Social inequality

• Climate change

• Political polarization

• Mental health issues

• Technological advancements
Answered by AI
View 1 more amswer
Q3. Time salary office saracular, management studies.
Add your answer

Q1. Hhhhhh thwtj ytjetjykrhjeyjryhmrhmrhkry
Add your answer
Q2. Efketjetjegdgntj hjetjt heth
Add your answer

Q1. Basic questions
Add your answer
Q2. Question related to your skills mentioned in CV
Add your answer

Q1. Basic accounting
Add your answer
Q2. Shares and crypto currency
Add your answer

Q1. Basic introduction
Add your answer
Q2. Salary discussion
Add your answer

Q1. Past job Experience
Add your answer
Q2. Salary Expactation
Add your answer

How will you take your buisness grow

Q1. What is a important with sales
Ans. 
Building relationships, understanding customer needs, effective communication, closing deals
• Building relationships with customers is crucial for long-term success

• Understanding customer needs and providing solutions tailored to them is key

• Effective communication skills help in conveying the value of products/services

• Closing deals efficiently and effectively is important for achieving sales targets
Answered by AI
Add your answer
Q2. How will take buisness grow
Ans. 
Our business will grow through strategic partnerships, expanding our product line, and increasing our marketing efforts.
• Forming strategic partnerships with other companies to reach new markets and customers

• Expanding our product line to offer more options and attract a wider customer base

• Increasing our marketing efforts through social media, advertising, and promotions
Answered by AI
Add your answer

MCQ's related to DSA, OOPS, DBMS, OS
And a coding question

Q1. Introduction Coding question - buy and sell stock leetcode Coding question - zigzag leetcode Some cs fundamentals like OS, DBMS Python and React (which is in my resume) Math aptitute question
Add your answer

Q1. Introduction A coding question related to LinkedList
Add your answer

Q1. General question regarding your resume
Add your answer

Q1. 1 simple question that is print yes or no using for loop if a given number is present in the list
Ans. So I had answered it wrong knowingly because I didn't wanted to waste more of my time Simple 2 line code for this is Result = "no" For i in given_list : If i == given_number: Result = 'yes' Break print(result) I also provided other methods but the interviewer was expecting of a specific solutions my solutions was more easier That's below code if given_number in given_list: Print(yes) Els
Answered Anonymously
Add your answer