Filter interviews by
I applied via Naukri.com and was interviewed before Sep 2022. There were 4 interview rounds.
Different types of joins include inner join, outer join, left join, and right join.
Inner join: Returns rows when there is a match in both tables
Outer join: Returns all rows when there is a match in one of the 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 table
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a target database or data warehouse.
Extract: Data is extracted from different sources such as databases, files, APIs, etc.
Transform: Data is cleaned, standardized, and transformed into a format suitable for analysis.
Load: The transformed data is loaded into a target...
Use a LEFT JOIN to find values without relationships in other tables.
Use a LEFT JOIN to join the table with other tables
Filter the results where the relationship is NULL
Improving database performance can be achieved through optimization of queries, indexing, hardware upgrades, and regular maintenance.
Optimize database queries by avoiding unnecessary joins and using appropriate indexes
Regularly monitor and tune the database for optimal performance
Consider hardware upgrades such as increasing memory or storage capacity
Implement caching mechanisms to reduce the load on the database serve
It is difficult to provide an exact number as it varies depending on the specific location and day of the week.
Burger sales can vary greatly depending on the popularity of the restaurant, day of the week, and time of year.
Fast food chains like McDonald's or Burger King may sell thousands of burgers in a day.
Local burger joints may sell a few hundred to a thousand burgers in a day.
Special events or promotions can also i...
Top trending discussions
posted on 3 Oct 2021
I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 4 interview rounds.
Google Sheets is a cloud-based spreadsheet program offered by Google as part of the Google Drive office suite.
Allows users to create and edit spreadsheets online
Offers collaboration features for real-time editing and commenting
Can import and export various file formats, including Microsoft Excel
Offers add-ons and scripts for automation and customization
Accessible from any device with internet connection
MDD & OMC are important parameters for soil compaction and moisture content.
MDD stands for Maximum Dry Density, which is the maximum density that can be achieved for a given soil compaction effort.
OMC stands for Optimum Moisture Content, which is the moisture content at which the maximum dry density can be achieved.
These parameters are important for determining the appropriate moisture content and compaction effort for...
The velocity of steel varies depending on the type and conditions.
The velocity of steel can range from 5000 to 6000 meters per second
The velocity of steel can be affected by factors such as temperature and pressure
The velocity of steel is important in industries such as construction and manufacturing
The cube test result in 7 days depends on the purpose of the test and the specific cube being tested.
The cube test can refer to various tests in different fields such as construction, engineering, and materials science.
For example, in construction, the cube test is used to determine the compressive strength of concrete cubes after 7 days of curing.
The result of the cube test can vary depending on factors such as the ty...
It was just a aptitude test
Managed a team to implement a new customer relationship management system
Led a team of 5 employees to successfully implement a new CRM system
Coordinated with IT department to ensure smooth integration of the system
Provided training to staff on how to use the new system effectively
I want to join the firm because of its strong reputation, opportunities for growth, and alignment with my career goals.
Strong reputation in the industry
Opportunities for career growth and development
Alignment with my career goals and values
I applied via Approached by Company and was interviewed before Apr 2021. There was 1 interview round.
I applied via Referral and was interviewed before Oct 2020. There were 5 interview rounds.
Non-PO refers to purchases made without a purchase order.
Non-PO purchases are made without a formal purchase order.
These purchases are typically made for urgent or small items.
Non-PO purchases may require additional approval or documentation.
Examples of Non-PO purchases include office supplies, travel expenses, and minor repairs.
FB03 is a transaction code in SAP used to display financial accounting documents.
FB03 is used to view accounting documents such as invoices, credit memos, and payment receipts.
It allows users to search for documents based on various criteria such as document number, posting date, and company code.
FB03 also provides options to display document details, line items, and accounting entries.
It is commonly used by finance an...
Fixed assets can be categorized into tangible and intangible assets.
Tangible assets include property, plant, and equipment (PPE), such as buildings, machinery, and vehicles.
Intangible assets include patents, copyrights, trademarks, and goodwill.
Fixed assets are long-term assets that are not intended for sale and are used in the production of goods or services.
Fixed assets are recorded on the balance sheet and are subje...
I applied via Walk-in and was interviewed in Oct 2020. There were 5 interview rounds.
I applied via Walk-in and was interviewed in Aug 2021. There were 2 interview rounds.
The questions where about matrix
I applied via Recruitment Consulltant and was interviewed before Feb 2021. There were 2 interview rounds.
based on 5 interviews
Interview experience
based on 48 reviews
Rating in categories
1-2 Yrs
Not Disclosed
10-12 Yrs
Not Disclosed
Associate Consultant
15
salaries
| ₹2.4 L/yr - ₹5.5 L/yr |
Sourcing Consultant
11
salaries
| ₹4 L/yr - ₹8.1 L/yr |
Consultant
9
salaries
| ₹4 L/yr - ₹9 L/yr |
Senior Consultant
8
salaries
| ₹7 L/yr - ₹13.3 L/yr |
Information Technology Recruiter
7
salaries
| ₹2 L/yr - ₹3.5 L/yr |
Wipro
Cognizant
Infosys
Tech Mahindra