Cambridge Technology Enterprises QA Lead Interview Questions and Answers

Q1. What is Tuples? How do you convert a string to a tuple?
Ans. 
Tuples are immutable sequences of elements. A string can be converted to a tuple using the tuple() function.
• Tuples are similar to lists but are immutable

• Elements of a tuple are enclosed in parentheses ()

• A string can be converted to a tuple using the tuple() function

• Each character in the string becomes an element in the tuple
Answered by AI
Add your answer
Q2. What is Left Join? Show one Left join for 2 data frames on Python
Ans. 
Left join is a type of join operation in SQL that returns all the rows from the left table and matching rows from the right table.
• Left join is performed using the 'left join' keyword in SQL

• In Python, left join can be performed using the 'merge' function from the pandas library

• Syntax: pd.merge(left_dataframe, right_dataframe, how='left', on='key_column')

• Example: pd.merge(df1, df2, how='left', on='id')
Answered by AI
Add your answer

Q1. Question related to oops
Add your answer
Q2. Question related to coding
Add your answer
Q3. I was rejected after 2nd round
Add your answer

Q1. Question related to advanced topic in oops
Add your answer
Q2. Question related to coding
Add your answer

There were 3 rounds for data science consultant position at Equifax. 1st round consists of Python and SQL questions and also in this round they have tested analytical thinking as well.

In 2nd round they have asked me questions from my resume and asked me to explain the projects which I have worked on in previous company. In this round they have asked me pandas related questions and asked me write code.

Q1. In Managerial round again here I have been asked questions related my projects. and no coding round in this stage.
Add your answer

On python and sql coding.they ask simple to complex questions

Q1. On data science machine learning
Add your answer

Q1. Paging, CSFB, HO, RLF, Rach failed reason, protocol initialization step by qxdm logs
Add your answer

Q1. QXDM Tool, QCAT, Log analysis, debugging, LAB Structure, Harq, DCI, TM
Add your answer

Q1. Data flow from enodeb to UE along with all imp step and ies, Vowifi architecture, Lenux basic command, Kubernates command, Harq, NDI, tp analysis with qxdm logs
Add your answer

Q1. Can you take a assessment test?
Ans. 
Yes, I am willing to take an assessment test to demonstrate my skills and knowledge.
• I am open to taking any assessment test required for the position.

• I believe that assessment tests are a valuable tool for evaluating candidates.

• I am confident in my abilities and knowledge to perform well on the assessment test.
Answered by AI
Add your answer
Q2. How long have you been out of college?
Ans. 
I have been out of college for 3 years.
• I graduated in 2018.

• I have been working in the industry since then.

• I have gained valuable experience in my field during this time.
Answered by AI
Add your answer

Q1. How early can you start?
Add your answer
Q2. When can you start?
Add your answer

Test of SQL, Tableau and other skills based on your resume on Skillate

Q1. SQL and other skills technical questions
Add your answer

Q1. Manager round / 2nd technical round
Add your answer

Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
Add your answer
Q2. Joining tables with different joins
Ans. 
Joining tables with different joins in SQL
• Use INNER JOIN to return rows when there is at least one match in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables
Answered by AI
Add your answer