Filter interviews by
I was interviewed before Feb 2024.
Notice period is 2 months. Seeking new challenges and growth opportunities.
Notice period is 2 months
Looking for new challenges and growth opportunities
Current organization lacks opportunities for career advancement
Use SQL query with subquery to fetch second highest salary of an employee in Oracle.
Use ORDER BY and LIMIT to get the second highest salary.
Use a subquery to exclude the highest salary and then find the maximum from the remaining salaries.
Example: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
Use a subquery to fetch and delete duplicate records in Oracle SQL.
Use a subquery to identify duplicate records based on a unique identifier
Use the DELETE statement with the subquery to remove the duplicate records
Ensure to backup the data before deleting duplicates
Primary key uniquely identifies a record in a table, while foreign key establishes a link between two tables.
Primary key is a column in a table that uniquely identifies each record.
Foreign key is a column in a table that refers to the primary key in another table.
Primary key cannot have NULL values, while foreign key can have NULL values.
Primary key ensures data integrity and enforces uniqueness, while foreign key main...
I will investigate the root cause, communicate with stakeholders, and work on resolving the issue as quickly as possible.
Investigate the logs to identify the root cause of the issue
Communicate with stakeholders about the downtime and expected resolution time
Work on resolving the issue by troubleshooting and fixing the underlying problem
Implement preventive measures to avoid similar downtime in the future
I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.
SQL query to find Nth highest salary, fetch duplicate records, and shell script for Fibonacci series.
To find Nth highest salary in SQL, use the 'ROW_NUMBER()' function with 'ORDER BY' and 'LIMIT'. Example: SELECT salary FROM (SELECT salary, ROW_NUMBER() OVER (ORDER BY salary DESC) AS rn FROM employees) AS temp WHERE rn = N;
To fetch duplicate records in SQL, use the 'GROUP BY' and 'HAVING' clauses. Example: SELECT colum...
Dense rank function assigns a rank to each row within a partition of a result set, with no gaps in the ranking values.
Use the DENSE_RANK() function in SQL to assign a unique rank to each row within a partition
It is similar to the RANK() function but does not leave gaps in the ranking values
Example: SELECT column1, DENSE_RANK() OVER (PARTITION BY column2 ORDER BY column3) AS dense_rank FROM table_name
The HAVING clause is used in SQL to filter groups based on a specified condition.
HAVING clause is used with the GROUP BY clause to filter groups based on a specified condition
It is used to filter the results after grouping has been done
It is similar to the WHERE clause but operates on grouped records
Using a for loop to fetch the Fibonacci series.
Initialize variables for the first two numbers in the series (0 and 1).
Use a for loop to calculate the next number in the series by adding the previous two numbers.
Store each number in the series in an array.
Continue the loop until reaching the desired length of the series.
I applied via Naukri.com and was interviewed before Nov 2022. There were 2 interview rounds.
A shell script to check system health
Check CPU usage using 'top' or 'ps' command
Check memory usage using 'free' or 'top' command
Check disk usage using 'df' command
Check network connectivity using 'ping' command
Check system load using 'uptime' command
Check running processes using 'ps' command
The highest salary in SQL can vary depending on factors such as location, experience, and industry.
The highest salary in SQL is typically found in roles such as database administrators, data engineers, and data architects.
Factors that can influence the highest salary include the candidate's level of experience, the location of the job, and the industry.
For example, a senior database administrator in a major tech hub li...
To delete duplicate records in SQL, you can use the DELETE statement with a subquery.
Identify the duplicate records using a SELECT statement with GROUP BY and HAVING clause.
Create a subquery to select the duplicate records.
Use the DELETE statement with the subquery to delete the duplicate records.
Grep command is used in Unix to search for specific patterns in files.
Grep stands for Global Regular Expression Print.
It is a powerful command-line tool for searching text files.
It uses regular expressions to match patterns.
Grep can search for patterns in a single file or multiple files.
It can also search recursively in directories.
Grep has various options to control the search behavior.
Some common options include -i (...
Awk command in Unix is a powerful text processing tool used for extracting and manipulating data.
Awk command is used for pattern scanning and processing of text files.
It allows you to specify patterns and actions to be performed on those patterns.
Awk operates on a line-by-line basis, processing one line at a time.
It can be used to extract specific columns from a file, perform calculations, and generate reports.
Awk uses...
Top trending discussions
I applied via Naukri.com and was interviewed in Feb 2021. There was 1 interview round.
posted on 30 Aug 2022
I applied via Approached by Company and was interviewed in Jul 2022. There were 2 interview rounds.
SQL is a database language used to manage data. Unix is an operating system used for servers and workstations.
SQL is used to create, modify, and query databases.
Unix is a command-line interface used for file management, process control, and networking.
SQL can be used with various database management systems like MySQL, Oracle, and SQL Server.
Unix commands include ls, cd, grep, and chmod.
SQL and Unix are commonly used i
Commonly used Unix commands
ls - list directory contents
cd - change directory
mkdir - make directory
rm - remove files or directories
cp - copy files or directories
mv - move or rename files or directories
grep - search for patterns in files
cat - concatenate and display files
chmod - change file permissions
ssh - secure shell remote login
I will investigate the root cause of the slow performance and take appropriate actions.
Check server resources usage
Analyze application logs
Identify bottleneck areas
Optimize database queries
Implement caching mechanisms
Upgrade hardware or software if necessary
Common SQL commands for data manipulation and retrieval
SELECT - retrieve data from a table
INSERT - insert data into a table
UPDATE - update existing data in a table
DELETE - delete data from a table
CREATE - create a new table or database
ALTER - modify the structure of a table
DROP - delete a table or database
JOIN - combine data from multiple tables
GROUP BY - group data based on a specific column
ORDER BY - sort data based
I applied via Walk-in and was interviewed in Aug 2023. There were 3 interview rounds.
I applied via Company Website and was interviewed in Feb 2023. There were 3 interview rounds.
DSA and stakeholder management
Tackling end users involves effective communication, patience, and problem-solving skills.
Listen actively to understand their issues
Communicate clearly and patiently
Provide step-by-step instructions or guidance
Empathize with their frustrations
Offer solutions or workarounds
Follow up to ensure the issue is resolved
How to write code regarding customer
Case study regarding related to project
Application project management
I applied via Referral and was interviewed in Oct 2021. There were 4 interview rounds.
CGST stands for Central Goods and Services Tax.
CGST is a tax levied on the supply of goods and services within a state.
It is a part of the Goods and Services Tax (GST) system in India.
The revenue collected from CGST is shared between the central and state governments.
CGST rates vary depending on the type of goods or services being supplied.
For example, the CGST rate for essential goods like food items is lower than tha
Application Support Engineers are responsible for troubleshooting and resolving technical issues related to software applications.
Provide technical support to end-users and clients
Identify and resolve software bugs and errors
Collaborate with development teams to enhance application functionality
Document and maintain knowledge base articles for troubleshooting
Monitor application performance and identify areas for improv
based on 4 interviews
Interview experience
based on 10 reviews
Rating in categories
Application Support Engineer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Accenture
Wipro
Cognizant