i
JK Tech
Filter interviews by
I applied via Referral and was interviewed before Oct 2020. There were 4 interview rounds.
Basic SQL queries such as delete, join, select are used to manipulate and retrieve data from databases.
DELETE: Removes data from a table based on a condition
JOIN: Combines data from two or more tables based on a related column
SELECT: Retrieves data from one or more tables based on a condition
Examples: DELETE FROM table_name WHERE condition; SELECT * FROM table1 JOIN table2 ON table1.column = table2.column;
Top trending discussions
I applied via Naukri.com and was interviewed in Feb 2021. There was 1 interview round.
posted on 28 Aug 2024
Union combines and removes duplicates, Union All combines without removing duplicates.
Union is used to combine the result sets of two or more SELECT statements and remove duplicates.
Union All is used to combine the result sets of two or more SELECT statements without removing duplicates.
Union is slower than Union All because it has to remove duplicates.
Use Union when you want to combine and remove duplicates, use Union...
posted on 22 May 2024
I applied via Naukri.com and was interviewed in Nov 2023. 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.
posted on 20 Dec 2024
It was Easy to medium . overall good
It was Medium to tough level
FIFO (First In, First Out) and LIFO (Last In, First Out) are inventory management methods.
FIFO: Items that are added first are the first to be removed. Like a queue.
LIFO: Items that are added last are the first to be removed. Like a stack.
I would focus on improving access to quality education for all citizens.
Implementing policies to ensure equal opportunities for education
Investing in infrastructure and resources for schools in underserved areas
Providing scholarships and financial aid for students from low-income families
Promoting vocational training programs to address skills gaps in the workforce
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 2 reviews
Rating in categories
Software Engineer
294
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
270
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Consultant
206
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
157
salaries
| ₹0 L/yr - ₹0 L/yr |
Consultant
113
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech