Filter interviews by
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
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.
Good
I was interviewed in Sep 2016.
Developed a web-based project management tool for a software development company.
Used Agile methodology for development
Implemented features like task assignment, progress tracking, and team collaboration
Integrated with third-party tools like GitHub and Slack
Designed a user-friendly interface with responsive design
Deployed on AWS using EC2 and RDS
My CV showcases my experience in software development, including projects in Java, Python, and web development.
Experience in Java, Python, and web development
Worked on projects involving database management systems
Familiar with Agile development practices
I was interviewed in May 2017.
Developed a web-based project management system for tracking tasks and deadlines.
Used HTML, CSS, JavaScript for front-end development
Implemented backend using Node.js and MongoDB for database management
Incorporated user authentication and authorization features
Utilized Agile methodology for project management
I was interviewed before Jun 2016.
An induction motor can be started by providing a rotating magnetic field.
Use a three-phase power supply to create a rotating magnetic field
The magnetic field induces a current in the rotor, causing it to rotate
The motor may require a starting capacitor or a starting winding to provide the initial torque
Once the motor reaches its rated speed, the starting mechanism can be switched off
I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.
Experienced in full stack web development
Proficient in languages like JavaScript, Python, and Java
Familiar with frameworks like React, Node.js, and Spring Boot
Strong problem-solving and analytical skills
Excellent team player with good communication skills
I was interviewed in Mar 2017.
I was interviewed in Dec 2016.
I was interviewed before May 2016.
Passion for problem-solving and creating innovative solutions drives my interest in software industry.
Passion for problem-solving and creating innovative solutions
Interest in technology and its impact on society
Opportunity for continuous learning and growth
Desire to work on cutting-edge projects and contribute to advancements in the field
Infosys is a global leader in technology services and consulting, known for its innovative solutions and strong company culture.
Infosys has a strong reputation for delivering high-quality technology solutions to clients worldwide.
The company offers a wide range of opportunities for career growth and development.
Infosys has a collaborative and inclusive work culture that values diversity and innovation.
Developed a web-based project management system for tracking tasks and deadlines
Used HTML, CSS, JavaScript for front-end development
Implemented backend using Node.js and MongoDB for database management
Incorporated user authentication and authorization features
Tested the system for performance and security vulnerabilities
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 |
Senior Software Developer
10
salaries
| ₹0 L/yr - ₹0 L/yr |
System Administrator
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Infosys
TCS
Wipro
HCLTech