Capgemini Interview Questions, Process, and Tips

Python has several built-in datatypes including numeric, sequence, and mapping types.

• Numeric types include integers, floating-point numbers, and complex numbers.

• Sequence types include lists, tuples, and range objects.

• Mapping types include dictionaries.

• Other datatypes include boolean, bytes, and sets.

Yes, it is possible to concatenate a string and integer using type conversion.

• Convert the integer to a string using str() function and then concatenate with the string.

• Use format() method to insert the integer value into the string.

• Use f-strings to directly insert the integer value into the string.

XPath is a language used to locate elements in an XML or HTML document. Absolute and relative XPaths differ in their starting point.

• XPath is used to navigate through elements and attributes in an XML or HTML document

• Elements can be located using absolute or relative XPaths

• Absolute XPaths start from the root node and are more specific but less flexible

• Relative XPaths start from the current node and are more flexible but

Selenium supports various locators such as ID, Name, Class Name, Tag Name, Link Text, Partial Link Text, CSS Selector and XPath.

• ID locator is the most efficient and reliable locator

• Name locator is used for locating elements by their name attribute

• Class Name locator is used for locating elements by their class attribute

• Tag Name locator is used for locating elements by their tag name

• Link Text locator is used for locating...read more

findelement returns the first matching element while findelements returns a list of all matching elements.

• findelement is used to locate the first matching element on a web page

• findelements is used to locate all matching elements on a web page

• findelement throws NoSuchElementException if no matching element is found

• findelements returns an empty list if no matching element is found

Exceptions in Selenium are errors that occur during test execution.

• Some common exceptions in Selenium are NoSuchElementException, TimeoutException, StaleElementReferenceException, and ElementNotVisibleException.

• NoSuchElementException occurs when an element cannot be found on the page.

• TimeoutException occurs when a command takes too long to execute.

• StaleElementReferenceException occurs when an element is no longer attac...read more

To select a value from dropdown in Selenium, use the Select class and its methods.

• Locate the dropdown element using any of the locators like ID, name, class name, etc.

• Create an object of the Select class and pass the dropdown element as a parameter.

• Use the Select class methods like selectByVisibleText(), selectByValue(), or selectByIndex() to select the desired option.

• Finally, use the assert statement to verify if the

Synchronization is the process of coordinating the execution of multiple threads to ensure proper order of execution.

• Synchronization can be achieved using techniques like locks, semaphores, and monitors.

• Locks are used to ensure that only one thread can access a shared resource at a time.

• Semaphores are used to control access to a shared resource by limiting the number of threads that can access it at once.

• Monitors are u...read more

Break, continue and pass are control statements used in loops. Break terminates the loop, continue skips an iteration and pass does nothing.

• Break is used to terminate a loop when a certain condition is met

• Continue is used to skip an iteration of a loop when a certain condition is met

• Pass is used as a placeholder when a statement is required syntactically but no action is needed

Full join is a type of SQL join that returns all the rows from both tables, matching rows from both tables and nulls where there is no match.

• Full join is also known as a full outer join.

• It is used to combine data from two tables where some of the data may not match.

• The result set includes all the rows from both tables, with nulls where there is no match.

• Full join is represented by the keyword 'FULL OUTER JOIN' in SQL.

• E...read more

Query to find second highest salary in SQL

• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to select the second highest salary

• Use a subquery to exclude the highest salary from the results

To fetch 1st 5 records in SQL, use the LIMIT clause.

• Use the SELECT statement to specify the columns to retrieve.

• Use the FROM clause to specify the table to retrieve data from.

• Use the LIMIT clause to specify the number of records to retrieve.

• The syntax is: SELECT column1, column2, ... FROM table_name LIMIT 5;

• The first 5 records will be returned.

To copy a table in MySQL, use the CREATE TABLE statement with the SELECT statement.

• Use the CREATE TABLE statement with the SELECT statement to copy a table.

• Specify the new table name after the CREATE TABLE statement.

• Specify the original table name after the SELECT statement.

• Add any additional conditions or clauses as needed.

• Example: CREATE TABLE new_table SELECT * FROM original_table WHERE condition;

To fetch unique elements from a column, use the DISTINCT keyword in SQL.

• Use the SELECT statement with the DISTINCT keyword.

• Specify the column name from which you want to fetch unique elements.

• Example: SELECT DISTINCT column_name FROM table_name;

• You can also use GROUP BY clause to group the unique elements based on another column.

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name;

SQL query to find names of employees starting with 'A'

• Use the SELECT statement to retrieve data from the employee table

• Use the LIKE operator to match the names starting with 'A'

• Use the % wildcard to match any number of characters after 'A'

To open a file and read repeating words, use file handling and string manipulation techniques.

• Open the file using file handling techniques in the programming language of your choice.

• Read the contents of the file and store it in a string variable.

• Split the string into an array of words using a delimiter such as space or comma.

• Loop through the array and use a dictionary or hash table to count the frequency of each word.

• P...read more

Generating random emails in Python with constant domain

• Use the random module to generate random strings for the username part of the email

• Combine the random username with the constant domain name

• Ensure the generated email is unique if required

Python provides random module to generate random data and numbers.

• Import random module

• Use random.randint() to generate random integer within a range

• Use random.choice() to select a random element from a list

• Use random.random() to generate a random float between 0 and 1

• Use random.uniform() to generate a random float within a range

Arrays are fixed in size, while lists can grow or shrink dynamically.

• Arrays are a collection of elements of the same data type, while lists can contain elements of different data types.

• Arrays are accessed using an index, while lists are accessed using an iterator.

• Arrays are faster for accessing elements, while lists are faster for inserting or deleting elements.

• Examples of arrays include int[] and char[], while example

To run a test suite using robotframework command line, use the 'robot' command followed by the path to the test suite file.

• Open the command prompt or terminal

• Navigate to the directory containing the test suite file

• Enter the command 'robot' followed by the name of the test suite file

• Add any additional options or arguments as needed

• Press enter to execute the command

• Example: robot my_test_suite.robot

• Example with options: ...read more

To validate data after page refresh in Selenium, we can refresh the page and then use explicit wait to validate the data.

• Refresh the page using driver.navigate().refresh() method

• Use explicit wait to wait for the element to be visible on the page

• Validate the data using getText() or getAttribute() method

• Example: driver.navigate().refresh(); WebDriverWait wait = new WebDriverWait(driver, 10); wait.until(ExpectedConditions...read more

As a Senior Automation Test Engineer, my roles and responsibilities include designing and implementing automated test scripts, identifying and reporting software defects, and collaborating with cross-functional teams to ensure high-quality software delivery.

• Designing and implementing automated test scripts using tools like Selenium, Appium, or JUnit

• Identifying and reporting software defects and working closely with dev...read more

I prefer not to disclose my current CTC. As for my expected CTC, I am looking for a competitive salary based on my experience and skills.

• I am open to negotiation based on the job responsibilities and company's budget

• I have researched the market rates for similar positions and have a realistic expectation

• I am looking for a salary that reflects my experience and skills

• I am also interested in other benefits such as health

Yes, I am willing to relocate to Hyderabad.

• I am open to new opportunities and experiences in different locations.

• I have researched about Hyderabad and I am excited about the city's culture and opportunities.

• I am ready to adapt to a new environment and build a life in Hyderabad.

I balance my professional life and studies through effective time management, prioritization, and self-discipline.

• I create a detailed schedule that allocates specific time blocks for work and study, ensuring I stay organized.

• I prioritize tasks based on deadlines and importance, allowing me to focus on high-impact assignments first.

• I utilize tools like calendars and task management apps to keep track of both work respon...read more

Cash flow types include operating, investing, and financing; direct and indirect methods differ in presentation and calculation.

• Types of cash flow: Operating, Investing, Financing.

• Operating cash flow: Cash generated from core business activities.

• Investing cash flow: Cash used for investments in assets or securities.

• Financing cash flow: Cash received from or paid to investors and creditors.

• Direct cash flow: Lists actual...read more

The P2P cycle involves the process of procuring goods and services, from requisition to payment.

• 1. Requisition: Initiating a purchase request, e.g., a department needing office supplies.

• 2. Purchase Order: Creating a formal order to the supplier, ensuring terms are clear.

• 3. Receipt of Goods/Services: Confirming delivery and quality of items received.

• 4. Invoice Processing: Matching the supplier's invoice with the purchas...read more

I have a notice period of one month, and I plan to manage my studies by creating a structured schedule and prioritizing tasks.

• Create a detailed study schedule that allocates specific time slots for studying each subject.

• Utilize weekends and evenings for intensive study sessions to maximize productivity.

• Incorporate breaks to avoid burnout and maintain focus during study periods.

• Use productivity tools like calendars or a...read more

HMV and LMV in GST refer to High Value and Low Value transactions, impacting compliance and reporting requirements.

• HMV (High Value) transactions are those exceeding a specified monetary threshold, requiring detailed reporting.

• LMV (Low Value) transactions are those below the threshold, often subject to simplified compliance.

• For example, if the threshold is set at ₹2,50,000, any transaction above this is HMV, while those...read more

GSTR-1 is a monthly return for outward supplies, while GSTR-3B is a summary return for GST payment.

• GSTR-1 is filed by registered taxpayers to report sales and outward supplies.

• It includes details like invoice-wise sales, credit/debit notes, and exports.

• Example: A business selling goods worth ₹1,00,000 must report this in GSTR-1.

• GSTR-3B is a simplified return for taxpayers to declare their GST liability.

• It includes summ...read more

I have worked with design patterns such as Singleton, Factory, Observer, and Strategy.

• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified a...read more

I would immediately investigate the issue, identify the root cause, and work on a solution to prevent it from happening again.

• Investigate the issue thoroughly to understand the scope and impact

• Identify the root cause by analyzing logs, code, and configurations

• Work on a solution to fix the issue and prevent it from reoccurring

• Communicate with stakeholders about the issue and the steps taken to resolve it

Yes, I am able to work under pressure by staying organized, prioritizing tasks, and maintaining a positive attitude.

• I stay organized by creating to-do lists and setting deadlines for tasks.

• I prioritize tasks based on urgency and importance to ensure critical tasks are completed first.

• I maintain a positive attitude by taking short breaks, practicing deep breathing exercises, and seeking support from colleagues when need

SOLID is a set of five principles in object-oriented programming that help make software designs more understandable, flexible, and maintainable.

• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open/Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Objects of a superclass should be replaceable with object...read more

Identify first occurrences of vowels in a string and return their indices along with count.

• Loop through the string and check if each character is a vowel (a, e, i, o, u)

• Store the index of the first occurrence of each vowel in a separate array

• Return the array of indices and the count of indices

Calculate the difference between two integers and find how many numbers within that difference are divisible by 3.

• Calculate the absolute difference between the two integers

• Iterate through the range of numbers within the difference and check if each number is divisible by 3

• Keep a count of numbers divisible by 3

Content negotiation in ASP .Net Web API allows clients to request data in different formats like JSON, XML, etc.

• Content negotiation is the process of selecting the best representation for a given response when there are multiple representations available.

• In ASP .Net Web API, content negotiation is handled by the MediaTypeFormatter class which selects the appropriate formatter based on the request headers.

• Clients can sp...read more

Git conflicts can be resolved by merging changes, resolving conflicts manually, and using tools like Git mergetool.

• Merge changes from the conflicting branches

• Resolve conflicts manually by editing the conflicting files

• Use Git mergetool to help resolve conflicts

• Commit the resolved changes after resolving conflicts

Static constructor is used to initialize static data members of a class.

• Executed only once when the class is first accessed

• Cannot have any access modifiers or parameters

• Used to initialize static variables or perform any necessary setup tasks

To invoke methods from two interfaces with same method names, use explicit interface implementation.

• Use explicit interface implementation to differentiate between the methods from each interface.

• Specify the interface name followed by the method name to invoke the desired method.

• Example: InterfaceA.Method() and InterfaceB.Method() to invoke methods from InterfaceA and InterfaceB respectively.

Count the occurrence of each character in a given string.

• Iterate through the string and use a hashmap to store the count of each character.

• Handle both uppercase and lowercase characters separately.

• Consider using ASCII values to map characters to their respective counts.

Rest is lightweight, WCF is feature-rich. Rest uses HTTP, WCF uses SOAP. Rest is platform-independent, WCF is Microsoft-centric.

• Rest is lightweight and simple to use, making it ideal for web services. WCF is feature-rich and provides more advanced capabilities.

• Rest uses HTTP for communication, making it easier to work with in web environments. WCF uses SOAP, which can be more complex and heavyweight.

• Rest is platform-in...read more

Microservices communicate with each other through APIs, messaging queues, and service discovery.

• APIs: Microservices can communicate with each other by exposing APIs that allow them to send and receive data.

• Messaging queues: Microservices can use messaging queues like RabbitMQ or Kafka to send messages to each other asynchronously.

• Service discovery: Microservices can use service discovery tools like Consul or Eureka to ...read more

Clustered index physically orders the data rows in the table, while non-clustered index does not.

• Clustered index determines the physical order of data rows in the table.

• Non-clustered index is a separate structure that contains pointers to the actual data rows.

• Clustered index is faster for retrieval of data in the order of the index key.

• Non-clustered index is faster for retrieval of data not in the order of the index ke