CSG International
Theme Engineering Services Interview Questions and Answers
Q1. 1. What types of testing have you worked on? Uit, Component etc 2. Knowledge on Linux 3. Automation experience 4. Domain knowledge
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
Q2. What are the constraints in sql
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 uniquely identifies each record in a table
FOREIGN KEY constr...read more
Q3. How do you handle conflicts in Git
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
Q4. Explain oops concept with project
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 classes like 'Employee' with attributes like 'name' and 'salary'
Q5. Explain about cucumber framework
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 definitions
Q6. What is sql views
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 AS SELECT emp_id, emp_name FROM employees;
More about working at CSG International
Interview Process at Theme Engineering Services
Reviews
Interviews
Salaries
Users/Month