i
SunTec Business Solutions
Filter interviews by
Good communication and aptitude
Sort array in descending order
SQL join queries are used to combine rows from two or more tables based on a related column between them.
Use INNER JOIN to return rows when there is at least one match in both tables
Use LEFT JOIN to return all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table
Use FULL JOIN to return rows when there is a match
I was interviewed before Oct 2023.
Futuremug is conducting aptitude its easy
Hacker rank is coding test it is easy
SunTec Business Solutions interview questions for popular designations
I applied via Naukri.com and was interviewed in Feb 2022. There were 4 interview rounds.
Code to pull-up mass data from one table and load into another table efficiently
Use INSERT INTO SELECT statement to pull data from source table and load into target table
Use WHERE clause to filter data if required
Use INDEXES on columns used in WHERE clause to improve performance
Use BULK COLLECT to fetch data in batches to improve performance
Use PARALLEL hint to execute the query in parallel if the table is large
Use NOL...
Yes, I have exposure with coding.
I have experience with programming languages such as Java, Python, and C++.
I have completed various coding projects during my academic studies.
I have also participated in coding competitions and hackathons.
I am familiar with software development methodologies such as Agile and Scrum.
I applied via Walk-in
Top trending discussions
posted on 11 Jun 2024
Strings are immutable to ensure data integrity and security by preventing accidental or intentional modification.
Immutable strings prevent accidental changes to data
Enhances security by preventing data tampering
Allows for efficient memory management
Count the number of repeated words in a given string
Split the string into words using a delimiter like space
Create a hashmap to store word frequencies
Iterate through the words and update the hashmap accordingly
Count the number of words with frequency greater than 1
I applied via Walk-in and was interviewed in Dec 2021. There were 3 interview rounds.
Basic Programming questions will be there
Java is most secured due to its strong memory management, bytecode verification, and security manager.
Java's strong memory management prevents buffer overflow and other memory-related vulnerabilities.
Bytecode verification ensures that the code is safe to execute and prevents malicious code from running.
Security manager allows fine-grained control over access to system resources.
Java also has a robust set of security AP...
Java programs are executed by the Java Virtual Machine (JVM) which interprets and executes the bytecode generated by the Java compiler.
Java source code is compiled into bytecode by the Java compiler
The bytecode is platform-independent and can be executed on any device with a JVM
The JVM interprets the bytecode and executes the instructions
The JVM manages memory, handles exceptions, and provides other runtime services
Exa
Abstract class is a class that cannot be instantiated and may contain abstract methods.
Cannot be instantiated directly
May contain abstract methods that must be implemented by subclasses
Can have both abstract and non-abstract methods
Used for creating a template for other classes to inherit from
A subquery is a query nested within another query, and the LIKE operator is used in SQL to search for a specified pattern in a column.
A subquery is enclosed in parentheses and executed first before the main query.
The result of a subquery can be used in comparison with the main query's result.
The LIKE operator is used with the WHERE clause to search for a specified pattern in a column.
The LIKE operator allows for wildca...
based on 6 interviews
Interview experience
based on 132 reviews
Rating in categories
Software Engineer
170
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
115
salaries
| ₹0 L/yr - ₹0 L/yr |
Architect
22
salaries
| ₹0 L/yr - ₹0 L/yr |
Softwaretest Engineer
19
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
19
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech