London Stock Exchange Group Senior Test Engineer 2 Interview Questions and Answers

Q1. All intermediate level selenium questions
Add your answer

Q1. Basic Java program
Add your answer
Q2. Selenium Automation coding
Add your answer

Q1. Basic java programs
Add your answer
Q2. Selenium auto coding
Add your answer

Q1. General project related roles and responsibilities
Add your answer

Q1. Salary discussion
Add your answer

Q1. Table 1 has values as 1,1,1 Table 2 has values as 1,1,0. What is the output of each joins
Ans. 
The output of each join between Table 1 and Table 2 with values 1,1,1 and 1,1,0 respectively.
• Inner join: Output will be 1,1,1 as it only includes matching values from both tables.

• Left join: Output will be 1,1,1 from Table 1 as it includes all values from Table 1 and matching values from Table 2.

• Right join: Output will be 1,1,0 from Table 2 as it includes all values from Table 2 and matching values from Table 1.

• Full out...read more
Answered by AI
Add your answer
Q2. How to find duplicates and by not using count(*)
Ans. 
To find duplicates without using count(*), use self-join and group by clause.
• Use self-join to join the table with itself on the column that contains the duplicates.

• Use group by clause to group the results by the column that contains duplicates.

• Select the columns you want to display along with the count of duplicates.
Answered by AI
Add your answer

Q1. About my Previous experience
Add your answer
Q2. About Banking fundamentals
Add your answer

Q1. Selenium basics
Add your answer
Q2. Sql questions and java
Add your answer

1.WAP to convert double value to String
2.WAP to convert character to int
3.Remove the duplicate elements from an ArrayList
4.What are the tools used to automate in appium
5. Axes path

Q1. 1. Scenario based questions on rest assured
Add your answer
Q2. Detailed question on performance testing 90th percentile
Add your answer
Q3. Automation framework Design discussion and challenges faced
Add your answer
Q4. How to connect db from Java code and one scenario question on this
Add your answer

Q1. About cba core values discussion
Add your answer

Q1. Question Related to SQL Logics
Add your answer
Q2. ETL Validations and Datawarehouse concepts
Add your answer

Q1. Managing Team Members
Add your answer
Q2. SQL Logics and QA Env Setups
Add your answer

Q1. Reason for Job Change
Add your answer
Q2. Package Discussions and negotiations
Add your answer

Q1. Basic automation questions
Add your answer

Q1. About agile process and some problem statements
Add your answer