PV Technosoft Interview Questions and Answers

Sort strings based on custom hierarchy

• Create a mapping of each character to its hierarchy value

• Sort the strings based on the hierarchy value of their first character

• If the first characters have the same hierarchy value, move to the next character

• Repeat until all strings are sorted

Heap is a region of memory used for dynamic memory allocation.

• Heap is managed by the operating system or runtime environment.

• It allows for allocation and deallocation of memory at runtime.

• Heap can become fragmented over time, leading to performance issues.

• Examples include malloc() and new() in C++.

Hashing is a process of converting data into a fixed-size output using a mathematical function.

• Hashing is used for data integrity and security purposes.

• Hash functions are one-way functions, meaning it is difficult to reverse engineer the original data from the hash value.

• Hashing is used in password storage, digital signatures, and data comparison.

• Examples of hash functions include MD5, SHA-1, and SHA-256.

Different types of joins and a SQL query.

• Types of joins: Inner join, Left join, Right join, Full outer join, Cross join

• Inner join returns only the matching rows from both tables

• Left join returns all rows from the left table and matching rows from the right table

• Right join returns all rows from the right table and matching rows from the left table

• Full outer join returns all rows from both tables

• Cross join returns the Ca...read more

Compiler translates entire code into machine code while interpreter translates line by line.

• Compiler converts source code into executable code without executing it.

• Interpreter converts source code into machine code line by line and executes it.

• Compiler generates error messages after the entire code is compiled.

• Interpreter generates error messages as soon as it encounters an error in the code.

• Examples of compilers are G...read more