Filter interviews by
I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.
To improve DB performance, optimize queries, use indexes, increase server resources, and implement caching.
Optimize queries by using proper indexing and avoiding unnecessary joins
Increase server resources like CPU, memory, and storage to handle larger workloads
Implement caching mechanisms to store frequently accessed data in memory for faster retrieval
Regularly monitor and tune the database for optimal performance
Consi...
The ideal frequency of index rebuild depends on the specific database and workload.
The frequency should be determined based on the rate of data modification and the performance impact of index rebuilds.
Indexes with high fragmentation or high levels of data modification may require more frequent rebuilds.
Monitoring and analyzing the database performance can help determine the optimal frequency.
Consider using maintenance...
To ensure automated index rebuild job runs on Sundays only, we can set a schedule in the job properties.
Open the job properties and go to the schedule tab
Set the schedule to run on Sundays only
Save the changes and test the job to ensure it runs as expected
Using DATEPART function to make decisions in IF block
DATEPART function extracts a specific part of a date/time value
dw parameter in DATEPART function returns the day of the week as a number
IF block can be used to execute a code block based on a condition
DATEPART(dw, getdate())=1 checks if the current day is Sunday
Top trending discussions
I applied via campus placement at Indian Institute of Technology (IIT), Jodhpur and was interviewed in Nov 2024. There were 2 interview rounds.
It consists of resume-based skill questions.
I want to join ICICI Bank because of its strong reputation in the banking industry and the opportunities for growth and development it offers.
ICICI Bank is one of the leading banks in India with a strong reputation for innovation and customer service
I am impressed by ICICI Bank's focus on technology and digital banking solutions
I believe that working at ICICI Bank will provide me with opportunities for career growth an...
I have worked on projects involving data analysis for marketing campaigns, customer segmentation, and sales forecasting.
Developed predictive models to optimize marketing strategies
Utilized clustering techniques for customer segmentation
Built time series models for sales forecasting
Time structure is a part of Environment that used as reference to measure and keep track . The structure of the time also a central . And overall the structure of time remains of the debate.
Mathematics and other questions
I applied via Naukri.com and was interviewed in Jul 2023. There were 5 interview rounds.
Simple maths & reasoning
English
They gives a topic... and some people are discussing on this topic.
I was interviewed in Aug 2022.
I wish to possess advanced Excel skills.
Advanced Excel functions such as VLOOKUP, Pivot Tables, and Macros
Data analysis and visualization using Excel
Efficient data entry techniques to save time and reduce errors
Ability to create custom templates and automate tasks
Familiarity with Excel shortcuts and hotkeys
Example: Using VLOOKUP to quickly match data from two different spreadsheets
I will use my technical knowledge to ensure accurate and efficient data entry.
I will utilize keyboard shortcuts to increase speed and accuracy
I will use data validation techniques to ensure accuracy
I will troubleshoot technical issues that may arise
I will use software programs such as Excel to organize and analyze data
I will stay up to date with the latest technology and software advancements
The technical department is responsible for managing and maintaining the technology infrastructure of an organization.
The technical department handles hardware and software issues
They ensure that all systems are up-to-date and secure
They provide technical support to employees
They may also be responsible for developing and implementing new technology solutions
Examples of roles in the technical department include IT supp...
Technical tools are used to simplify complex tasks and improve efficiency in various fields.
Technical tools are used in industries such as manufacturing, construction, and engineering to automate processes and increase productivity.
In the healthcare industry, technical tools such as electronic health records and medical imaging software are used to improve patient care and streamline operations.
In the financial sector,...
All apti type questions
You have to make 4/5 min to crack this one
I applied via Company Website and was interviewed in Nov 2021. There were 3 interview rounds.
I applied via Recruitment Consulltant
Logical Reasoning Quants English and SQL medium level
I applied via Approached by Company and was interviewed in Jan 2022. There were 2 interview rounds.
based on 1 review
Rating in categories
Software Developer
7
salaries
| ₹2.2 L/yr - ₹8.1 L/yr |
Android Developer
7
salaries
| ₹1.8 L/yr - ₹4 L/yr |
UI Developer
5
salaries
| ₹3 L/yr - ₹3.8 L/yr |
Front end Developer
5
salaries
| ₹2.2 L/yr - ₹4.6 L/yr |
Senior UI Developer
4
salaries
| ₹4.6 L/yr - ₹9.8 L/yr |
TCS
Infosys
Wipro
HCLTech