City & Guilds Test Analyst Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented Test Analyst with a strong background in software testing and quality assurance.
• Over 5 years of experience in testing web and mobile applications

• Proficient in creating test plans, test cases, and executing test scripts

• Skilled in identifying and documenting software defects

• Experience with automated testing tools such as Selenium

• Strong analytical and problem-solving skills
Answered by AI
Add your answer
Q2. Oops concepts & Basic programs with Collection questions
Add your answer

Q1. Reverse a number
Ans. 
Reverse a number by converting it to a string and then reversing the characters
• Convert the number to a string

• Reverse the characters of the string

• Convert the reversed string back to a number
Answered by AI
Add your answer
Q2. Reverse a String
Ans. 
Reverse a given string
• Create a character array from the input string

• Use two pointers to swap characters from start and end of the array

• Continue swapping until the pointers meet in the middle
Answered by AI
Add your answer

Q1. How to write xpath?
Ans. 
XPath is a language used for locating nodes in an XML document.
• XPath uses path expressions to select nodes or node-sets in an XML document.

• It can navigate through elements and attributes in an XML document.

• XPath expressions can be used in various programming languages and tools like Selenium for web automation.

• Example: //div[@class='example'] selects all div elements with class 'example'.
Answered by AI
Add your answer
Q2. What is assertion?
Ans. 
Assertion is a statement that verifies the expected outcome of a test case.
• Assertion is used to validate whether the actual result matches the expected result in a test case.

• It helps in determining the success or failure of a test case.

• Common types of assertions include checking for equality, presence of elements, and error messages.

• Example: Assert.assertEquals(expectedResult, actualResult)
Answered by AI
Add your answer

Its easy to complete, we can complete it with some preparation on Aptitude

Questions are easy and Crisp, you need to answer promptly

Q1. Question related to Appium
Add your answer

Q1. Starting with our experience and contributions in project
Add your answer
Q2. Data quality checks like duplicate, length , truncation
Add your answer
Q3. Database data warehouse difference
Ans. 
Database stores data for applications, data warehouse stores data for analysis.
• Database is used for transactional processing, data warehouse is used for analytical processing.

• Database stores current data, data warehouse stores historical data.

• Database is optimized for read and write operations, data warehouse is optimized for read operations.

• Examples of databases include MySQL, Oracle, and SQL Server. Examples of data ...read more
Answered by AI
Add your answer
Q4. Views tables difference
Ans. 
Views tables difference
• Views are virtual tables that display data from one or more tables

• Views do not store data, whereas tables do

• Views can be used to restrict access to certain columns or rows

• Tables can be modified directly, whereas views cannot
Answered by AI
Add your answer
Q5. Cast function - to change datatype
Ans. 
Cast function is used to change the datatype of a value or expression in SQL.
• Syntax: CAST(expression AS datatype)

• Example: CAST('123' AS INT) will convert the string '123' to integer datatype

• Supported datatypes: INT, FLOAT, DECIMAL, CHAR, VARCHAR, DATE, TIME, etc.
Answered by AI
Add your answer
Q6. Datatype of selected columns should remain same or not for minus query?
Ans. 
Datatype consistency in minus query
• Datatype of selected columns should remain same for minus query

• Mismatch can cause errors or unexpected results
Answered by AI
Add your answer
Q7. Fact dimension difference, snowflake star schema difference
Add your answer
Q8. Which is better ? Star schema or snowflake schema
Ans. 
Both have their own advantages and disadvantages depending on the use case.
• Star schema is simpler and easier to understand, but may not be suitable for complex data relationships.

• Snowflake schema is more normalized and can handle complex data relationships, but can be more difficult to understand and maintain.

• The choice between the two depends on the specific requirements of the project and the data being analyzed.

• For ...read more
Answered by AI
Add your answer

Q1. Package negotiation and location preference
Add your answer

Q1. PERFORANCETESTING
Add your answer
Q2. FUNCTION USED IN CORRELATION
Ans. 
Correlation function is used to find the relationship between two variables.
• Correlation function measures the strength of the linear relationship between two variables.

• It returns a value between -1 and 1, where -1 indicates a perfect negative correlation, 0 indicates no correlation, and 1 indicates a perfect positive correlation.

• Examples of correlation functions include Pearson correlation coefficient, Spearman's rank ...read more
Answered by AI
Add your answer
Q3. WHAT IS CORRELATION?
Ans. 
Correlation is a statistical measure that shows the relationship between two variables.
• Correlation measures the strength and direction of the relationship between two variables.

• It ranges from -1 to 1, where -1 indicates a perfect negative correlation, 0 indicates no correlation, and 1 indicates a perfect positive correlation.

• Correlation does not imply causation.

• Examples of correlated variables include age and income, h...read more
Answered by AI
Add your answer
Q4. TOOLS USED IN PT
Ans. 
Various tools are used in Penetration Testing (PT) such as Nmap, Metasploit, Burp Suite, Wireshark, etc.
• Nmap is used for network scanning and mapping

• Metasploit is used for exploiting vulnerabilities

• Burp Suite is used for web application testing

• Wireshark is used for network traffic analysis

• Other tools like Nessus, Acunetix, etc. are also used depending on the requirements
Answered by AI
Add your answer
Q5. SOFTWARE TESTING LIFE CYCLE
Ans. 
Software Testing Life Cycle (STLC) is a process followed to ensure quality in software development.
• STLC includes planning, designing, executing, and reporting phases.

• It starts with requirement analysis and ends with post-release testing.

• STLC ensures that the software meets the specified requirements and is bug-free.

• It involves various types of testing such as unit testing, integration testing, system testing, and accep...read more
Answered by AI
Add your answer

Q1. What is Smoke & Sanity Test
Ans. 
Smoke test is a quick test to check if the basic functionalities of the application are working, while Sanity test is a focused test to check specific areas of the application after changes.
• Smoke test is a high-level test to check if the critical functionalities of the application are working properly.

• Sanity test is a narrow and deep test to check specific areas of the application after changes.

• Smoke test is usually pe...read more
Answered by AI
Add your answer