AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Lycatech Services Production Support Analyst Interview Questions and Answers
Lycatech Services Production Support Analyst Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 2 interview rounds.
(6 Questions)
- Q1. Self intro and about family remaining questions from sql what are joins and their types
- Q2. What are data types
- Ans.
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 ...
- Q3. What is stored procedure
- Ans.
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...
- Q4. Differentiate TRUNCATE , DROP , DELETE
- Ans.
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...
- Q5. What are all the clauses available in sql
- Ans.
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...
- Q6. What is primary key
- Ans.
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
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.
(3 Questions)
- Q1. Why are you looking for a change?
- Q2. What are your salary expectations?
- Q3. Tell me about yourself.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jun 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. All the questions were relevant to my domain knowledge.
Interview Preparation Tips
The rest is in the hands of the interviewer.
I applied via Approached by Company and was interviewed before Oct 2021. There were 3 interview rounds.
(2 Questions)
- Q1. Relevant experience in breief?
- Ans. Synopsis of work your are currently responsible for in the current job.
- Q2. Career highlights, Current role and responsibilities
- Ans. Read your Resume in style like Pro
(2 Questions)
- Q1. Hiring manager ask relevant questions
- Ans. Just keep it the way you can make a positive impression in the end.
- Q2. Career highlights and role and responsibilities
- Ans. Read resume in an impressive way
Interview Preparation Tips
I applied via Approached by Company and was interviewed before Mar 2021. There were 3 interview rounds.
(4 Questions)
- Q1. What are your salary expectations?
- Q2. What is your family background?
- Q3. Share details of your previous job.
- Q4. Tell me about yourself.
(1 Question)
- Q1. Question regarding JD
(1 Question)
- Q1. Question regarding JD
Interview Preparation Tips
(2 Questions)
- Q1. What's work of Arial cable
- Ans.
Arial cable is a type of cable used for transmitting audio and video signals.
Arial cable is commonly used in television broadcasting and home theater systems.
It is designed to transmit high-quality audio and video signals over long distances.
The cable is made up of multiple wires and is shielded to prevent interference from other electronic devices.
It is often used in conjunction with other cables, such as HDMI or coax...
- Q2. We need to use unormode cable on Ariel section
- Ans.
Unormode cable is required for Ariel section.
Unormode cable is a type of cable that is used for high voltage transmission.
It is designed to withstand extreme weather conditions and is suitable for use in aerial sections.
The cable is made up of multiple layers of insulation and is highly resistant to damage.
Examples of applications where unormode cable is used include power transmission lines, wind turbines, and solar p...
Selected
I appeared for an interview before May 2024, where I was asked the following questions.
- Q1. Tell me about yourself
- Q2. What you have done in your previous org
- Ans.
In my previous role, I managed a team, improved processes, and drove successful projects that enhanced operational efficiency.
Led a team of 10 in executing a project that increased productivity by 20%.
Implemented a new inventory management system that reduced costs by 15%.
Conducted training sessions that improved team skills and morale.
Collaborated with cross-functional teams to streamline communication and project tim...
It was easy . I was able to crack on time
(2 Questions)
- Q1. JAva related questikon
- Ans.
Java is a versatile programming language used for building various applications, from web to mobile.
Java is object-oriented, promoting code reusability through classes and objects.
It has a rich API and extensive libraries, such as Java Collections Framework.
Java runs on the Java Virtual Machine (JVM), making it platform-independent.
Example: A simple Java program to print 'Hello, World!' uses the main method.
Java suppor...
- Q2. Dbms questipons
Assistant Manager Interview Questions & Answers
Aerial Telecom Solutions
Pintu Dhundhwal
posted on 28 Feb 2025
(2 Questions)
- Q1. Current Working
- Q2. Current CTC
Interview Preparation Tips
Assistant Manager Interview Questions & Answers
Tata Communications Transformation Services
Raghuram Mahata
posted on 25 May 2022
I applied via Naukri.com and was interviewed before May 2021. There was 1 interview round.
(3 Questions)
- Q1. Completely technical round of LTE
- Q2. Completely daily work related
- Q3. Trouble shooting knowledge
Interview Preparation Tips
Lycatech Services Interview FAQs
Tell us how to improve this page.
Lycatech Services Interviews By Designations
- Lycatech Services Production Support Analyst Interview Questions
- Lycatech Services Senior Engineer Interview Questions
- Lycatech Services Switching Engineer Interview Questions
- Lycatech Services Security Analyst Interview Questions
- Lycatech Services SQL Developer Interview Questions
- Lycatech Services Routing Engineer Interview Questions
Interview Questions for Popular Designations
- Assistant Manager Interview Questions
- Analyst Interview Questions
- Consultant Interview Questions
- Associate Consultant Interview Questions
- Senior Consultant Interview Questions
- Senior Analyst Interview Questions
- Technical Support Engineer Interview Questions
- Desktop Support Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
|
Senior Engineer
38
salaries
|  ₹4.4 L/yr - ₹10.5 L/yr |
|
SQL Developer
32
salaries
| ₹2.7 L/yr - ₹6 L/yr |
|
Engineer
30
salaries
| ₹3.6 L/yr - ₹7.5 L/yr |
|
Team Lead
22
salaries
| ₹9 L/yr - ₹14.1 L/yr |
|
Software Engineer
14
salaries
| ₹2.2 L/yr - ₹8.5 L/yr |
Ericsson
Nokia
ACT Fibernet
BT Group
- Home >
- Interviews >
- Lycatech Services Interview Questions
