Hexaware Technologies Graduate Engineer Trainee (Get) Interview Questions and Answers for Freshers

Compile time polymorphism is resolved at compile time, while run time polymorphism is resolved at run time.

• Compile time polymorphism is achieved through function overloading and operator overloading.

• Run time polymorphism is achieved through function overriding and virtual functions.

• Compile time polymorphism is faster as the resolution is done at compile time.

• Run time polymorphism allows dynamic binding of functions based on the object type at run time.

• Compile time polymorphis...read more

Software Development Lifecycle is a process followed by software development teams to design, develop and maintain software.

• It includes phases like planning, analysis, design, implementation, testing, deployment, and maintenance.

• Each phase has its own set of activities and deliverables.

• It helps in ensuring that the software is developed efficiently and meets the requirements of the stakeholders.

• Examples of SDLC models are Waterfall, Agile, and DevOps.

Questions related to programming concepts and database management systems.

• OOPs stands for Object-Oriented Programming which is a programming paradigm based on the concept of objects.

• Encapsulation is the process of hiding the implementation details of an object from the outside world.

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

• Runtime and compile time are two phases of program execution.

• DBMS stands for Database Management System which is a software system us...read more

DELETE removes specific rows from a table while TRUNCATE removes all rows and resets the table.

• DELETE is a DML command while TRUNCATE is a DDL command.

• DELETE can be rolled back while TRUNCATE cannot be rolled back.

• DELETE is slower than TRUNCATE as it logs each row deletion while TRUNCATE does not.

• DELETE can have WHERE clause while TRUNCATE cannot have WHERE clause.

• DELETE does not reset the identity of the table while TRUNCATE resets the identity of the table.

Call by value passes a copy of the value, while call by reference passes the memory address of the value.

• Call by value creates a new copy of the value being passed.

• Call by reference passes the memory address of the value being passed.

• Changes made to the parameter in call by value do not affect the original value.

• Changes made to the parameter in call by reference affect the original value.

Union combines and removes duplicates from two or more tables, while Union ALL combines all rows from two or more tables.

• Union removes duplicates, Union ALL does not

• Union requires the same number of columns in each table, Union ALL does not

• Union is slower than Union ALL

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2