i
Capital Numbers Infotech
Filter interviews by
Clear (1)
I applied via Walk-in
Procedure is a set of SQL statements that performs a specific task, while function returns a value.
Procedure does not return a value, while function does.
Functions can be called from within SQL statements, while procedures cannot.
Functions can be used in SELECT, WHERE, and HAVING clauses, while procedures cannot.
Example: CREATE PROCEDURE sp_GetEmployeeDetails AS ... vs CREATE FUNCTION fn_GetEmployeeName() RETURNS VARCH
Join is used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left table.
FULL JO...
YOU HAVE KNOW BASIC OF PROGRAMING LIKE HOW TO PRINT PALINDRAM, PRINT YOU NAME IN TRAIGALE.
Top trending discussions
posted on 20 Jan 2025
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 Referral and was interviewed in Jun 2024. There was 1 interview round.
Controller is a general term for a component that handles user requests, while a REST controller specifically handles RESTful requests.
Controller is a general term for a component that handles user requests in a web application
REST controller specifically handles RESTful requests, following the principles of REST architecture
REST controller typically returns data in JSON or XML format, while a regular controller may re
Print highest salary of an employee using coding
Create an array of employee salaries
Sort the array in descending order
Print the first element of the sorted array as the highest salary
JWT token is a JSON web token used for securely transmitting information between parties as a compact and self-contained way.
JWT stands for JSON Web Token
It consists of three parts: header, payload, and signature
It is commonly used for authentication and information exchange in web development
Microservices interact with each other through APIs, messaging queues, or event-driven architecture.
Use RESTful APIs for synchronous communication between microservices
Implement messaging queues like RabbitMQ or Kafka for asynchronous communication
Leverage event-driven architecture with tools like Apache Kafka or AWS SNS/SQS
Consider using service mesh like Istio for managing communication between microservices
I applied via Job Portal and was interviewed in Feb 2024. There was 1 interview round.
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...
I am a passionate software developer with experience in Java, Python, and web development.
Experienced in Java, Python, and web development technologies
Strong problem-solving skills and ability to work in a team
Completed multiple projects including a web-based inventory management system
I was interviewed before Sep 2020.
Round duration - 140 minutes
Round difficulty - Medium
Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.
Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...
Given two numbers represented as arrays, calculate their sum and return the result as an array.
Iterate through the arrays from right to left, adding digits and carrying over if necessary
Handle cases where one array is longer than the other by considering the remaining digits
Ensure the final sum array does not have any leading zeros
Round duration - 20 minutes
Round difficulty - Easy
The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.
Round duration - 8 minutes
Round difficulty - Easy
This round was conducted right after finishing and clearing the technical round at the same place and on the same day.
Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.
Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Software Engineer
203
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
126
salaries
| ₹0 L/yr - ₹0 L/yr |
Front end Developer
48
salaries
| ₹0 L/yr - ₹0 L/yr |
Web Developer
29
salaries
| ₹0 L/yr - ₹0 L/yr |
Project Manager
29
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech