Upload Button Icon Add office photos

Filter interviews by

Pyrotek India IT Analyst Interview Questions and Answers

Updated 11 May 2022

Pyrotek India IT Analyst Interview Experiences

1 interview found

IT Analyst Interview Questions & Answers

user image Anonymous

posted on 11 May 2022

Round 1 - One-on-one 

(3 Questions)

  • Q1. What is SQL and what is oracle?
  • Ans. 

    SQL is a programming language used to manage and manipulate relational databases. Oracle is a relational database management system.

    • SQL stands for Structured Query Language

    • It is used to manage and manipulate data in relational databases

    • Oracle is a popular relational database management system

    • It is used to store and manage large amounts of data

    • Oracle uses SQL as its primary programming language

  • Answered by AI
  • Q2. What is relational database management?
  • Ans. 

    Relational database management is the process of organizing and managing data stored in a relational database.

    • It involves creating tables to store data in a structured manner

    • Defining relationships between tables using keys

    • Manipulating data using SQL queries

    • Ensuring data integrity and security

    • Examples of relational database management systems include MySQL, Oracle, and Microsoft SQL Server

  • Answered by AI
  • Q3. What is 4G language?
  • Ans. 

    4GL is a high-level programming language designed for database management and application development.

    • 4GL stands for Fourth Generation Language

    • It is used for developing database applications

    • Examples include SQL, Oracle Forms, PowerBuilder, etc.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I want to learn neatly as SQL for better future.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Basic background questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected
Round 1 - Aptitude Test 

A question that is both tricky and simple.

Round 2 - Technical 

(1 Question)

  • Q1. Questions about biochemistry
Round 3 - Aptitude Test 

Questions based on both numerical data and case studies.

Round 4 - One-on-one 

(2 Questions)

  • Q1. Can you tell me about yourself?
  • Q2. What interests you in working for this company?
  • Ans. 

    I am interested in working for this company because of its innovative projects and strong reputation in the industry.

    • Innovative projects that challenge me to grow as a programmer

    • Strong reputation in the industry for quality work

    • Opportunities for career advancement and professional development

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Assignment 

Communication assignment
Basic grammar

Round 2 - Coding Test 

Easy questions 2 in mySQL and 2 in C# and 1 html,css,js combined

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't worry basic knowledge in programming is enough
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Basic background questions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Instahyre and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. DHCP where it is used
  • Ans. 

    DHCP is used to automatically assign IP addresses to devices on a network.

    • DHCP is used in both small and large networks.

    • It is commonly used in home networks to assign IP addresses to devices like computers, smartphones, and smart TVs.

    • DHCP is also used in enterprise networks to manage IP address allocation for a large number of devices.

    • It simplifies network administration by eliminating the need for manual IP address co...

  • Answered by AI
  • Q2. DHCP is Domain host control protocol

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Topics are normally math's, English and DI

Round 2 - Technical 

(1 Question)

  • Q1. Basic question coding and testing
Round 3 - HR 

(1 Question)

  • Q1. Expectation, location and role
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - Aptitude Test 

Gaming aptitude makes us to think out of box

Round 2 - Technical 

(1 Question)

  • Q1. Few technical questions of chosen domain and gaming aptitude
Round 3 - One-on-one 

(1 Question)

  • Q1. Aptitude round with common interview questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Company Website and was interviewed in Oct 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Basics OOPS question
  • Q2. Sorting without using inbuilt function
  • Ans. 

    Implement sorting algorithm without using inbuilt function

    • Implement bubble sort algorithm

    • Compare adjacent elements and swap if necessary

    • Repeat until array is sorted

    • Example: ['apple', 'banana', 'cherry'] -> ['apple', 'banana', 'cherry']

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just prepare yourself and calm while giving ur interview

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Spring boot annotations
Round 2 - Technical 

(1 Question)

  • Q1. Programming on String
Round 3 - HR 

(1 Question)

  • Q1. CTC discussion and remote opportunities

Pyrotek India Interview FAQs

How many rounds are there in Pyrotek India IT Analyst interview?
Pyrotek India interview process usually has 1 rounds. The most common rounds in the Pyrotek India interview process are One-on-one Round.
What are the top questions asked in Pyrotek India IT Analyst interview?

Some of the top questions asked at the Pyrotek India IT Analyst interview -

  1. What is SQL and what is orac...read more
  2. What is relational database manageme...read more
  3. What is 4G langua...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Saint-Gobain Interview Questions
4.0
 • 172 Interviews
GAO Tek Interview Questions
4.5
 • 162 Interviews
BCD Travel Interview Questions
4.3
 • 111 Interviews
View all
Executive Accountant
9 salaries
unlock blur

₹2 L/yr - ₹5.4 L/yr

Assistant Manager
7 salaries
unlock blur

₹6.4 L/yr - ₹13.7 L/yr

Design Engineer
7 salaries
unlock blur

₹2.1 L/yr - ₹6.3 L/yr

Quality Engineer
6 salaries
unlock blur

₹4.6 L/yr - ₹6.4 L/yr

Production & Planning Engineer
4 salaries
unlock blur

₹6 L/yr - ₹12 L/yr

Explore more salaries
Compare Pyrotek India with

Vesuvius

4.1
Compare

Saint-Gobain

4.0
Compare

Morgan Advanced Materials

3.8
Compare

Carborundum Universal Limited

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview