software testing genius

Review your Skills on Database Testing-Through Descriptive Questions

Welcome to “Software Testing Genius”. Subscribe to my RSS feed for latest content on Software Testing.

Correct Answers to Objective Type Questions on Database Testing are at the end of this page:

Review your Skills on Database Testing-Through Descriptive Questions

Q.1: How can we unit test our databases?

We can test stored procedures by executing SQL statements one at a time against known results. Then the results can be validated with expected results. This is similar to unit testing.

<<<<<< =================== >>>>>>

Q.2: What are certain points that are to be kept in mind during database testing?

Following four important points need to be kept in mind.

Helvetica, sans-serif">(1) I/O validations and error handling must be done outside of the stored procedures.

(2) Do thorough analysis to design black-box test cases that produce problematic inputs that would break the constraints.

(3) Testing the interaction between SQL and other components like scripts.

(4) Understanding how to use database tools to execute SQL statements can improve our ability to analyze web-based errors like it helps us to determine whether an error is in the stored procedure code, the data itself or in the components outside the database.

<<<<<< =================== >>>>>>

Q.3: What sort of tests may be carried out during database testing?

(1) SQL databases may not be able to accept special characters (like $, @, &) as valid inputs.

(2) Data sent to the database server may be corrupted due to packet losses caused by slow connections.

(3) Proper implementation of database rollback logic. Otherwise, it causes data corruption. Design your test cases to exercise those critical areas.

(4) Check for complete loading of tables in the database.

(5) Check for proper error handling.

(6) Check that your server does not run out of disk space.

<<<<<< =================== >>>>>>

Q.4: What are milestone tests?

Milestone tests are performed prior to each development milestone. They are scheduled according to the milestone plan.

<<<<<< =================== >>>>>>

Q.5: What sort of errors are handled at the client side and at the server side?

Simple errors such as invalid inputs should be handled at the client side. Handling error conditions can be done at the server side.

Many More Articles & Tutorials on Databse Testing

Largest Database of Sample Papers - 1000+ Unique Questions for ISTQB Foundation Exam

ISTQB Foundation Exam - Full Crash Course for Download

ISTQB Advanced CTAL Test Analysts Exam - Full Crash Course for Download

ISTQB Advanced CTAL Test Manager Exam - Full Crash Course for Download

What Successful Testers say about the Quality of this website

If you want to keep track of further articles on Software Testing,
I suggest you to subscribe my
RSS feed

You can also Subscribe by E-mail
and get All New articles delivered directly to your Inbox.

Get your Absolutely Free Copy of Several MS PowerPoint Presentations & E-Books related to ISTQB, HP Load Runner, IBM RFT, HP QTP & QC Certification Exams, prepared by Popular Writers & Trainers, by writing to:

Full Study Material for Popular Certification Exams:

Study Material - HP QTP & QC Certification Exam

Study Material - IBM RFT Certification Exam

Study Material - HP LoadRunner Certification Exams for All Modules

Study Material - ISTQB Certification Exam

Most Popular Topics in Demand:

Practical Roadmap to QTP Certification

Practical Roadmap to CSTE Certification

Consolidated Study Material - Testing & QA

Rehearsal of QTP in 1 Hr. -  Interview Questions

Correct Answers to Objective Type Questions on Database Testing are as under:

Question No.

Correct Answer

Q. 1


Q. 2


Q. 3


Q. 4


Q. 5


Q. 6


Q. 7



Comments :


Leave Your Comments: (*) Marked Fields are Mandatory

You can apply basic formatting to the text

Name *
Email Address *
Speak your mind
sex hikayeleri