Filter interviews by
I applied via Referral and was interviewed in Jul 2023. There were 4 interview rounds.
The string constant pool is a special memory area in Java where string literals are stored.
String constant pool is a part of the heap memory.
It is used to optimize memory usage by reusing string literals.
String objects created using the same literal share the same memory location.
String constant pool can be accessed using the intern() method.
Example: String str1 = "Hello"; String str2 = "Hello"; str1 and str2 point to
I would rate myself at java as an 8 out of 10.
I have extensive experience in Java programming.
I have successfully completed multiple Java projects.
I am familiar with various Java frameworks and libraries.
I continuously update my knowledge and skills in Java.
I am confident in my ability to solve complex problems using Java.
s1 stores the string 'hello' in the stack memory, while s2 stores a new string object with the same value in the heap memory.
s1 is a reference variable that stores the memory address of the string 'hello' in the stack memory.
s2 is a reference variable that stores the memory address of a new string object created in the heap memory.
The string 'hello' is stored in the heap memory because it was created using the 'new' ke
I have used Java version 8 and SpringBoot version 2.4.2.
I have experience working with Java 8 and SpringBoot 2.4.2.
I am familiar with the features and functionalities of Java 8 and SpringBoot 2.4.2.
I have developed applications using Java 8 and SpringBoot 2.4.2.
I have utilized the latest enhancements and improvements provided by Java 8 and SpringBoot 2.4.2.
Java program to filter out prime numbers and print composite numbers from 1 to 100.
Iterate through numbers 1 to 100
Check if each number is prime or composite
Print the composite numbers
A bean in Spring is a Java object that is instantiated, assembled, and managed by the Spring IoC container.
Beans are the basic building blocks of a Spring application.
They are defined in the Spring configuration file or using annotations.
Beans are managed by the Spring IoC container, which handles their lifecycle and dependencies.
Beans can be singleton, prototype, or scoped.
Dependency injection is used to wire beans to...
RestController is a class in Spring Boot that combines @Controller and @ResponseBody annotations to simplify RESTful web service development.
RestController is used to create RESTful web services in Spring Boot.
It is a specialized version of the @Controller annotation.
It combines the @Controller and @ResponseBody annotations.
The @ResponseBody annotation is used to bind the method return value to the web response body.
It...
The @Component and @Service annotations in Spring Boot are used to define beans, but @Service is a specialization of @Component.
Both @Component and @Service annotations are used to define beans in Spring Boot.
@Service is a specialization of @Component and is used to indicate that a class is a service component.
The @Service annotation is typically used for classes that perform business logic or provide services.
The @Com...
A Java function to determine if a given number is divisible by 3, 5, or 15.
Use the modulo operator (%) to check if the number is divisible by 3, 5, or 15.
If the number is divisible by 3, print 3.
If the number is divisible by 5, print 5.
If the number is divisible by 15, print 15.
If none of the above conditions are met, do not print anything.
The flow of a Spring Boot API involves handling HTTP requests, routing them to appropriate controllers, processing the requests, and returning responses.
Spring Boot API receives HTTP requests from clients
The requests are routed to appropriate controllers based on the defined endpoints
Controllers process the requests by invoking appropriate services or repositories
Services handle the business logic and interact with rep...
Java 8 program to flatten a nested list into a single list.
Use flatMap() method to flatten the nested list.
Convert the nested list to a stream and use flatMap() to flatten it.
Collect the flattened stream into a list using the Collectors.toList() method.
Sorts a list of strings based on the second character in each string.
Use the `Comparator.comparing` method to specify the key for sorting.
Access the second character of a string using the `charAt` method.
Use the `Collections.sort` method to sort the list.
Java 8 Stream to get average, minimum, maximum from List of BigDecimal or Integer.
Use the stream() method on the List to create a Stream
Use the mapToDouble() method to convert the elements to double values
Use the average(), min(), and max() methods to get the desired values
Use the getAsDouble() method to retrieve the result as a double value
A Consumer function for String in Java 8.
Use the Consumer functional interface from the java.util.function package.
Implement the accept() method to perform the desired operation on the input string.
Example: Consumer
We use Java 11 and Spring Boot 2.4.2 in our project.
Java 11 is the latest LTS version of Java, providing improved performance and security.
Spring Boot 2.4.2 is a stable release with bug fixes and new features.
Using the latest versions ensures compatibility with the latest libraries and frameworks.
Java 11 example: java -version
Spring Boot 2.4.2 example: spring --version
To retrieve only names from a table, you can use a SELECT query with the appropriate column name.
Use the SELECT statement to specify the column(s) you want to retrieve.
Specify the name column in the SELECT clause to retrieve only names.
Use the FROM clause to specify the table from which you want to retrieve the names.
Server-side validation without third-party library using core Java
Use regular expressions for pattern matching
Implement custom validation logic using core Java classes
Leverage Java's built-in exception handling for error handling
To ensure that the bug fix does not break existing functionality, thorough testing and quality assurance processes should be followed.
Perform unit testing to verify that the bug fix works as expected and does not introduce new issues.
Conduct integration testing to ensure that the bug fix does not cause any conflicts or compatibility issues with other components.
Execute regression testing to validate that the bug fix do...
The functional interface mostly used in Java 8 is the java.util.function package.
The most commonly used functional interfaces in Java 8 are Predicate, Consumer, Function, and Supplier.
Predicate is used for boolean-valued functions of one argument.
Consumer is used for operations that take in one argument and return no result.
Function is used for functions that accept one argument and produce a result.
Supplier is used fo...
Rate your
company
🤫 100% anonymous
How was your last interview experience?
I applied via Recruitment Consulltant and was interviewed before Nov 2023. There was 1 interview round.
Dsa questions along with Java will be asked
I applied via campus placement at Maulana Azad National Institute of Technology (NIT), Bhopal and was interviewed in Aug 2022. There were 4 interview rounds.
Basic questions like print permutations of a string. 4-5 Puzzles
Reverse all words in a given paragraph.
Top trending discussions
I was interviewed in Jan 2025.
I was interviewed in Feb 2025.
I was interviewed in Jan 2025.
The exam consists of seven sections, and the cutoff score is quite high; it is essential to complete the exam thoroughly.
I was interviewed in Feb 2025.
I was interviewed in Jan 2025.
Case and decode are conditional expressions in PL/SQL used for data manipulation.
CASE is used for conditional logic in SQL statements, while DECODE is used for conditional logic in SELECT statements.
CASE is more flexible and can handle multiple conditions, while DECODE is limited to one condition.
CASE can be used in both SQL and PL/SQL, while DECODE is specific to SQL.
Example of CASE: SELECT CASE WHEN condition1 THEN r...
Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.
Primary key ensures uniqueness and cannot have null values
Foreign key establishes a relationship between tables based on the primary key of another table
Example of primary key: EmployeeID in an Employee table
Example of foreign key: DepartmentID in an Employee table linking to DepartmentID in a Department tabl
Rank assigns unique ranks to each distinct row, while Dense Rank assigns consecutive ranks without gaps.
Rank may have gaps in the ranking sequence, while Dense Rank does not.
Rank assigns the same rank to rows with the same values, while Dense Rank assigns different ranks.
Rank function is non-consecutive, while Dense Rank function is consecutive.
Procedures are used to perform an action, while functions return a value.
Procedures do not return a value, while functions do.
Functions can be called from SQL queries, while procedures cannot.
Functions must return a value, while procedures do not necessarily have to.
No, a package body cannot be used without a package specification.
A package body must always be associated with a package specification.
The package specification defines the public interface of the package, while the package body contains the implementation details.
Attempting to use a package body without a corresponding package specification will result in compilation errors.
Use a SQL query with GROUP BY and HAVING clause to find duplicate values in a database.
Use GROUP BY clause to group the values that are duplicated.
Use HAVING clause to filter out the groups that have more than one occurrence.
Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Group by and having clause are used together to filter groups based on specified conditions.
Group by clause is used to group rows that have the same values into summary rows.
Having clause is used to filter groups based on specified conditions.
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000;
Substr function extracts a substring from a string, while Instr function returns the position of a substring within a string.
Substr function syntax: SUBSTR(string, start_position, length)
Example: SUBSTR('Hello World', 7, 5) will return 'World'
Instr function syntax: INSTR(string, substring)
Example: INSTR('Hello World', 'World') will return 7
Writing a SQL query with a subquery involves nesting one query inside another to retrieve specific data.
Start by writing the main query that will retrieve the primary data
Identify the criteria for the subquery to filter the results
Enclose the subquery within parentheses and use it in the WHERE or FROM clause of the main query
Ensure that the subquery returns a single value or a single column result
Char is fixed length, varchar is variable length with max 4000 bytes, varchar2 is variable length with max 32767 bytes.
Char is fixed length and always right-padded with spaces, while varchar and varchar2 are variable length.
Varchar can store up to 4000 bytes of data, while varchar2 can store up to 32767 bytes.
Char is less efficient in terms of storage compared to varchar and varchar2.
No, it is not possible to combine two tables with differing data and columns without utilizing joins.
Joins are necessary to combine tables based on a common column or key.
Different data and columns require a join to match and merge the data properly.
Examples of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Yes, it is possible to update data in a view using INSTEAD OF triggers.
Views are virtual tables that display data from one or more tables.
By using INSTEAD OF triggers, you can update data in a view by specifying the logic to handle the update operation.
The trigger intercepts the update operation on the view and executes the specified logic to update the underlying tables.
For example, you can create an INSTEAD OF trigge...
TCS is a global IT services company known for its innovative solutions and commitment to employee growth.
TCS has a strong reputation in the IT industry for delivering high-quality services.
TCS offers opportunities for professional growth and development through training programs and career advancement.
TCS has a diverse and inclusive work culture that values teamwork and collaboration.
A dynamic cursor in database management allows for the execution of different SQL queries at runtime.
Dynamic cursors are used when the SQL query to be executed is not known until runtime.
They allow for flexibility in querying the database based on user input or other conditions.
Dynamic cursors can be used to handle varying result sets or conditions in a more efficient manner.
Example: Using a dynamic cursor to search fo...
Yes, I have performed performance tuning by identifying bottlenecks and optimizing queries.
Identified slow queries using tools like SQL Trace, Explain Plan, and AWR reports.
Optimized queries by adding indexes, rewriting SQL statements, and reducing unnecessary data retrieval.
Tuned PL/SQL code by using bulk processing, minimizing context switches, and optimizing loops.
Utilized database features like partitioning and mat
A package in PL/SQL is a collection of related procedures, functions, variables, and other constructs.
A package consists of two parts: package specification and package body.
The package specification defines the public interface of the package, including declarations of variables, constants, cursors, procedures, and functions.
The package body contains the actual implementation of the procedures and functions declared i...
I am excited about the opportunity to work with a global leader like TCS and contribute to innovative projects.
TCS is a renowned global company with a strong reputation in the IT industry
I am impressed by TCS's commitment to innovation and cutting-edge technology
I believe TCS offers great opportunities for professional growth and development
I am excited about the chance to work on diverse and challenging projects at TC
I prefer to discuss my salary expectations based on the responsibilities and requirements of the position.
Focus on discussing salary expectations based on the job responsibilities and requirements.
Avoid disclosing specific current salary package.
Emphasize the importance of fair compensation based on market rates and skills.
Provide examples of successful projects or achievements that demonstrate your value.
Discuss oppor...
I am looking for a competitive salary package based on my experience and skills.
I am open to discussing salary based on the responsibilities and requirements of the role.
I have researched the average salary range for Plsql Developers in this location.
I am looking for a package that includes benefits such as healthcare, retirement plans, and professional development opportunities.
Yes, I am comfortable with shift work and have experience working various shifts.
I have previous experience working different shifts in my current/previous roles.
I am flexible with my schedule and can easily adapt to changing shift patterns.
I understand the importance of shift work in ensuring 24/7 coverage for critical systems.
Yes, I am open to any location for the Plsql Developer position.
I am willing to relocate for the right opportunity
I am open to working in different cities or countries
I am flexible with travel requirements for the job
I was interviewed in Jan 2025.
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
I was interviewed in Jan 2025.
Some of the top questions asked at the Biz4Solutions interview -
based on 5 interviews
Interview experience
Anonymously discuss salaries, work culture, and many more
Get Ambitionbox App
based on 36 reviews
Rating in categories
Programmer
50
salaries
| ₹3.4 L/yr - ₹11.2 L/yr |
Junior Programmer
21
salaries
| ₹2.8 L/yr - ₹7 L/yr |
Senior Programmer
15
salaries
| ₹7.3 L/yr - ₹12.4 L/yr |
UI/UX Designer
11
salaries
| ₹4.1 L/yr - ₹10 L/yr |
Test Engineer
11
salaries
| ₹3.1 L/yr - ₹6.3 L/yr |
TCS
Infosys
Wipro
HCLTech