Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 2 interview rounds.
Data types are classifications of data that determine the type of values that can be stored and manipulated.
Data types define the characteristics of data such as size, range, and operations that can be performed on them.
Common data types include integers, floating-point numbers, strings, booleans, and arrays.
Examples: int age = 25, float salary = 5000.50, string name = 'John Doe', bool isEmployed = true, int[] numbers
A stored procedure is a precompiled set of SQL statements that can be executed on demand.
Stored procedures are stored in a database and can be called by applications or other stored procedures.
They are used to encapsulate and execute complex logic or tasks.
Stored procedures can accept input parameters and return output parameters or result sets.
They improve performance by reducing network traffic and optimizing query e...
TRUNCATE, DROP, and DELETE are SQL commands used to remove data from a table, but they differ in their functionality.
TRUNCATE is a DDL command that removes all rows from a table, but keeps the structure intact.
DROP is a DDL command that removes an entire table, including its structure and data.
DELETE is a DML command that removes specific rows from a table based on a condition.
TRUNCATE is faster than DELETE as it doesn...
SQL clauses are used to perform specific actions in a SQL query.
SELECT: retrieves data from a database
FROM: specifies the table(s) to retrieve data from
WHERE: filters the data based on specified conditions
GROUP BY: groups the data based on specified columns
HAVING: filters the grouped data based on specified conditions
ORDER BY: sorts the data based on specified columns
JOIN: combines rows from multiple tables based on re...
A primary key is a unique identifier for a record in a database table.
Primary key ensures each record in a table is unique.
It is used to establish relationships between tables.
Primary key can be a single column or a combination of columns.
It enforces data integrity and allows efficient data retrieval.
Examples of primary keys include social security numbers, email addresses, etc.
15 questions from verbal
like error spotting, synonyms, phrasal verbs
10 questions from reasoning
like blook relation, decoding
15 questions from quants
like boats and streams, number series, percentage, ratio
I applied via Walk-in and was interviewed in Jan 2024. There was 1 interview round.
Structured Query Language is a standardized programming language used to manage and manipulate databases.
SQL is used to retrieve, insert, update, and delete data in databases.
It is a declarative language, meaning users specify what they want to retrieve or manipulate without needing to specify how to do it.
Common SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
Example: SELECT * FROM employees WHER
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Stored Procedure is a precompiled collection of SQL statements that can be executed by calling the procedure name.
Stored Procedures can accept input parameters and return output parameters.
They can be used to encapsulate complex SQL logic for reusability and security purposes.
Stored Procedures can improve performance by reducing network traffic and optimizing query execution.
Example: CREATE PROCEDURE GetEmployeeDetails...
I applied via Naukri.com and was interviewed in Jul 2023. There were 5 interview rounds.
Little bit difficult no questions from RS agarwal
I applied via Recruitment Consulltant and was interviewed before Aug 2023. There were 3 interview rounds.
General knowledge, General Maths
Change management is the process of planning, implementing, and controlling changes to systems or processes in an organization.
Involves identifying the need for change
Planning and implementing the change
Communicating the change to stakeholders
Managing resistance to change
Evaluating the impact of the change
Service Level Agreement is a contract between a service provider and a customer that outlines the level of service expected.
Defines the services to be provided
Specifies the responsibilities of both parties
Outlines the metrics used to measure performance
Includes penalties for not meeting agreed-upon service levels
Can cover aspects like uptime, response time, and resolution time
Example: An SLA between a cloud service pro
My expectation is to utilize my skills and knowledge to effectively analyze security threats and vulnerabilities, and implement measures to protect the organization's assets.
Expectation to continuously monitor and analyze security threats
Ability to identify vulnerabilities and recommend solutions
Implementing security measures to protect assets
Collaborating with team members to enhance security posture
I am passionate about cybersecurity and believe in the mission and values of your organization.
I have a strong background in cybersecurity and am eager to apply my skills in a challenging environment.
I admire the innovative approach your organization takes towards security and want to be a part of that.
I have heard great things about the team culture and professional development opportunities here.
Lycatech Services interview questions for popular designations
I applied via Naukri.com and was interviewed in Apr 2022. There were 4 interview rounds.
Coding related to .Net, Javascript
I applied via Naukri.com and was interviewed in Jan 2022. There were 4 interview rounds.
GSM is a mobile communication standard that uses MSC to connect calls between mobile devices.
GSM stands for Global System for Mobile Communications
MSC stands for Mobile Switching Center
GSM is a digital cellular network used for mobile communication
MSC is responsible for routing calls and messages between mobile devices
GSM and MSC work together to provide seamless mobile communication
Example: When you make a call on you...
Normal aptitude question
I expect a salary that is competitive and commensurate with my skills and experience.
Research the average salary range for Switching Engineers in your area and industry.
Consider your qualifications, experience, and the value you can bring to the company.
Be prepared to negotiate and discuss benefits and other compensation factors.
Avoid giving a specific number unless pressed, focus on the overall package.
My family background is diverse and has influenced my values and perspectives.
My parents come from different cultural backgrounds, which has exposed me to different traditions and languages.
I have siblings who have pursued various careers, inspiring me to explore different paths.
My family has always emphasized the importance of education and continuous learning.
We have a strong sense of community and support for one an...
My strengths include strong technical skills, problem-solving abilities, and adaptability. My weaknesses include a tendency to be overly critical of my own work and a desire for perfection.
Strong technical skills: I have a deep understanding of switching technologies and protocols, allowing me to effectively design and troubleshoot network switches.
Problem-solving abilities: I am skilled at identifying and resolving co...
I am an experienced Switching Engineer with a strong background in network infrastructure and troubleshooting.
I have a Bachelor's degree in Computer Science and have been working in the networking field for over 5 years.
I have extensive knowledge of routing protocols such as OSPF and BGP, as well as experience with Cisco and Juniper switches.
I have successfully implemented network upgrades and optimizations, resulting ...
Top trending discussions
I applied via Referral and was interviewed in Apr 2022. There were 2 interview rounds.
Sorting arrays and lists of strings
Use built-in sorting functions like sorted() or sort()
Specify the key parameter to sort by a specific element in the strings
Use reverse=True to sort in descending order
posted on 16 Mar 2021
I applied via Approached by Company and was interviewed in Dec 2021. There were 2 interview rounds.
I applied via Referral and was interviewed in Jan 2022. There were 2 interview rounds.
based on 4 interviews
Interview experience
based on 45 reviews
Rating in categories
Senior Engineer
31
salaries
| ₹4 L/yr - ₹9.7 L/yr |
Engineer
26
salaries
| ₹3.6 L/yr - ₹7.5 L/yr |
SQL Developer
26
salaries
| ₹2.7 L/yr - ₹6 L/yr |
Team Lead
22
salaries
| ₹6.2 L/yr - ₹16.5 L/yr |
Software Developer
15
salaries
| ₹2.4 L/yr - ₹8 L/yr |
TCS
Wipro
Infosys
HCLTech