200+ Project Engineer Interview Questions and Answers for Freshers

Answering technical interview questions on SQL and programming

• Constraints are rules applied to columns in a database table to ensure data integrity

• COMMIT command is used to save changes made to a database

• JOIN operation is used to combine rows from two or more tables based on a related column

• Code for reversing an array: reverseArray(arr) {return arr.reverse();}

Recursion is a technique of solving a problem by breaking it down into smaller subproblems. Dynamic programming is a method of solving a problem by breaking it down into smaller subproblems and storing the solutions to those subproblems to avoid redundant calculations.

• Recursion involves solving a problem by breaking it down into smaller subproblems and calling the function recursively until the base case is reached.

• Dynamic programming involves solving a problem by breaking it...read more

Program to check if two given matrices are identical

• Check if the dimensions of both matrices are same

• Iterate through each element of both matrices and compare them

• If all elements are same, matrices are identical

Understanding data structures and algorithms commonly used in MySQL databases.

• Array: a data structure that stores a collection of elements in a contiguous memory location.

• ArrayList: a resizable array implementation that dynamically adjusts its size as elements are added or removed.

• LinkedList: a data structure where each element is connected to the next element via pointers.

• Binary Tree: a tree data structure where each node has at most two children.

• Complete Binary Tree: a bina...read more

I am comfortable with multiple programming languages including Java, Python, and C++.

• Proficient in Java, Python, and C++

• Experience with web development languages such as HTML, CSS, and JavaScript

• Familiarity with database languages such as SQL

• Comfortable with object-oriented programming and software development principles

No, not all inheritance is applicable in Python.

• Python supports single inheritance, where a class can inherit from only one parent class.

• Multiple inheritance is also possible, but it can lead to the diamond problem.

• Python also supports multilevel inheritance, where a class can inherit from a parent class, which in turn can inherit from another parent class.

• Inheritance can be used to reuse code and create a hierarchy of classes.

