Technical Flashcards
What is schema
Database with multiple tables
What is Alias level column
Result level and column level
You have 4 tables so which one is the JOIN right
After putting JOINS then last join is right tables
Table a
Table b
How do sort results
ORDER BY
What is an end point
A source where we get info or send info to.
Variables CRUD
Create POST
Retrieve GET
UPDATE PUT
delete DEL
What have you done in automation
Regression testing
What is selenium
Selenium is a open-source tool used for automating web browsers.
What’s the reason for automation
There’s Less human error and increased efficiency
What is a breaking point?
Where application crashes
What is the language you used in automation
Java
How do you identify the right table after JOIN?**
By specifying the correct join condition that links the tables based on their related data.
- How do you sort results?
By using the ORDER BY
What is the difference between left and right join?*
Left join returns all records from the left table and the matched records from the right table. Right join returns all records from the right table and the matched records from the left table.
What is a subquery
A subquery is a query nested within another query, allowing you to retrieve data from one or more tables based on conditions.
- What is default sort for any table? By what column?
Tables in databases typically have no default sort order. Sorting is applied based on the specified ORDER BY clause in a query.
How would you rate yourself in API? Why?**
I would d rate myself 7 in API because of my extensive experience in designing, developing, and integrating APIs across various projects,
What does API stand for?
Application Programming Interface.
What are some of the authentications you used in Postman?
• Some authentication methods in Postman include Basic Auth, OAuth 2.0, API Key, and Bearer Token.
Difference between PUT and POST
PUT is used to update an existing resource, while POST is used to create a new resource.
What have you used in automation?
Selenium for web testing and postman for api
What is a dynamic value?
dynamic value is a value in a test scenario that changes each time the scenario is executed, such as timestamps, session IDs, or randomly generated data.
What if functional test doesn’t complete before UAT deployment?
• If functional tests don’t complete before UAT deployment, it may indicate a risk of deploying untested features. In such cases, it’s crucial to prioritize critical tests and communicate any remaining issues or risks to stakeholders for informed decision-making.
What is the difference between column level and results level Alias AS
Column-level AS (Alias) is used to rename a specific column in a query result,
result-level AS renames the result set of an entire query or subquery.
Total Count of Rows the table Contains.
COUNT
Total of all the numbers added together.
SUM
Average of all the numbers put together.
Average
Highest Number compared to other values of the selected column.
MAX
Lowest number compared to other values of the selected column.
MIN
● WHERE Clause.
● PURPOSE IS TO SPECIFY ROWS USING CONDITIONS.
● CAN ONLY BE USED ONCE IN A QUERY.
What does Selenium help you do?**
Selenium helps automate web browser interactions and testing
How do you find an element?*
- I use locators such as ID, class name, XPath, to find and interact with elements on a web page in Selenium.
What is implicit or explicit wait?*
Implicit wait instructs Selenium to wait for a certain amount of time for elements to become available. Explicit wait waits for a specific condition to be met before proceeding with the execution of test steps.
What type of test do we automate in general?
We generally automate regression tests because its reusable
What is authentication
verifying the identity of a user or client making a request to an API.
What is column level Alias
Temporary name assigned to a column in sql query
how do you identify an element within selenium?
driver findElement(By.xpath
- right click, , inspect, use xpath
how do you identify an element within selenium?
driver findElement(By.xpath
- right click, , inspect, use xpath
if your code break, what are your debugging process like?
- I understand the error code first, I find which line the code broke at and put a breakpoint next to that line. re-run the script.
how to complete a put operation to an endpoint without a body?
you use the GET function to get the body, copy and paste it in body field. then update it to what is requested and then use PUT function.
GET - copy and paste - update - PUT
