CSG International Interview Questions and Answers

OOP (Object-Oriented Programming) is a programming paradigm based on objects and classes, promoting code reusability and organization.

• Encapsulation: Bundling data and methods that operate on the data within one unit (e.g., a class).

• Inheritance: Mechanism to create a new class using properties and methods of an existing class (e.g., a 'Dog' class inheriting from an 'Animal' class).

• Polymorphism: Ability to present the sa...read more

My current CTC is a reflection of my skills and experience, aligning with industry standards for an SDET intern role.

• CTC stands for Cost to Company, which includes salary, benefits, and bonuses.

• For example, if my CTC is $60,000, it may include a base salary of $50,000 and $10,000 in benefits.

• It's important to consider both fixed and variable components of CTC.

• I can provide a breakdown of my current CTC if needed.

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 ...read more

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...read more

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...read more

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...read more