• Example: class B inherits from class A - class B(...read more

As a team leader, I would address the issue by identifying the root cause, providing feedback and support, and exploring potential solutions.

• Communicate with the team member to understand the reasons behind their poor performance

• Provide constructive feedback and guidance to help them improve

• Offer additional training or resources if necessary

• Reassign tasks or adjust workload to better suit their strengths

• Encourage open communication and create a supportive team environment

• Seek...read more

I prefer Python for its simplicity and versatility.

• Python is easy to learn and has a large community for support.

• It can be used for a variety of tasks such as web development, data analysis, and automation.

• Python also has many libraries and frameworks available for use.

• Other languages I am familiar with include Java and C++.

Reverse each word of a given string.

• Split the string into words using space as a delimiter.

• Reverse each word using built-in functions or loops.

• Join the reversed words to form the final string.

Bubble sort has a time complexity of O(n^2). It can be optimized by adding a flag to check if any swaps were made.

• Bubble sort compares adjacent elements and swaps them if they are in the wrong order.

• It repeats this process until the array is sorted.

• Adding a flag to check if any swaps were made can reduce the time complexity to O(n) in the best case.

• However, in the worst case, it still has a time complexity of O(n^2).

Access specifiers are keywords in object-oriented programming languages that determine the visibility of class members.

• Access specifiers are used to restrict access to class members.

• There are three access specifiers: public, private, and protected.

• Public members can be accessed from anywhere in the program.

• Private members can only be accessed within the class.

• Protected members can be accessed within the class and its subclasses.

• Example: class MyClass { public: int x; private:...read more

Questions on arrays, C/C++, OOP, and past projects for Project Engineer role.

• An array is a collection of similar data types stored in contiguous memory locations.

• C is a procedural language while C++ is an object-oriented language.

• Object-oriented programming is a programming paradigm that uses objects to represent and manipulate data.

• Examples of past projects worked on should be provided.

Yes, I have knowledge of PLC ladder designing and RLC circuit designing.

• I have experience in designing and programming PLC ladder logic for industrial automation systems.

• I am familiar with RLC circuit analysis and design, including calculating impedance and resonance frequencies.

• I have worked with various PLC brands such as Allen Bradley, Siemens, and Mitsubishi.

• I have also designed and simulated RLC circuits using software tools like LTSpice and Multisim.

Code to count number of characters and alphabets in a string.

• Use the len() function to count the total number of characters in the string.

• Use isalpha() function to check if a character is an alphabet or not.

• Loop through each character in the string and increment the count of alphabets if it is an alphabet.

• Return the total count of characters and alphabets in the string.

Program to generate Fibonacci series up to nth term.

• Declare variables for first and second terms of the series

• Use a loop to generate the series up to nth term

• Print the series as output

OOPs concepts are used in various real-life scenarios such as software development, game development, and automation.

• In software development, OOPs concepts are used to create reusable code and improve code organization.

• In game development, OOPs concepts are used to create game objects with properties and behaviors.

• In automation, OOPs concepts are used to create modular and scalable code for testing and scripting.

I have extensive experience working with Javascript, HTML, CSS, and NodeJs in various projects.

• Developed interactive web applications using Javascript, HTML, and CSS

• Utilized NodeJs for server-side development and building APIs

• Implemented responsive design techniques with CSS frameworks like Bootstrap

• Integrated front-end and back-end technologies to create seamless user experiences

Return index of elements whose sum is equal to given sum in an array.

• Iterate through the array and check if the sum of any two elements is equal to the given sum.

• If yes, return the indices of those two elements.

• If no such pair exists, return an empty array.

Autonomous colleges are independent and have more academic freedom.

• Autonomous colleges have the freedom to design their own courses and syllabus.

• They can also conduct their own exams and evaluate students.

• This allows for more flexibility and innovation in teaching methods.

• Autonomous colleges are also able to respond more quickly to changes in the industry and job market.

• Examples of autonomous colleges include Indian Institute of Technology (IIT) and Indian Institute of Manage...read more

Different types of fittings in piping include elbows, tees, reducers, couplings, and flanges.

• Elbows: Used to change the direction of piping

• Tees: Used to create a branch in piping

• Reducers: Used to connect pipes of different sizes

• Couplings: Used to connect two pipes together

• Flanges: Used to connect pipes, valves, and other equipment

Durability in acid properties refers to the ability of a material to withstand the corrosive effects of acid.

• Durability is important in industries that use acids, such as chemical manufacturing and mining.

• Materials with high durability in acid properties include stainless steel and certain types of plastics.

• Durability can be measured through tests such as the ASTM G31 standard.

• Factors that affect durability include concentration and temperature of the acid, as well as the mat...read more

C++ is an extension of C with object-oriented programming features.

• C++ supports classes and objects while C does not.

• C++ has better support for polymorphism and inheritance.

• C++ has a standard template library (STL) which provides useful data structures and algorithms.

• C++ is more complex than C and requires more knowledge to use effectively.

Wipro is an Indian multinational corporation that provides information technology, consulting and business process services.

• Founded in 1945 by M.H. Hasham Premji

• Headquartered in Bangalore, India

• Employs over 190,000 people worldwide

• Provides services in various industries including healthcare, finance, and retail

• Has partnerships with major technology companies such as Microsoft and SAP

Polymorphism is the ability of an object to take on many forms.

• It allows objects of different classes to be treated as if they were objects of the same class.

• It is achieved through method overriding and method overloading.

• Example: A shape class can have different subclasses like circle, square, and triangle, each with their own implementation of the draw method.

• Example: A method can take in different types of objects as parameters, as long as they all inherit from the same pa...read more

Static memory allocation is done at compile-time, while dynamic memory allocation is done at runtime.

• Static memory allocation is used for variables that are fixed in size and do not change during program execution.

• Dynamic memory allocation is used for variables that can change in size during program execution.

• Static memory allocation is faster than dynamic memory allocation.

• Dynamic memory allocation is useful when the size of the data is not known at compile-time.

• Examples of ...read more

Yes, I have experience working in a plant.

• Working in a plant involves managing and overseeing various engineering projects.

• It requires knowledge of plant operations, equipment, and processes.

• Plant engineers are responsible for ensuring the efficiency and safety of plant operations.

• They collaborate with different teams, such as maintenance, production, and quality control.

• Examples of plant engineering projects include designing and implementing new production lines, optimizing...read more

Yes, I have received training in a Telecom training institute.

• I have completed a course in telecommunications at XYZ institute.

• During my previous job, I attended a training program on telecom infrastructure.

• I have also completed an online course on telecom network design.

• I am familiar with various telecom technologies such as 4G, 5G, and VoIP.

Return the difference between maximum and minimum number's count in an array of strings.

• Convert the array of strings to an array of integers

• Use Math.max() and Math.min() to find the maximum and minimum numbers in the array

• Count the occurrences of the maximum and minimum numbers using a loop

• Return the difference between the counts

Code to print the difference of a number and its reverse

• Convert the number to string

• Reverse the string

• Convert the reversed string back to number

• Subtract the original number from the reversed number

• Print the result

I am familiar with several databases other than MySQL.

• I have experience with PostgreSQL, Oracle, MongoDB, and Microsoft SQL Server.

• I am also familiar with NoSQL databases such as Cassandra and Couchbase.

• I have worked with various cloud-based databases like Amazon RDS and Google Cloud SQL.

Social media is a necessary evil as it has both positive and negative impacts on society.

• Social media has revolutionized communication and made it easier to connect with people.

• It has also provided a platform for businesses to reach a wider audience and for individuals to showcase their talents.

• However, social media has also been linked to mental health issues such as anxiety and depression.

• It has also been criticized for spreading fake news and misinformation.

• Overall, social...read more

No, Java doesn't support multiple inheritance.

• Java only supports single inheritance through classes and interfaces.

• However, interfaces can be implemented multiple times.

• To achieve multiple inheritance-like behavior, composition can be used.

The erection sequence of a continuous casting plant involves several steps. There are two types of casters: vertical and horizontal.

• The first step is to install the foundation and anchor bolts.

• Next, the columns and beams are erected.

• After that, the equipment such as tundish, mold, and rollers are installed.

• Finally, the electrical and hydraulic systems are connected.

• There are two types of casters: vertical and horizontal. Vertical casters are used for producing slabs, while ho...read more

My programming language of interest is Python.

• Python is a versatile language used in web development, data analysis, machine learning, and more.

• It has a simple syntax and is easy to learn for beginners.

• Python has a large community and a vast library of modules and frameworks.

• Examples of Python-based frameworks include Django, Flask, and PyTorch.

A foreign key is a column or set of columns in a database table that refers to the primary key of another table.

• A foreign key ensures referential integrity between two tables.

• It is used to establish a relationship between two tables.

• It helps in maintaining data consistency and accuracy.

• For example, a customer table may have a foreign key that refers to the primary key of an orders table.

The amount of accelerator used in shotcrete depends on various factors.

• The type of accelerator used affects the amount required.

• The desired strength and setting time also play a role.

• The ambient temperature and humidity can affect the amount needed.

• Typically, 1-5% of the cement weight is used as accelerator.

• The manufacturer's recommendations should be followed for best results.

List is an interface in java collection.

• List is a part of the Java Collection Framework.

• It is an ordered collection of elements.

• It allows duplicate elements and null values.

• Some common implementations of List are ArrayList, LinkedList, and Vector.

Yes, social media can be used for educational purposes.

• Social media provides a platform for sharing educational content and resources.

• It allows for collaboration and communication among students and teachers.

• Social media can enhance learning through interactive discussions and real-time feedback.

• It can also help in reaching a wider audience and promoting educational initiatives.

• Examples include educational YouTube channels, online courses on platforms like Coursera, and educa...read more

Civil engineering is a branch of engineering that deals with the design, construction, and maintenance of infrastructure.

• Civil engineering involves the planning, design, and construction of buildings, bridges, roads, dams, and other structures.

• It includes various sub-disciplines such as structural engineering, geotechnical engineering, transportation engineering, and environmental engineering.

• Civil engineers use principles of physics, mathematics, and materials science to ens...read more

Data abstraction is the process of hiding complex implementation details and providing a simplified interface.

• Abstraction allows users to interact with complex systems without needing to understand the underlying complexity.

• An example of data abstraction is using a smartphone. Users can make calls, send messages, and use apps without knowing the intricate details of how the device works.

• Another example is a car dashboard. It provides essential information like speed, fuel lev...read more

Shallow copy and deep copy are two ways of copying objects in programming.

• Shallow copy creates a new object but references the same memory location as the original object.

• Deep copy creates a new object and allocates new memory for it, copying the values of the original object.

• Shallow copy is faster and uses less memory, but changes to the original object affect the copied object.

• Deep copy is slower and uses more memory, but changes to the original object do not affect the cop...read more

Measure function involves obtaining a value using a tool or instrument, while Calculate function involves using mathematical operations to determine a value.

• Measure function involves using tools or instruments to obtain a value (e.g. measuring tape, ruler)

• Calculate function involves using mathematical operations to determine a value (e.g. addition, subtraction, multiplication)

• Measure function is more focused on obtaining precise data, while Calculate function is focused on de...read more