i
CSG International
Filter interviews by
SQL views are virtual tables that display data from one or more tables based on a predefined query.
SQL views are saved queries that can be used to simplify complex queries.
They can be used to hide the complexity of underlying tables from users.
Views can also be used to restrict access to certain columns or rows of a table.
Changes made to the underlying tables are reflected in the views.
Example: CREATE VIEW vw_employee
Constraints in SQL are rules and restrictions that are applied to columns in a table to ensure data integrity and consistency.
Constraints ensure data accuracy and consistency in a database
Common constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, and DEFAULT
NOT NULL constraint ensures a column cannot have a NULL value
UNIQUE constraint ensures all values in a column are unique
PRIMARY KEY constraint un...
Conflicts in Git are resolved by merging changes, rebasing, or using tools like Git GUI or GitKraken.
Merge conflicting branches using 'git merge' command
Rebase conflicting branches using 'git rebase' command
Use tools like Git GUI or GitKraken to visually resolve conflicts
Manually edit files to resolve conflicts
Use 'git status' and 'git diff' to identify conflicting files
OOPs concept is a programming paradigm that focuses on objects and classes to organize code and promote reusability.
OOPs stands for Object-Oriented Programming
It involves concepts like inheritance, encapsulation, polymorphism, and abstraction
Classes are blueprints for objects, which have attributes and methods
Objects are instances of classes that can interact with each other
Example: A project using OOPs may have classe...
Cucumber is a testing framework that supports Behavior Driven Development (BDD) by allowing tests to be written in plain language.
Cucumber uses Gherkin syntax to define test cases in a human-readable format
It allows collaboration between technical and non-technical team members
Cucumber integrates with various programming languages like Java, Ruby, etc.
It promotes reusability of code through feature files and step defin
I have experience in various types of testing, knowledge of Linux, automation experience, and domain knowledge.
Worked on UI testing for web applications using Selenium
Performed component testing for API endpoints using Postman
Familiar with testing on Linux platforms
Experience in automation testing using tools like Jenkins and JUnit
Domain knowledge in e-commerce and retail industries
Top trending discussions
I applied via Company Website and was interviewed in Sep 2024. There were 2 interview rounds.
Testing Pyramid is a testing strategy that suggests the right balance of different types of automated tests.
The Testing Pyramid consists of three layers: Unit Tests, Service Tests, and UI Tests.
Unit Tests are at the bottom of the pyramid and focus on testing individual components or functions in isolation.
Service Tests are in the middle layer and focus on testing the interactions between different components or service...
Developers perform unit testing to ensure individual units of code are working correctly.
Developers are responsible for writing unit tests for their own code.
Unit testing is typically done using testing frameworks like JUnit, NUnit, or pytest.
Unit tests focus on testing small, isolated parts of the codebase, such as functions or methods.
Unit testing helps identify bugs early in the development process.
Automated unit te...
Automation code for handling multiple windows
Use getWindowHandles() method to get handles of all open windows
Switch between windows using switchTo().window() method
Perform actions on each window as needed
Convert string to array and extract vowels into a new array
Iterate through each character in the string
Check if the character is a vowel (a, e, i, o, u)
Add the vowel to a new array of strings
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
In this first round it was of 45mins which included MCQ question and 1 coding question.
Answers to common interview questions for Automation Test Engineer position.
Const is used for constant values that cannot be reassigned, var is used for variable declaration, and char is a data type for storing characters in programming languages.
OOPs concepts include inheritance, encapsulation, polymorphism, and abstraction. Example: Inheritance allows a class to inherit properties and methods from another class.
JavaS...
Type coercion is the process of converting one data type to another in programming.
Type coercion can happen implicitly or explicitly in programming languages.
Implicit type coercion occurs when the language automatically converts data types during operations.
Explicit type coercion occurs when the programmer manually converts data types using functions or operators.
Example: In JavaScript, the addition operator (+) can pe...
Inheritance is a mechanism in object-oriented programming where a class inherits properties and behaviors from another class. Polymorphism allows objects of different classes to be treated as objects of a common superclass.
Inheritance allows for code reusability by defining a new class based on an existing class.
Polymorphism enables flexibility in programming by allowing objects to be treated as instances of their pare...
API error codes are unique identifiers used to indicate specific errors in an API response.
API error codes are typically numeric or alphanumeric codes that correspond to specific errors in the API.
Each error code should have a corresponding explanation in the API documentation to help developers understand the issue.
Examples of API error codes include 400 Bad Request, 401 Unauthorized, and 404 Not Found.
I applied via Walk-in and was interviewed in Jun 2024. There were 3 interview rounds.
It included aptitude...selenium questions...java mcq questions...and a program to write
Object-oriented programming paradigm that focuses on objects and classes for code organization and reusability.
Encapsulation: bundling data and methods that operate on the data into a single unit (object)
Inheritance: ability of a class to inherit properties and behavior from another class
Polymorphism: ability to present the same interface for different data types
Abstraction: hiding the complex implementation details an
I was interviewed before Jan 2024.
I applied via campus placement at SRM Institute of Science & Technology, Chennai and was interviewed in Jan 2024. There were 3 interview rounds.
Mcq and sql questions along with core subject mcq
Count duplicates in an array of strings
Iterate through the array and use a HashMap to store the count of each string
Check if the count of a string is greater than 1, then it is a duplicate
Return the total count of duplicates found in the array
I was interviewed in Feb 2024.
GRE and IPSEC are both protocols used for secure communication over networks, but they have different purposes and implementations.
GRE (Generic Routing Encapsulation) is a tunneling protocol used to encapsulate a wide variety of network layer protocols inside virtual point-to-point links. It does not provide encryption or authentication.
IPSEC (Internet Protocol Security) is a suite of protocols used to secure Internet ...
Interview experience
based on 4 reviews
Rating in categories
Software Development Engineer II
156
salaries
| ₹8.8 L/yr - ₹22 L/yr |
Software Developer
108
salaries
| ₹6 L/yr - ₹16.2 L/yr |
Senior Development Consultant
102
salaries
| ₹8 L/yr - ₹19 L/yr |
Software Development Engineer
97
salaries
| ₹5.8 L/yr - ₹15 L/yr |
Software Development Engineer 1
96
salaries
| ₹7.5 L/yr - ₹17 L/yr |
Amdocs
Tech Mahindra
TCS
Infosys