AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Telecall Technology Application Support Engineer Interview Questions, Process, and Tips
Top Telecall Technology Application Support Engineer Interview Questions and Answers
- Q1. Nth Highest Salary in SQL. Fetch Duplicate records in SQL. Write shell script to print febonicci series.
- Q2. Write a shell script to check system health.
- Q3. Use For loop to fetch febonnici series
Telecall Technology Application Support Engineer Interview Experiences
2 interviews found
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.
(4 Questions)
- Q1. Nth Highest Salary in SQL. Fetch Duplicate records in SQL. Write shell script to print febonicci series.
- Ans.
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...
- Q2. Use dense rank function
- Ans.
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
- Q3. Use Having Clause
- Ans.
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
- Q4. Use For loop to fetch febonnici series
- Ans.
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.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Nov 2022. There were 2 interview rounds.
(5 Questions)
- Q1. Write a shell script to check system health.
- Ans.
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
- Q2. Highest salary in SQL
- Ans.
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...
- Q3. Duplicate records delete In sql
- Ans.
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.
- Q4. Grep command in unjx
- Ans.
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 (...
- Q5. Awk command in unux
- Ans.
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...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
3 Questions
- Q1. Do u have done any work in appkication support
- Q2. How u can improve ur skills
- Q3. Are u able to speak english
I applied via Naukri.com and was interviewed in Feb 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Introduction, qualification, experience, and family background
Interview Preparation Tips
Application Support Engineer Interview Questions & Answers
Tech Mahindra
Anonymous
posted on 30 Aug 2022
I applied via Approached by Company and was interviewed in Jul 2022. There were 2 interview rounds.
(5 Questions)
- Q1. Which technology you have worked ,explain in brief your day to day roles and responsibilities
- Q2. What do you know about SQL , Unix , explain in brief
- Ans.
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
- Q3. Tell all unix commands which are mostly used
- Ans.
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
- Q4. What you will do if application perform slow,
- Ans.
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
- Q5. Tell all SQL commands which you know
- Ans.
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
Interview Preparation Tips
- MS SQL Server
- Unix scripting
- Cloud
- Devops
- Redhat Linux
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.
Duration was 90 minutes and basic question were asked
Coding question was easy level topics are array and string
Selected
I applied via Instahyre and was interviewed before May 2023. There were 2 interview rounds.
ITIL process and monitoring jobs and reporting jobs
(1 Question)
- Q1. ITIL process and shell scripting
Selected
I applied via Walk-in and was interviewed before May 2023. There was 1 interview round.
(2 Questions)
- Q1. What is ITRS?uses?
- Ans.
ITRS is a software company that provides monitoring and analytics solutions for financial institutions.
ITRS provides real-time monitoring and analytics solutions for financial services firms.
Their products help organizations monitor the performance and availability of their IT systems.
Examples of ITRS products include Geneos, Capacity Planner, and Insights.
ITRS solutions are used by banks, trading firms, and other fina...
- Q2. What is AutoSys?used
- Ans.
AutoSys is a job scheduling and management tool used for automating and monitoring tasks in a computer system.
AutoSys allows users to define, schedule, and monitor jobs for various applications and processes.
It provides a centralized interface for managing job dependencies, alerts, and notifications.
AutoSys can be used to automate repetitive tasks, batch processes, and data transfers.
Examples of tasks that can be autom...
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Advantages of React.js
- Ans.
React.js offers advantages such as virtual DOM, reusable components, and efficient performance.
Virtual DOM allows for faster updates and improved performance.
Reusable components make it easier to maintain and scale applications.
Efficient performance due to its one-way data binding and component-based architecture.
Support for server-side rendering for improved SEO and performance.
Large community and ecosystem for suppor...
- Q2. Higher Order Functions
Skills evaluated in this interview
I applied via Naukri.com
It is a computer base test and we have numerical, verbal and logical reasoning question will be their
Discussion between a group of participants on a given topic
(2 Questions)
- Q1. Tell me about yourself
- Q2. Why should we hire you
(2 Questions)
- Q1. What programming languages are know by me
- Q2. Asking question on our familiar programming language
Interview Preparation Tips
- Python
Telecall Technology Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Application Development Analyst Interview Questions
- Application Development - Senior Analyst Interview Questions
- Application Development Associate Interview Questions
- Application Developer Interview Questions
- Applications Engineer Interview Questions
- Application Lead Interview Questions
- Application Support Analyst Interview Questions
- Senior Application Support Engineer Interview Questions
- Show more
Telecall Technology Application Support Engineer Interview Process
based on 2 interviews
Interview experience
Application Support Engineer Interview Questions from Similar Companies
Telecall Technology Application Support Engineer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Application Support Engineer
5
salaries
|  ₹4.5 L/yr - ₹6 L/yr |
|
Software Engineer
4
salaries
| ₹3.8 L/yr - ₹4.8 L/yr |
TCS
Accenture
Cognizant
Infosys
- Home >
- Interviews >
- Telecall Technology Interview Questions >
- Telecall Technology Application Support Engineer Interview Questions
