Database/automation

Question 1

What is your role in database testing?

Answer 1

Validate and verify data, to test the relationship between tables, to test the table structure and data accuracy by writing complex SQL queries/statements
You test actual data against your requirements

Question 2

What is the difference between primary and foreign key?

Answer 2

Primary key – this is the most unique value or column of data in a table. Appears once in a table
Foreign key – this is data shared amongst multiple tables that can be used to form relationship between tables

Question 3

Differences between the JOINS

Answer 3

Inner join – matching info from two tables
Right join – matching and all info from right table, (N/A)
Left join – matching and all info from left table
Full outer join – all data

Question 4

What database tool are you familiar with?

Answer 4

Oracle SQL developer
Microsoft SQL server
MySQL
Mongo DB
PostgreSQL
Toad

Question 5

What is your automation framework

Answer 5

Selenium webdriver – automation tool
Java – coding language
IntelliJ – IDE – editor
Maven – built tool, dependencies and archives, jars, maven’s live repository to access and implement the dependencies directly into our projects
TestNG – testing Framework, organize, structure, and execute test (annotations, xml suite, execute tests in parallel or cross browser)

Question 6

What is maven and what is the advantage of it when compared to a java project

Answer 6

Maven – plugin that could be used across all projects, dependencies and archives are located in a live repository, POM file (add you dependencies and the components of your project)

Question 7

is the most ideal locator to use when locating an element

Answer 7

must be a unique locator (lD, Name), Xpath (dynamic and you can locate using relative or absolute xpath)
Relative and absolute xpath:
Relative – you are locating a unique element closer to the element you are trying to locate. And then you can go down the HTTP hierarchy to your element
Absolute- you are starting from the beginning of the http hierarchy to your element

Question 8

What is the different between static and non-static method

Answer 8

Static – you can access this method directly using the class name and dot (.) operator. Static methods and variables belong to the class.
Non-static – you can access this method by creating an instance of the class and then using that with the dot operator to call your method

Question 9

What are the different types of waits available and when would you use them?

Answer 9

Thread.sleep (implicit wait, hard coded), pauses the execution of the code for the specified time
Implicit wait – if action is not executed within the time frame provided or designated (hard coded time) it will throw an exception – beginning after navigating to a site.
Explicit wait – wait until the expected condition is met. The code will execute when the specified condition is fulfilled, you provide a maximum wait time. More dynamic, allows your test to execute faster
Fluent wait

Question 10

What type of database testing do you normally perform and what is the tool you use?—

Answer 10

Functional test – database is working properly
Relation testing – relationship between tables and columns
Structural testing – structure of tables and columns and data types
Performance – verify the performance of the data base
Oracle SQL developer
SQL – Structured query language
DBMS- Database management system
RDBMS – relational database management system

Question 11

What is the difference between inner join and left join?

Answer 11

Inner- matching info between two tables are retrieved
Left join – all matching values from table1 and table2 and all values from table1 as well
Full outer join – matching values from both tables and their matching values

Question 12

What is a data schema –

Answer 12

relationship between the tables, tells us the primary keys and the foreign keys

Question 13

Are you familiar with the page object model. Can you describe it

Answer 13

POM is primarily a design pattern for structuring UI interactions in test automation

In QA automation, the Page Object Model (POM) represents each web page with a separate class, encapsulating its elements and functionalities for improved test code readability and maintenance.

The Page Object Model (POM) is a design pattern in QA automation where each web page is represented by a separate class. These classes encapsulate the page’s elements and functionalities, enhancing test code readability, reusability, and maintenance.

Automated test design –
Page class (you store the locators and action for those elements into methods related to a pages of the website)
Test class – corresponding test class also related to the pages of the website and your page class where you call the action methods from your page class
Code more reusable, structure, maintainable to change
Data-Driven (apache POI)
Store values in excel and you can call these values into your tests and we can write back into the excel
For large data sets, multiple data sets
Parameterization of data
Hybrid design
A combination of different designs, more free

Question 14

At what part of testing would you integrate automation testing?

Answer 14

Towards the end of my sprint running regression suits and finding possible candidates for automation scripts
And
Use automation in ci/cd pipeline

Question 15

What kind of test would you run manually and others in automation?

Answer 15

Manual: new features and and tests that require human judgement (exploratory testing)
Automation : manual tests that are repetitive
And major functionalities

Question 16

What is jmeter and what kinds of testing is it used for?

Answer 16

JMeter is a Java-based open-source desktop tool used for load, performance, and functional testing of web applications. It helps simulate scenarios and measure performance across web services, databases, and servers.

Performance testing
Load testing
Stress testing
Functional testing

Question 17

What is api testing?

Answer 17

API testing involves verifying the functionality, reliability, performance, and security of application programming interfaces (APIs), ensuring they work as expected, handle data correctly, respond to errors appropriately, perform well, and are secure.(comparing results to expected results)

Question 18

Describe how you use postman to run api test?

Answer 18

In Postman, you create a new request, enter the API endpoint URL, add any necessary headers and request body, then send the request. Postman displays the response, allowing you to verify its correctness and optionally add tests for automated validation

Question 19

What are the advantages of selenium?

Answer 19

Selenium-cross browsing comparability
-open source
-works across different platforms - supports multiple programming languages

Question 20

What are some advantages of maven build?

Answer 20

Maven automates dependency management by downloading and adding necessary libraries for a project, reducing manual effort and ensuring consistent builds across machines.

Question 21

At your current position how many automation test do you run per week?

Answer 21

The number of automation tests run per week varies based on project size, complexity, code changes frequency, test coverage needs. It could range from thousands to fewer tests per week, depending on project specifics and organizational priorities.

Question 22

What are the most common request methods in postman and what do they mean?

Answer 22

GET-retrieve data

POST-submit data

PUT-update data

DELETE-delete data

Question 23

What is the ci/cd pipeline?

Answer 23

CI/CD (Continuous Integration/Continuous Delivery) pipeline is a practice where code changes are automatically built, tested, and deployed to production, ensuring rapid and reliable software delivery.

CI/CD is a methodology we use in software deployment in it we streamline software deployment by automating code integration and delivery, ensuring smooth updates across environments through a pipeline of automated stages, including compilation, testing, and deployment.

Question 24

What’s the difference between verification and validation?

Answer 24

Verify: Ensures that the product meets specified requirements.
Validate: Ensures that the product meets the customer’s needs and expectations.

Question 25

What’s the difference between verification and validation?

Answer 25

Verify: Ensures that the product meets specified requirements.
Validate: Ensures that the product meets the customer’s needs and expectations.

Question 26

As a QA how do you use automation testing in a CICD pipeline

Answer 26

In a CI/CD pipeline, QA integrates automation testing to validate software changes automatically at various stages (e.g., unit, integration, regression tests). This ensures faster feedback on code quality and accelerates the delivery of reliable software.without manual intervention