Filter interviews by
Clear (1)
Angular releted Coding
I applied via Company Website and was interviewed in Oct 2020. There were 3 interview rounds.
A subquery is a query nested inside another query. It is used to retrieve data from multiple tables or perform complex calculations.
A subquery is enclosed within parentheses and is usually placed within the WHERE or HAVING clause of the outer query.
The result of the subquery is used by the outer query to filter or manipulate the data.
Subqueries can be used to retrieve data from multiple tables, perform calculations, or...
Delete and Truncate are SQL commands used to remove data from a table, but they differ in their approach.
DELETE is a DML command that removes specific rows from a table based on a condition.
TRUNCATE is a DDL command that removes all the rows from a table and resets the identity of the table.
DELETE is slower than TRUNCATE as it logs the data changes, whereas TRUNCATE does not.
DELETE can be rolled back, but TRUNCATE cann...
A View is a user interface element that displays information or interacts with the user.
A View is a fundamental building block of Android UI.
It can be a button, text field, image, or any other interactive element.
Views can be arranged in a hierarchy to create complex UI layouts.
Each View has its own set of properties that can be customized, such as size, color, and behavior.
Sample queries for PROCEDURE, FUNCTION, CURSOR
PROCEDURE: CREATE PROCEDURE get_employee_details AS SELECT * FROM employees;
FUNCTION: CREATE FUNCTION get_employee_count RETURN NUMBER IS count NUMBER; BEGIN SELECT COUNT(*) INTO count FROM employees; RETURN count; END;
CURSOR: DECLARE emp_cursor CURSOR FOR SELECT * FROM employees; OPEN emp_cursor; FETCH emp_cursor INTO emp_record; CLOSE emp_cursor;
There are three types of loops: for, while, and do-while.
For loop: executes a block of code a fixed number of times.
While loop: executes a block of code as long as the condition is true.
Do-while loop: executes a block of code at least once, then repeats as long as the condition is true.
Packages, Index, and Sequences are all related to data organization and management in programming.
Packages are collections of related classes and interfaces that are used to organize code.
Index is a data structure that allows for efficient searching and retrieval of data.
Sequences are ordered collections of elements that can be accessed by their position in the sequence.
Examples include the Java Collections Framework, ...
Procedures do not return values while functions return values.
Procedures are used to perform an action while functions are used to calculate and return a value.
Functions can be used in expressions while procedures cannot.
Functions have a return type while procedures do not.
Functions can have input parameters and return values while procedures can only have input parameters.
Examples of functions include Math.max() and S...
Canvas in forms can be of different types like HTML5 Canvas, SVG Canvas, and PDF Canvas.
HTML5 Canvas allows for drawing graphics using JavaScript
SVG Canvas is scalable and can be manipulated with CSS
PDF Canvas is used for generating PDF documents programmatically
There are various types of forms used in software development.
Web Forms - used for collecting user input on a website
Windows Forms - used for creating desktop applications
Mobile Forms - used for creating mobile applications
Dialog Forms - used for displaying messages or alerts to the user
Modal Forms - used for capturing user input before allowing further interaction
Wizard Forms - used for guiding the user through a mult
Triggers used in forms and their levels and uses.
Types of triggers: Pre-Form, Post-Form, Item, Validation, Navigation, Transaction
Pre-Form triggers execute before the form is displayed
Post-Form triggers execute after the form is closed
Item triggers execute when a user interacts with an item on the form
Validation triggers execute when a user enters data into an item
Navigation triggers execute when a user navigates betwe...
Single row functions operate on a single row and return one result per row. Group functions operate on a group of rows and return one result per group.
Single row functions include: numeric functions, character functions, date functions, conversion functions, and general functions.
Group functions include: AVG, COUNT, MAX, MIN, SUM.
Single row functions can be used in SELECT, WHERE, and ORDER BY clauses.
Group functions ar...
Set operators are used to combine or compare sets in SQL.
UNION operator combines two sets and removes duplicates
INTERSECT operator returns only common elements in two sets
EXCEPT operator returns elements in one set but not in the other
ALL keyword can be used with set operators to include duplicates
Set operators can only be used with compatible data types
Yes, exception handling is necessary in queries.
Exception handling helps to handle unexpected errors and prevent application crashes.
It also helps to provide meaningful error messages to the user.
In SQL, exceptions can be handled using the TRY-CATCH block.
In NoSQL databases, exceptions can be handled using error codes and messages.
Master table should have a primary key which is used as a foreign key in the transaction table.
Create a primary key in the master table
Create a foreign key in the transaction table that references the primary key in the master table
Use the foreign key to link the two tables on forms
Reports can be categorized into operational, analytical, and statutory reports.
Operational reports provide information on day-to-day activities.
Analytical reports provide insights into data trends and patterns.
Statutory reports are required by law and must be submitted to regulatory bodies.
Other types of reports include ad hoc reports, exception reports, and dashboards.
Top trending discussions
Paper based exam based on C and embedded c
I applied via Other and was interviewed in Oct 2021. There was 1 interview round.
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 Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.
I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.
I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.
Some of the top questions asked at the Virtual Galaxy Infotech Software Developer interview -
based on 1 interview
Interview experience
based on 11 reviews
Rating in categories
Software Developer
95
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Support Executive
15
salaries
| ₹0 L/yr - ₹0 L/yr |
Java Developer
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Softwaretest Engineer
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Developer
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Infosys
TCS
Wipro
HCLTech