Upload Button Icon Add office photos

Filter interviews by

Plex Systems Interview Questions and Answers

Updated 17 Jun 2021

Plex Systems Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 17 Jun 2021

I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What are indexes
  • Ans. 

    Indexes are database structures that improve the speed of data retrieval operations.

    • Indexes are created on one or more columns of a table.

    • They work like a book's index, allowing the database to quickly find the data.

    • Indexes can be clustered or non-clustered.

    • Clustered indexes determine the physical order of data in a table.

    • Non-clustered indexes are separate structures that point to the data.

    • Indexes can be unique or non-...

  • Answered by AI
  • Q2. What is OLTP, OLAP
  • Ans. 

    OLTP stands for Online Transaction Processing and OLAP stands for Online Analytical Processing.

    • OLTP is used for transactional processing of data in real-time.

    • OLAP is used for analytical processing of data for decision-making purposes.

    • OLTP databases are designed for high-speed data processing and retrieval.

    • OLAP databases are designed for complex queries and data analysis.

    • Examples of OLTP systems include banking systems,...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Product based company. So go only if you want.

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 questions from similar companies

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Programming

Interview Preparation Tips

Interview preparation tips for other job seekers - Interviewer had less knowledge on the current technologies and was more stereo type.

I appeared for an interview in Jul 2019.

Interview Questionnaire 

4 Questions

  • Q1. 1. Java questions basee on interfaces, Exception Handling, inheritance, Steam API;
  • Q2. 2. SQL questions related to joins, sub-queries, nth highest salary;
  • Q3.  3. Basic algorithms questions based on Arrays/Linked List.
  • Q4. 4. Puzzles based on basic aptitudes test.

Interview Preparation Tips

Interview preparation tips for other job seekers - I was interviewed for Java Developer. I had 4 rounds (all technical rounds). Each rounds comprises questions related to Java/Puzzles/Algorithms and my experience of project.

Go through your resume. Things should be relevant and one should have clear understanding of basics.

I applied via Naukri.com and was interviewed in Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is rotational shifts. What is web service flow. How will you check ports on Unix or Solaris machine.
  • Ans. 

    Rotational shifts refer to working in different shifts at different times. Web service flow is the sequence of steps involved in a web service request. Checking ports on Unix or Solaris machine involves using the netstat command.

    • Rotational shifts involve working in different shifts at different times, such as day shift, night shift, and swing shift.

    • Web service flow involves a sequence of steps, such as sending a reques...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Total pathetic experience. Have heard of negative reviews from a number of people, but didn't believed. Unfortunately had to share same pain with them. What job description is given to you, doesn't matters because you won't be asked for that. Your resume will get shortlisted and then it doesn't matter what u have covered up in your career path, because interview rounds will consist of questions out of your scope. Your resume doesn't needs to be shortlisted at first end if it doesn't suit thier needs. HR people, they are on another level. You share your resume to them, and they will never ever reply back to you. Not a single HR, but it seems everyone has same culture. You keep trying to connect them for support. But they will just keep finding smarter ways to avoid.

Skills evaluated in this interview

Interview Questionnaire 

9 Questions

  • Q1. System design of traffic signal
  • Ans. 

    Design a traffic signal system

    • Identify the number of lanes and intersections

    • Determine the traffic flow and peak hours

    • Choose appropriate sensors and controllers

    • Implement a synchronization algorithm

    • Consider emergency vehicle prioritization

    • Include pedestrian crossing signals

    • Ensure compliance with local regulations

  • Answered by AI
  • Q2. Data structures
  • Q3. Oops spring jdbc
  • Q4. Hashmap implementation
  • Ans. 

    Hashmap is a data structure that stores key-value pairs and provides constant time complexity for insertion, deletion, and retrieval.

    • Hashmap uses hashing function to map keys to indices in an array

    • Collisions can occur when multiple keys map to the same index, which can be resolved using separate chaining or open addressing

    • Java implementation: HashMap map = new HashMap<>();

  • Answered by AI
  • Q5. Pattern printing code
  • Ans. 

    Printing patterns using code

    • Identify the pattern to be printed

    • Use loops to print the pattern

    • Adjust the loop variables to control the pattern

    • Use conditional statements to modify the pattern

    • Examples: printing stars, triangles, squares, etc.

  • Answered by AI
  • Q6. Common point in linked list
  • Ans. 

    Common point in linked list refers to the node where two or more linked lists intersect.

    • The common point can be found by traversing both linked lists and comparing the nodes.

    • The common point can also be found by using two pointers, one for each linked list, and moving them until they meet at the common point.

    • Examples include finding the intersection point of two linked lists or finding the loop in a linked list.

  • Answered by AI
  • Q7. Optimization
  • Q8. Synchronisation
  • Q9. Threads

