Database Testing Practice Exam

About Database Testing
The database can be considered the heart of any software application, so making sure that it is functioning correctly is essential. Database testing is the process of checking that everything is in order with regards to the database. This is done under a controlled testing environment. The process is also known as back-end testing or data testing.

Database testing involves checking things such as the schema, tables, or triggers. The process also checks data integrity and consistency. To do this, complex queries are created to load or stress test the database. Doing this helps to test the responsiveness of the system, and how well it can stand up to different scenarios.

Database testing is a layered process, as the testing usually covers several different areas. When doing a complete database test, you need to test the user interface layer, the business layer, the data access layer, and the database itself.

Why is Database Testing important?
The key focus of database testing is to make sure that the values and information stored in the database are accurate. The database test will then help to see if each query works as it should with regards to its specifications.

Without proper database testing, an application may have hidden faults. When using the software, this could mean that data is lost, not created, or incorrectly stored.

Database testing also helps to ease the complexity of calls to the backend. It also works to make sure that no harmful or incorrect data is being stored at the backend of the application.

Who should take the Database Testing Exam?
•    Database administrators, DB designers
•    Software testing or QA professionals
•    Anyone who wants to assess their software testing skills
•    Software testing or QA managers and senior executives
•    Professionals working in outsourced companies responsible for software testing or QA
•    Software testing or QA consultants
•    Students

Knowledge and Skills required for the Database Testing Practice Exam

Analytical bent of mind, quick learning and communication skills helps candidate to gain success in database testing career.

Database Testing Practice Exam Objective

Database Testing exam focuses on assessing your skills and knowledge in software testing, database systems and software test management.

Database Testing Practice Exam Pre-requisite

There are no prerequisites for the Database Testing exam.

Database Testing Certification Course Outline

1. Software Testing Basics
1.1 Scope
1.2 Functional vs. Non-Functional testing
1.3 Defects and failures
1.4 Finding faults early
1.5 Compatibility
1.6 Input combinations and preconditions
1.7 Static vs. dynamic testing
1.8 Software verification and validation
1.9 The software testing team
1.10 Software quality assurance (SQA)
1.11 Testing Methods - The box approach

2. The Testing Process
2.1 Traditional CMMI or waterfall development model
2.2 Capability Maturity Model Integration
2.3 Waterfall model
2.4 Agile or Extreme development model

3. Automated testing
3.1 Code-driven testing
3.2 Graphical User Interface (GUI) testing
3.3 What to test
3.4 Framework approach in automation
3.5 Defining boundaries between automation framework and a testing tool
3.6 Testing tools
3.7 Measurement in software testing

4. Testing Artifacts
4.1 Test plan
4.2 Traceability matrix
4.3 Test case
4.4 Test script
4.5 Test suite
4.6 Test data
4.7 Test harness

5. RDBMS Basics
5.1 Creating tables with SQL
5.2 Table design principles
5.3 Update, insertion, and deletion anomalies
5.4 Reading an ERD

6. SQL Basics
6.1 SQL Select, Insert, Update, Delete
6.2 Data health by using Aggregation
6.3 Joins
6.4 Foreign Key
6.5 Sub-queries
6.6 Generating Test Data
6.7 Views
6.8 Indices

7. Database Testing
7.1 Testing Scalable Architectures
7.2 Transaction Process Monitor (TPM)
7.3 Database Integrity

8. Database Security
8.1 SQL Injection Vulnerability
8.2 SQL code vulnerabilities

Exam Format and Information
Certification name – Database Testing Certification
Exam duration – 60 minutes
Exam type - Multiple Choice Questions
Eligibility / pre-requisite - None
Exam language - English
Exam format - Online
Passing score - 25
Exam Fees  - INR 1199