TCS DBA Consultant Interview Questions and Answers for Freshers

A program to replace a character with another character in Java.

• Create a string variable with the original text

• Use the replace() method to replace the character with another character

• Print the new string with the replaced character

Swap two numbers with and without temporary variable

• Without temporary variable: Use addition and subtraction

• With temporary variable: Use a third variable to store the value of one of the numbers

• Example without temporary variable: a=5, b=7; a=a+b; b=a-b; a=a-b;

• Example with temporary variable: a=5, b=7; temp=a; a=b; b=temp;

Second level cache is a caching mechanism used to improve performance by storing frequently accessed data in memory.

• Second level cache is implemented at the application level and can be configured using frameworks like Hibernate.

• To optimize SQL queries, one can use indexes, avoid using SELECT *, and use JOINs instead of subqueries.

• SOLID principles are a set of design principles for writing maintainable and scalable cod...read more

To deploy an application in AWS, you need to create an EC2 instance, configure security groups, install necessary software, and upload your application code.

• Create an EC2 instance in the desired region and select the appropriate instance type

• Configure security groups to allow traffic to and from the instance

• Install necessary software and dependencies on the instance

• Upload your application code to the instance

• Start the ...read more

Multithreading is the ability of a CPU to execute multiple threads concurrently, improving performance and responsiveness.

• Multithreading allows for parallel execution of tasks, utilizing multiple CPU cores.

• It enables concurrent processing, where multiple threads can execute simultaneously.

• Thread synchronization mechanisms like locks and semaphores are used to prevent data inconsistencies.

• Multithreading can be used to i...read more

Constructors are used to initialize objects while destructors are used to destroy objects.

• Constructors are called when an object is created while destructors are called when an object is destroyed.

• Constructors have the same name as the class while destructors have the same name as the class preceded by a tilde (~).

• Constructors can be overloaded while destructors cannot be overloaded.

• Constructors do not have a return ty...read more