Skills evaluated in this interview

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

Interview Questionnaire 

1 Question

  • Q1. For java based profile, questions related to collections, usage of comparator, Class loading are asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong in basics of computer science like data structure and algorithms. Have a detailed understanding of java basics

Interview Questionnaire 

1 Question

  • Q1. Oops, core Java related questions, spring boot

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 50 minutes
Round difficulty - Medium

Yes consist of two code and questions MCQ of ds ,algo,Linz,shell,English and DBMS
Test happens with your webcam access.

  • Q1. 

    Nth Fibonacci Number Problem

    Calculate the Nth term in the Fibonacci sequence using the formula: F(n) = F(n-1) + F(n-2) where F(1) = F(2) = 1.

    Given a number N, determine the Nth Fibonacci number.

    Input...

  • Ans. 

    Calculate the Nth Fibonacci number using the given formula and constraints.

    • Implement a function to calculate the Nth Fibonacci number using the formula F(n) = F(n-1) + F(n-2) with base cases F(1) = F(2) = 1.

    • Use dynamic programming or recursion to efficiently compute the Fibonacci number for large N values.

    • Ensure the input N is within the constraints 1 <= N <= 10000.

    • Example: For N = 5, the output should be 5 as th

  • Answered by AI
Round 2 - Face to Face 

(2 Questions)

Round duration - 40 minutes
Round difficulty - Hard

Late night around at 8 pm 
Environmental is positive.
Interviewer made me feel positive

  • Q1. 

    Priority Queue Implementation

    Ninja is tasked with implementing a priority queue using the Heap data structure. Since Ninja is busy with tournament preparations, your help is requested to complete this ta...

  • Ans. 

    Implement a priority queue using Heap data structure with functions like push, pop, getMaxElement, and isEmpty.

    • Implement push() function to insert element into the priority queue.

    • Implement pop() function to delete the largest element from the queue.

    • Implement getMaxElement() function to return the largest element.

    • Implement isEmpty() function to check if the queue is empty.

  • Answered by AI
  • Q2. You have 3 bulbs outside a room and 3 switches inside the room. The challenge is to determine which switch controls which bulb, with the constraint that you can only enter the bulb room once.
Round 3 - HR 

Round duration - 10 Minutes
Round difficulty - Easy

Morning time
Positive environment
Nice interviewer

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Associate Software Engineer in GurgaonEligibility criteria6 cgpa ,no gapAmdocs interview preparation:Topics to prepare for the interview - Python, Data structure, DBMS, algorithm, IotTime required to prepare for the interview - 6 MonthsInterview preparation tips for other job seekers

Tip 1 : practice on subject in which you are strong enough and unbeatable
Tip 2 : Always go through previous interview experiences on internet
Tip 3 : follow continuety

Application resume tips for other job seekers

Tip 1 : mention only you strong topics ,don't include anything you don't know about 
Tip 2 : always make your resume one pager

Final outcome of the interviewSelected

Skills evaluated in this interview

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 120minutes
Round difficulty - Easy

