Upload Button Icon Add office photos

Filter interviews by

Protex Computer Interview Questions and Answers

Updated 18 Jun 2024

Protex Computer Interview Experiences

Popular Designations

2 interviews found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 15 Jul 2021

Interview Questionnaire 

4 Questions

  • Q1. All Basic DBMS and RDBMS Concepts
  • Q2. What is Aggregate Function?
  • Ans. 

    Aggregate functions perform calculations on a set of values and return a single value.

    • Used with SELECT statement to return a single value calculated from multiple rows

    • Examples include SUM, AVG, COUNT, MAX, MIN

    • Can be used with GROUP BY clause to group results by a specific column

  • Answered by AI
  • Q3. Different types of Join?
  • Ans. 

    Different types of Join in SQL

    • Inner Join - returns only matching rows from both tables

    • Left Join - returns all rows from left table and matching rows from right table

    • Right Join - returns all rows from right table and matching rows from left table

    • Full Outer Join - returns all rows from both tables

    • Cross Join - returns Cartesian product of both tables

  • Answered by AI
  • Q4. Difference between delete vs drop vs truncate?
  • Ans. 

    Difference between delete vs drop vs truncate

    • DELETE is used to remove specific rows from a table

    • DROP is used to remove an entire table from the database

    • TRUNCATE is used to remove all rows from a table

    • DELETE can be rolled back, DROP and TRUNCATE cannot be rolled back

    • DELETE is slower than TRUNCATE and DROP

  • Answered by AI

Skills evaluated in this interview

SQL Developer Interview Questions asked at other Companies

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
View answer (4)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Assignment 

Asked to write java MVC architecture and asked question on it.

Round 2 - Technical 

