Tietoevry Software Engineer Interview Questions and Answers

Use a SQL query to filter records where age is greater than 2.

• Basic SQL syntax: SELECT column_name FROM table_name WHERE condition;

• Example query: SELECT * FROM users WHERE age > 2;

• This query retrieves all records from the 'users' table where the age column has values greater than 2.

• Ensure the 'age' column is of a numeric type to avoid errors.

Deep copy creates a new object with copies of nested objects; shallow copy copies references to nested objects.

• Shallow Copy: Copies the object's reference, not the actual object. Example: `list2 = list1.copy()`.

• Deep Copy: Creates a new object and recursively copies all objects found in the original. Example: `import copy; list2 = copy.deepcopy(list1)`.

• Shallow Copy is faster but can lead to unintended side effects ...read more

This code reverses the characters of a string while keeping the order of words intact in C++.

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

• Reverse the entire string to get the characters in reverse order.

• Reverse each individual word to restore their original order.

• Example: Input: 'Hello World' -> Output: 'dlroW olleH'

To make a string palindrome, reverse the string and append it to the original string.

• Reverse the input string

• Append the reversed string to the original string

The Java Virtual Machine (JVM) calls the main method in Java.

• The main method is the entry point of a Java program.

• It is declared as public static void main(String[] args)

• The JVM searches for the main method in the class specified in the command line arguments.

• If the main method is not found, the JVM throws a NoSuchMethodError.

Classes are blueprints for objects; they encapsulate data and behavior in programming.

• A 'Car' class can have attributes like 'color', 'model', and methods like 'drive()' and 'stop()'.

• An 'Employee' class might include properties like 'name', 'id', and methods like 'work()' and 'takeLeave()'.

• In a game, a 'Player' class could have attributes like 'score' and 'level', with methods like 'jump()' and 'attack()'.

Joining two tables in SQL allows you to combine related data for more comprehensive queries.

• Use INNER JOIN to return records with matching values in both tables.

• Example: SELECT * FROM TableA INNER JOIN TableB ON TableA.id = TableB.a_id;

• Use LEFT JOIN to return all records from the left table and matched records from the right table.

• Example: SELECT * FROM TableA LEFT JOIN TableB ON TableA.id = TableB.a_id;

• Use RIGHT ...read more

MongoDB queries are used to retrieve data from a MongoDB database.

• Use find() method to retrieve documents from a collection

• Use findOne() method to retrieve a single document

• Use sort() method to sort the results

• Use limit() method to limit the number of results returned