It was an online MCQ's + coding round consisting of 20 MCQ’s and 1 coding problem.

  • Q1. Check whether there exists a loop in the linked list.
  • Ans. 

    Check for a loop in a linked list by using two pointers moving at different speeds.

    • Use two pointers, one moving at double the speed of the other.

    • If there is a loop, the two pointers will eventually meet at the same node.

    • Example: 1 -> 2 -> 3 -> 4 -> 5 -> 2 (loop back to 2), the two pointers will meet at node 2.

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 50 minutes
Round difficulty - Easy

The interview started at 8:30 pm in cc of Delhi Technological University itself and it was quite late. There was only a single interviewer and he asked me one coding question related to overflow of integers.

  • Q1. How can you check for integer overflow when multiplying two integers and ensure the result is stored correctly within an integer type?
  • Ans. 

    To check for integer overflow when multiplying two integers, use the properties of integer overflow and check if the result is within the valid range of the integer type.

    • Check if the signs of the two integers are the same to avoid overflow in case of multiplication.

    • Use the properties of integer overflow to detect if the result exceeds the maximum or minimum value of the integer type.

    • Consider using a larger data type or...

  • Answered by AI
Round 3 - HR 

Round duration - 15 minutes
Round difficulty - Easy

It was quite late . There was only one interviewer and I was asked about my family , education and future plannings and few questions related joining locations and documents etc.

Interview Preparation Tips

Professional and academic backgroundI completed Information Technology from Delhi Technological University. I applied for the job as SDE - 1 in PuneEligibility criteria6Amdocs interview preparation:Topics to prepare for the interview - I did a lot of practice of data structures and algorithms. I covered main topics such as arrays, strings, trees, linked lists, hashmaps, and recursion. Algorithms such as sorting, searching, BFS, DFS, and greedy were also covered by me.Time required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Focus on data structures and algorithms part more. Tell the interviewer , starting from the brute force approach to the most optimal solution as this will give a good impression to the interviewer.

Application resume tips for other job seekers

To be honest, the problem-solving ability is the only thing that most companies care about. So you can manipulate your resume according to that. Mention your competitive programming handles in your resume and also other coding ranks or achievements which you have achieved.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Company Website and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How does you skills relate to this job
  • Q2. Why should we hire you

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare and stay confident

Plex Systems Interview FAQs

How to prepare for Plex Systems 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 Plex Systems. The most common topics and skills that interviewers at Plex Systems expect are .Net, Docker, Kubernetes, Javascript and Node.Js.
What are the top questions asked in Plex Systems interview?

Some of the top questions asked at the Plex Systems interview -

  1. What are inde...read more
  2. What is OLTP, O...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Oracle Interview Questions
3.7
 • 857 Interviews
Google Interview Questions
4.4
 • 832 Interviews
Amdocs Interview Questions
3.7
 • 515 Interviews
Adobe Interview Questions
3.9
 • 234 Interviews
Salesforce Interview Questions
4.0
 • 226 Interviews
24/7 Customer Interview Questions
3.5
 • 176 Interviews
Chetu Interview Questions
3.3
 • 174 Interviews
Dassault Systemes Interview Questions
4.0
 • 162 Interviews
View all

Plex Systems Reviews and Ratings

based on 10 reviews

3.8/5

Rating in categories

3.7

Skill development

4.0

Work-life balance

4.2

Salary

4.2

Job security

3.7

Company culture

3.7

Promotions

3.5

Work satisfaction

Explore 10 Reviews and Ratings
Senior Software Engineer
13 salaries
unlock blur

₹19.6 L/yr - ₹28 L/yr

Senior Automation Test Engineer
6 salaries
unlock blur

₹20 L/yr - ₹24 L/yr

Softwaretest Engineer
6 salaries
unlock blur

₹8.4 L/yr - ₹13.6 L/yr

Software Engineer
5 salaries
unlock blur

₹8.3 L/yr - ₹13.6 L/yr

Software Engineer II
5 salaries
unlock blur

₹13.5 L/yr - ₹25 L/yr

Explore more salaries
Compare Plex Systems with

Oracle

3.7
Compare

Amdocs

3.7
Compare

Automatic Data Processing (ADP)

4.0
Compare

24/7 Customer

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