(6 Questions)

  • Q1. Give collection framework overview. Why should we use list over other collection methodologies?
  • Ans. 

    Collection framework provides interfaces and classes to store and manipulate groups of objects. Lists are preferred for ordered collections.

    • Lists maintain insertion order and allow duplicates

    • Lists provide indexed access to elements

    • Lists are suitable for scenarios where elements need to be accessed by index or need to be inserted/removed frequently

  • Answered by AI
  • Q2. Tell me about the JDK. Is Java runs on JDK or any other tool is required? Explain why?
  • Ans. 

    JDK stands for Java Development Kit. Java runs on JDK and no other tool is required.

    • JDK is a software development kit used for developing Java applications.

    • It includes tools such as Java compiler, JRE, and other development tools.

    • Java runs on JDK as it provides all the necessary tools and libraries for compiling, debugging, and running Java programs.

  • Answered by AI
  • Q3. Do you know JSP? Explain the lifecycle of JSP?
  • Ans. 

    Yes, JSP stands for JavaServer Pages. It is a technology used to create dynamic web pages.

    • JSP lifecycle includes translation, compilation, initialization, execution, and destruction phases.

    • During translation phase, JSP engine generates a servlet from the JSP page.

    • Compilation phase involves compiling the generated servlet into bytecode.

    • Initialization phase initializes the servlet, including calling the init() method.

    • Exe...

  • Answered by AI
  • Q4. Do you know struts? How do we use struts with Java?
  • Ans. 

    Struts is a framework used for developing Java web applications.

    • Struts is a framework that implements the Model-View-Controller (MVC) design pattern.

    • It provides a set of JSP custom tags to help developers create interactive web applications.

    • Struts configuration is typically done using XML files.

    • Struts actions are Java classes that handle requests from the user and interact with the model.

    • Struts is often used in combina...

  • Answered by AI
  • Q5. Do you have any idea of SQL? What is DDL and DML in SQL? Explain with example.
  • Ans. 

    Yes, SQL is a standard language for managing databases. DDL is for defining structure, DML is for manipulating data.

    • DDL stands for Data Definition Language and is used to define the structure of database objects like tables, indexes, etc.

    • DML stands for Data Manipulation Language and is used to manipulate data in the database like inserting, updating, deleting records.

    • Example of DDL: CREATE TABLE Employees (ID INT, Name...

  • Answered by AI
  • Q6. What are the different type of joins? Why we use joins and how?
  • Ans. 

    Different types of joins in SQL are inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is at least one match in both tables.

    • Left join: Returns all rows from the left table and the matched rows from the right table.

    • Right join: Returns all rows from the right table and the matched rows from the left table.

    • Full outer join: Returns rows when there is a match in one of the tables.

    • Join...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Protex Computer Software Developer interview:
  • Java, SQL
Interview preparation tips for other job seekers - You need at least one year of work experience.

Skills evaluated in this interview

Top Protex Computer Software Developer Interview Questions and Answers

Q1. Give collection framework overview. Why should we use list over other collection methodologies?
View answer (1)

Software Developer Interview Questions asked at other Companies

Q1. Maximum Subarray Sum Problem Statement Given an array of integers, determine the maximum possible sum of any contiguous subarray within the array. Example: Input: array = [34, -50, 42, 14, -5, 86] Output: 137 Explanation: The maximum sum is... read more
View answer (43)

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Jan 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. First question in hr interview is tell about yourself then the hr asked questions what I mentioned in my resume. So put the information in resume what you known well. My unique talent is I'm a stage spea...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold, be confident, don't put irrelevant information in your resume update yourself relating to your studies

I applied via Campus Placement and was interviewed before May 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. TELL ME ABOUT YOURSELF

Interview Preparation Tips

Interview preparation tips for other job seekers - JUST BE YOURSELF

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Description of project
  • Ans. 

    The project involved designing and implementing a new network infrastructure for a large corporation.

    • Conducted a thorough analysis of the existing network infrastructure

    • Designed a new network architecture that met the company's needs

    • Implemented the new network infrastructure with minimal disruption to business operations

    • Tested and optimized the new network to ensure optimal performance

    • Provided ongoing support and maint

  • Answered by AI
  • Q2. Your previous experince

Interview Preparation Tips

Interview preparation tips for other job seekers - Well prepare for your resume

I applied via Walk-in and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Its for FP&A process and the major questions were from the basics of FP&A. How it starts and how its ends and Previous job roles.

Interview Preparation Tips

Interview preparation tips for other job seekers - It's quite a moderate interview but be prepare for more rounds of technical interviews.

I applied via Campus Placement and was interviewed before Feb 2020. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. 1.Tell me about yourself.
  • Q2. 2. Some basic questions from DBMS, iot and cloud.
  • Q3. 3. Explain your project ( technology u have used and what is it).
  • Q4. 4. Are you willing to relocate.

Interview Preparation Tips

Interview preparation tips for other job seekers - HR was nice and friendly. Overall it was a NYC experience.
All the best guys.

I applied via Recruitment Consultant and was interviewed before Aug 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't tell what is written in your CV.

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Simple program
  • Q2. I wrote a simple program in C

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and confident

Protex Computer Interview FAQs

How many rounds are there in Protex Computer interview?
Protex Computer interview process usually has 2 rounds. The most common rounds in the Protex Computer interview process are Assignment and Technical.
How to prepare for Protex Computer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Protex Computer. The most common topics and skills that interviewers at Protex Computer expect are PLSQL and SIDE.
What are the top questions asked in Protex Computer interview?

Some of the top questions asked at the Protex Computer interview -

  1. Give collection framework overview. Why should we use list over other collectio...read more
  2. Do you know struts? How do we use struts with Ja...read more
  3. Do you have any idea of SQL? What is DDL and DML in SQL? Explain with examp...read more

Tell us how to improve this page.

Protex Computer Interview Process

based on 2 interviews

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.6k Interviews
Accenture Interview Questions
3.8
 • 8.3k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.6k Interviews
Amazon Interview Questions
4.1
 • 5.1k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
View all

Protex Computer Reviews and Ratings

based on 27 reviews

4.2/5

Rating in categories

4.2

Skill development

4.2

Work-life balance

3.4

Salary

4.1

Job security

4.2

Company culture

3.3

Promotions

4.1

Work satisfaction

Explore 27 Reviews and Ratings
Software Engineer
60 salaries
unlock blur

₹2.2 L/yr - ₹5 L/yr

Software Developer
19 salaries
unlock blur

₹1.7 L/yr - ₹6 L/yr

Junior Software Engineer
15 salaries
unlock blur

₹1.8 L/yr - ₹3 L/yr

Plsql Developer
9 salaries
unlock blur

₹1.5 L/yr - ₹3.5 L/yr

Database Admin
8 salaries
unlock blur

₹6.8 L/yr - ₹9 L/yr

Explore more salaries
Compare Protex Computer with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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