Lirik Sfdc Tester Interview Questions and Answers

Q1. Explain project architecture?
Ans. 
Project architecture refers to the overall structure of a software project, including components, modules, and their interactions.
• Project architecture defines how different components of a software project are organized and interact with each other.

• It includes the high-level design of the system, such as the database structure, data flow, and integration points.

• Project architecture also involves decisions on technologi...read more
Answered by AI
Add your answer
Q2. Explain challenges you faced in etl testing?
Ans. 
Challenges in ETL testing include data quality issues, complex transformations, and handling large volumes of data.
• Data quality issues such as missing or incorrect data can impact testing results

• Complex transformations can be difficult to validate and may lead to errors in the ETL process

• Handling large volumes of data can slow down testing processes and require efficient testing strategies
Answered by AI
Add your answer
Q3. What are roles and responsibilities?
Ans. 
Roles and responsibilities refer to the tasks and duties assigned to an individual within a specific job or position.
• Roles define the position or job title of an individual within an organization.

• Responsibilities outline the specific tasks, duties, and expectations associated with that role.

• Roles and responsibilities help clarify expectations, define boundaries, and ensure accountability.

• Examples include testing data e...read more
Answered by AI
Add your answer
Q4. How to find duplicate values in python?
Ans. 
Use a dictionary to find duplicate values in an array of strings in Python.
• Create an empty dictionary to store the count of each string in the array.

• Iterate through the array and for each string, check if it exists in the dictionary. If it does, increment the count. If not, add it to the dictionary with a count of 1.

• After iterating through the array, check the dictionary for any strings with a count greater than 1. The
Answered by AI
Add your answer

Q1. Questions on ETL concepts
Add your answer
Q2. Find the nth row. Find the top 50% records, string function
Ans. 
Use SQL query to find the nth row and top 50% records using string function
• To find the nth row, use LIMIT and OFFSET in SQL query

• To find top 50% records, use PERCENTILE_CONT function in SQL

• String functions like SUBSTRING can be used to manipulate string data
Answered by AI
Add your answer

Q1. Agile ceremonies
Add your answer
Q2. SQL to find age from dob
Ans. 
Use SQL DATEDIFF function to calculate age from date of birth.
• Use DATEDIFF function to calculate the difference in years between current date and date of birth.

• Example: SELECT DATEDIFF(year, '2000-01-01', GETDATE()) AS Age;

• Make sure to handle leap years and edge cases like birthdate being in the future.
Answered by AI
Add your answer
Q3. SQL on string function
Add your answer
Q4. Row number, Rank, Dense Rank
Add your answer

Q1. Salary discussion, Niche skills
Add your answer

Q1. Questions on MDM testing
Add your answer

Q1. Different types of waits
Ans. 
Different types of waits include implicit, explicit, and fluent waits in automation testing.
• Implicit wait: Waits for a certain amount of time before throwing a NoSuchElementException.

• Explicit wait: Waits for a certain condition to occur before proceeding further in the code.

• Fluent wait: Waits for a condition to be true with a specified frequency of checking.

• Example: WebDriverWait in Selenium is an example of explicit w
Answered by AI
Add your answer
Q2. Multiple window handles
Ans. 
Multiple window handles are used in automation testing to handle multiple browser windows or tabs simultaneously.
• Use getWindowHandles() method to get all the window handles

• Switch between window handles using switchTo().window(handle)

• Close a specific window handle using driver.close()

• Example: driver.getWindowHandles()

• Example: driver.switchTo().window(handle)
Answered by AI
Add your answer

Q1. Sallary expected
Add your answer
Q2. Location preference
Add your answer

Q1. Explain Sanity.
Ans. 
Sanity testing is a subset of regression testing that focuses on testing specific areas of the software after changes to ensure no major issues have been introduced.
• Sanity testing is a quick and focused testing of specific functionalities to ensure they still work after changes.

• It is usually performed before full regression testing to save time and effort.

• Sanity testing is not exhaustive and does not cover all function...read more
Answered by AI
Add your answer

Q1. What is database
Ans. 
A database is a structured collection of data that is organized in a way that allows for easy access, management, and retrieval.
• A database typically consists of tables, which store data in rows and columns.

• Data in a database is stored in a structured format, such as SQL databases or NoSQL databases.

• Databases are used in various applications, such as storing user information, product data, and financial records.

• Examples...read more
Answered by AI
Add your answer
Q2. Types of data base
Ans. 
Types of databases include relational, NoSQL, object-oriented, and graph databases.
• Relational databases store data in tables with rows and columns (e.g. MySQL, PostgreSQL)

• NoSQL databases store data in non-tabular formats (e.g. MongoDB, Cassandra)

• Object-oriented databases store data as objects (e.g. db4o)

• Graph databases use graph structures for semantic queries (e.g. Neo4j)
Answered by AI
Add your answer

Networking
It configuration
Roger
WAN Technologies
Auto cad
DHCP&HSRP

Q1. What is ip address
Ans. 
An IP address is a unique numerical label assigned to each device connected to a computer network.
• IP addresses are used to identify and locate devices on a network.

• There are two types of IP addresses: IPv4 (e.g. 192.168.1.1) and IPv6 (e.g. 2001:0db8:85a3:0000:0000:8a2e:0370:7334).

• IP addresses can be static (manually assigned) or dynamic (assigned by a DHCP server).
Answered by AI
Add your answer
Q2. What Is networking
Ans. 
Networking is the practice of connecting computers and other devices together to share resources and information.
• Networking involves setting up connections between devices using cables or wireless technology.

• It allows devices to communicate with each other and share resources such as files, printers, and internet access.

• Networking can be done locally within a home or office (LAN) or over a larger geographical area (WAN...read more
Answered by AI
Add your answer

Assignment is very easy to understand the person

Q1. What is sanity testing
Ans. 
Sanity testing is a quick and shallow testing to ensure that the application is stable enough for further testing.
• It is a subset of regression testing

• It is performed after a new build or changes to the code

• It checks for major functionalities and critical features

• It is not exhaustive and does not cover all possible test cases

• It helps to save time and effort by identifying major issues early on
Answered by AI
Add your answer
Q2. What is smoke testing
Ans. 
Smoke testing is a preliminary testing technique to check if the critical functionalities of the software are working fine.
• It is a quick and shallow testing technique

• It is performed to ensure that the build is stable enough for further testing

• It is usually performed after every build

• It helps in identifying critical defects early in the testing cycle

• Example: Testing the login functionality of a website after a new build
Answered by AI
Add your answer
Q3. What are the functions of testing
Ans. 
The functions of testing are to identify defects, improve quality, and ensure the software meets requirements.
• Identify defects and errors in the software

• Improve the quality of the software

• Ensure the software meets the specified requirements

• Validate and verify the software functionality

• Reduce the risk of software failure

• Provide feedback to developers for improvement

• Ensure compliance with industry standards and regulatio
Answered by AI
Add your answer
Q4. What is difference between somke and sanity testing
Ans. 
Smoke testing is a quick and shallow test to check if the basic functionalities of the software are working. Sanity testing is a more thorough test to check if the major functionalities of the software are working after a change.
• Smoke testing is done to check if the software is stable enough for further testing

• Sanity testing is done to check if the changes made to the software have not affected the major functionalitie...read more
Answered by AI
Add your answer

Apitude testing is the person is fitted or not the job

Hash map related asked in the round two

Q1. Tell me about yourself
Add your answer