•5:00 AM
1) What is Database testing ?
Testing the backend databases like comparing the actual results with expected results.
2). What is database testing and what we test in database testing
Data bas testing basically include the following.
1) Data validity testing.
2) Data Integrity testing
3) Performance related to database.
4) Testing of Procedure, triggers and functions.
For doing data validity testing you should be good in SQL queries
For data integrity testing you should know about referential integrity and different constraint.
For performance related things you should have idea about the table structure and design.
For testing Procedure triggers and functions you should be able to understand the same.
1) Data validity testing.
2) Data Integrity testing
3) Performance related to database.
4) Testing of Procedure, triggers and functions.
For doing data validity testing you should be good in SQL queries
For data integrity testing you should know about referential integrity and different constraint.
For performance related things you should have idea about the table structure and design.
For testing Procedure triggers and functions you should be able to understand the same.
3). What we normally check for in the Database Testing?
Database testing involves some in-depth knowledge of the given application and requires more defined plan of approach to test the data. Key issues include:
1) data Integrity
2) data validity
3) data manipulation and updates.
Tester must be aware of the database design concepts and implementation rules
1) data Integrity
2) data validity
3) data manipulation and updates.
Tester must be aware of the database design concepts and implementation rules
4). How to Test database in Manually? Explain with an example
Observing that operations, which are operated on front-end is effected on back-end or not.
The approach is as follows:
While adding a record thru' front-end check back-end that addition of record is effected or not.
So same for delete, update...
Ex: Enter employee record in database thru' front-end and check if the record is added or not to the back-end (manually).
The approach is as follows:
While adding a record thru' front-end check back-end that addition of record is effected or not.
So same for delete, update...
Ex: Enter employee record in database thru' front-end and check if the record is added or not to the back-end (manually).
5). How to test a SQL Query in WinRunner? With out using Database Checkpoints?
By writing scripting procedure in the TCL we can connect to the database and we can test database and queries.
6) .How does you test whether a database in updated when information is entered in the front end?
With database check point only in WinRunner, but in manual we will go to front end using some information. Will get some session names using that session names we search in backend. If that information is correct then we will see query results.
7). What are the different stages involved in Database Testing
In DB testing we need to check for,
1. The field size validation
2. Check constraints.
3. Indexes are done or not (for performance related issues)
4. Stored procedures.
5. The field size defined in the application is matching with that in the db.
8). What SQL statements have you used in Database Testing?
1. The field size validation
2. Check constraints.
3. Indexes are done or not (for performance related issues)
4. Stored procedures.
5. The field size defined in the application is matching with that in the db.
8). What SQL statements have you used in Database Testing?
DDL
DDL is Data Definition Language statements. Some examples: · CREATE · ALTER - · DROP -· TRUNCATE -· COMMENT - · RENAME –
DML
DML is Data Manipulation Language statements. Some examples: · SELECT - · INSERT - · UPDATE - · DELETE - · MERGE - UPSERT -· CALL - · EXPLAIN PLAN - · LOCK TABLE –
DCL
DCL is Data Control Language statements. Some examples: · GRANT - · REVOKE - · COMMIT - · SAVEPOINT - · ROLLBACK - COMMIT -· SET TRANSACTION - This are the Database testing commands.
9). How to use SQL queries in WinRunner/QTP
In QTP Using output database check point and database check point,Select SQL manual queries option And enter the "select" queries to retrieve data in the database and compare the expected and actual.
10). What steps does a tester take in testing Stored Procedures?
In my view, the tester has to go through the requirement, as to why the particular stored procedure is written for? And check whether all the required indexes, joins, updates, deletions are correct comparing with the tables mentions in the Stored Procedure. And also he has to ensure whether the Stored Procedure follows the standard format like comments, updated by, etc.
11). How to check a trigger is fired or not, while doing Database testing?
It can be verified by querying the common audit log where we can able to see the triggers fired.
12). Is an "A fast database retrieval rate" a testable requirement?
13). How to test a DTS package created for data Insert, update and delete? What should be considered in the above case while testing it? What conditions are to be checked if the data is inserted, updated or deleted using a text files?
Most of all, maintain a backup of the previous database.
14). How to test data loading in Data base testing
Using with Query analyzer.
You have to do the following things while you are involving in Data Load testing.
1. You have to know about source data (table(s), columns, data types and Constraints)
2. You have to know about Target data (table(s), columns, data types and Constraints)
3. You have to check the compatibility of Source and Target.
4. You have to Open corresponding DTS package in SQL Enterprise Manager and run the DTS package (If you are using SQL Server).
5. Then you should compare the column's data of Source and Target.
6. You have to check the number to rows of Source and Target.
7. Then you have to update the data in Source and see the change is reflecting in Target or not.
8. You have to check about junk character and Nulls.
15). What is way of writing test cases for database testing?
You have to do the following for writing the database test cases.
1. First of all you have to understand the functional requirement of the application thoroughly.
2. Then you have to find out the back end tables used, joined used between the tables, cursors used (if any), triggers used (if any), stored procedures used (if any), input parameter used and output parameters used for developing that requirement.
3. After knowing all these things you have to write the test cases with different input values for checking all the paths of SP.
One thing writing test cases for backend testing not like functional testing. You have to use white box testing techniques.
40 comments:
Good job...
Mysql Interview Questions and Answers
Very useful collection of question and answers thank you for sharing. PLSQL Online Training
Very good collection of questions thank you for sharing. Know more about Oracle SQL Online Training
Tevida However, it is difficult to find one that is clean, immutable and affordable. Obviously, you can buy Cialis or Viagra for $ 80 per pill, but you need a prescription and a meeting with the doctor. It is also
https://www.supplementsforfitness.com/tevida/
Keto 180 Shark Tank defines personal characteristics of health merchandise.Keto 180 is a 100% pure weight loss product which Ddminishing stored fats and calories from the bodies
Keto Pure Diet - You should study this from start to finish. That is from my own experience with weight loss. Weight loss scares us somewhat. It is actually not duplicatable. Without weight loss, you're fighting a losing battle before you even begin. It's not actually free. Those following the progress of weight loss might have to check out weight loss too. Very few compadres understand this yet that is a considerable gain. I don't like jargon when talking about weight loss. Didn't they note that? Weight loss has made a significant impact.
http://www.wellnesstrials.com/keto-pure-diet/
http://www.wellnesstrials.com/
https://www.pinterest.com/claimwellnesstrials/
https://www.instagram.com/claimwellnesstrials/
http://claimwellnesstrials.over-blog.com/
https://works.bepress.com/wellness-trials2/
Life Nutra Keto - I want to change the topic completely now. It wasn't proper. Weight loss means more buying power. That was the cleanest weight loss I've ever seen. This works for me as weight loss is quite limited at this time. That has been a soothing sound. I do gather this makes a difference if that made sense. Beat this with your weight loss people. Weight loss is real critical. Weight loss includes a plan specifically customized for weight loss. They've been as busy as can be. This is impractical so I hit the bull's eye. I recall when my weight loss was new.
https://www.herbal-heath-review.com/life-nutra-keto/
Supplements Book We have best and natural affiliate & trail offers of health & supplement you can get several benefits with our site.
https://supplementsbook.org/fitwithtea/
https://supplementsbook.org/move-for-joint-cure/
http://getsupplementsbook.over-blog.com/
https://sites.google.com/site/supplementsbookprices/
Dieta Salutares is an best site where you can get detail about health, wellness and beauty products that really helps you to select best products according to your needs. This site also provides you latest supplements that is more helpful to make your life better.
http://dietasalutares.it/
https://www.facebook.com/Dieta-Salutares-582647302249651/
canon printer customer support number
avast technical support phone number
Microsoft Edge Phone Number
Mozilla Firefox Phone number
apple support phone number
norton customer service australia
hp helpline number
brother customer service number
McAfee customer service phone number
outlook contact number
Enzolast : Data is power, they assert,, but you must utilize the Male Enhancement that you simply at gift have. Some would love for that force to now not be out there. I, severely, will experience Testosterone Booster. If you are feeling regarding your Penis Enlargement like that you might begin to look at Testosterone from a full new perspective. These are fables in respect to, Male Health thus we are going to stay with what we have a tendency to know thus that I don't bear in mind making that mistake before.
https://www.supplementmegamart.org/enzolast/
Healthy Gnc is one only Health & Wellness supplement hub in usa. We have natural ingredients supplements with no side effects. we are providing Muscle building , Weight Management , weight
loss and wellness supplements.
http://www.healthygnc.com
Healthy GNC >>>> Healthy Gnc is one only Health & Wellness supplement hub in usa. We have natural ingredients supplements with no side effects. we are providing Muscle building , Weight Management , weight loss and wellness supplements.
For More Information Click Here >>>> http://www.healthygnc.com/
Dragons Den Diet is leading company which sells various health related products.it has a vast range of products like weight loss supplement,male enhancement,muscle related products & skin care.we are offering the best discount in the market and selling best quality products.
For More Information Visit Our Official Website >>> https://www.dragonsdendiet.com/
https://www.dragonsdendiet.com/nitro-strength/
Hello, I read your blog occasionally, and I own a similar one, and I was just wondering if you get a lot of spam remarks? If so how do you stop it, any plugin or anything you can advise? I get so much lately it’s driving me insane, so any assistance is very much appreciated.
Selenium Course Training in Chennai |Best Selenium Training Institute in Chennai
Java Course Training in Chennai | Best Java Training Institute in Chennai
Ultra Fast Keto Boost is a natural weight loss supplement that targets the fat from the root level and provides you a healthy and fit body. With the help of this product, you are going to get the permanent result and desired result. It converts the fat to fuel and keeps you energetic and active all day long. That’s why this product transforms a person under 90 days only. You are going to get the best result and permanent result that makes this product No.1 in the market.
https://twitter.com/martsupplements/status/1169152488488017920
https://www.saatchiart.com/art/Painting-Ultra-Fast-Keto-Boost-Shark-Tank-Reviews-Cost-Weight-Loss-Pills/1320697/6575437/view
http://www.apsense.com/article/ultra-fast-keto-boost-shark-tank-reviews-cost-weight-loss-pills.html
https://www.pinterest.com/pin/855754366678769778
https://www.youtube.com/watch?v=Wtwl19PZuKs&feature=youtu.be
http://fliphtml5.com/elqsi/hfsi/
https://supplementsmegamart.hatenablog.com/entry/Ultra_Fast_Keto_Boost
https://supplementsmegamart.blogspot.com/2019/09/is-ultra-fast-keto-boost-scam-diet.html
Gncgo.cc in Usa We List All Type of Health and Nutra Products Here, Supplement For HGH,Ketosis, Weight Loss, Skin Care, and other Health.
For More Info - https://gncgo.cc/
https://https://gncgo.cc/elite-male-performance/
Web Bitcoin Club is an innovative payment network and a new kind of money. Find all you need to know and get started with Web Bitcoin Club on https://webbitcoinsclub.blogspot.com/. We use cookies to ensure you get the best experience on our website.
https://webbitcoinsclub.blogspot.com/
https://bit.ly/31SlyDs
Hello, I am Abelard From Germany (DE). I want to tell you a interesting game DUNDER CASINO. Its amazing & when you register before play this game. You get Free Spins & $100 also. We believe that the player experience is everything, and an outstanding support team is key. We are human beings, but more importantly casino enthusiasts. If you want to play DUNDER CASINO and earn money then Click Here & Get BONUS % FREE SPINS.
VISIT HERE :https://casinoforgambling.blogspot.com/2019/10/dunder-casino-de.html
https://casinoforgambling.blogspot.com/
https://casinoforgambling.blogspot.com/2019/10/dunder-casino-germany.html
healthonway the construction of toughness and vitality and capability
Nerotenze postscript boosts the virility and animateness.
For fantabulous execution sessions, it delivers a higher range of confidence and psychogenic premiss
Nerotenze controls the premature ejaculations and improves the libido also it helps in etymologizing the insufficient regulate rowdy volume
Cons of Nerotenze
It is not meant for the use of people beneath 18 years of age
Females moldiness abstain the depletion of the postscript
A few points to be remembered patch consuming Nerotenze
yeezy supply
golden goose sneakers
golden goose
supreme hoodie
moncler
goyard handbags
golden goose outlet
golden goose outlet
moncler jackets
golden goose
You made some decent points there. I checked on the internet for more information about the issue and found most individuals will go along with your show views on this site.
Of course, the first choice must be obtained in the game, but this is a very difficult thing. If I were you, I would choose to buy directly on the website, I have been buying at GameMS. I think you can experience this quality website, and you will definitely get a satisfying experience.At https://www.gamems.com/nba-2k20-mt
GameMS is a classic website that has been engaged in virtual game currency trading for decades. They have rich experience and can provide players with high quality and low price products. I found the site through Google search, so you can also find this site by searching for related terms. If you need to buy NBA 2K20 MT, you can also consult in this shop. Of course, you also consider other methods, but this is my recommendation.
https://www.facebook.com/virmaxrynsreviews/
https://www.facebook.com/Virmaxryns/
https://www.facebook.com/Virmaxryn-where-to-buy-104794058028131
https://sites.google.com/view/virmaxrynwheretobuy/
https://sites.google.com/view/virmaxrynmaleenhancementpils/
https://sites.google.com/view/virmaxrynpriceinusa/
http://tinnitus-911.shop/
http://tinnitus-911.shop/tinnitus-911-reviews/
https://www.facebook.com/events/360645844963550/
https://www.facebook.com/events/424196235220072/
https://twitter.com/HealthEveryday7/status/1302504533109534721
https://www.pinterest.com/pin/666392076105355718
https://twitter.com/HealthEveryday7/status/1302505982128340993
http://alphafemmeketo.shop/
http://alphafemmeketo.shop/alpha-femme-keto-genix/
https://healthynutrishop.com/keto-body-trim/
https://www.tripoto.com/trip/keto-body-trim-tone-and-trim-your-body-5fb7751dc853a
https://dribbble.com/warrenthmpson/about
https://community.hpe.com/t5/feedback/https-healthynutrishop-com-keto-body-trim/td-p/7109943#.X7d4DhbhXIU
https://healthynutrishops.blogspot.com/2020/11/keto-body-trim-shark-tank-ketogenic.html
https://www.fromrusttoroadtrip.com/forum/legal-stuff/https-healthynutrishop-com-keto-body-trim
https://www.xfactory.io/forum/she-qun-huo-dong-community-events/https-healthynutrishop-com-keto-body-trim
https://www.whiteowlwings.com/forum/get-started-with-your-forum/https-healthynutrishop-com-keto-body-trim
https://www.d2drace.ie/forum/crew-wanted-available/https-healthynutrishop-com-keto-body-trim
https://healthynutrishop.com/pharmalite-xs-keto/
https://www.fromrusttoroadtrip.com/forum/legal-stuff/pharmalite-xs-keto-how-to-use-and-ingredients-side-effects
https://www.xfactory.io/forum/she-qun-huo-dong-community-events/pharmalite-xs-keto-lose-weight-faster-easier-than-ever-before
https://www.whiteowlwings.com/forum/get-started-with-your-forum/https-healthynutrishop-com-pharmalite-xs-keto
https://healthynutrishop.com/
If you believe it or not, there it is. How inexpensive? Anyhoo, "Goodness is better than beauty." Judging from what top experts say, what I have is a pleasure center about Weight Loss. I couldn't remember this pertaining to boost stamina when I started this column.
https://www.nutrahealthpro.com/
https://www.facebook.com/nutrahealthpro/
https://twitter.com/nutrahealthpro
It's some unacceptable perspective. I presumed I was being deceived by them. One highlight remember is that skin health management isn't in every
case recognizably better. In the event that you are dubious as that worries skin health management, don't face the challenge. Healthy skin got a
doctor's approval from a decent numerous muscle heads. Circles need to quit attempting to make themselves as some kind of revolutionary reformers
of healthy skin. We'll perceive how it functions out. Practically speaking, it is troublesome. Try not to pay attention to that as well. I figure
you discover that data to be important in your journey.
https://www.nutrahealthpro.comhttps:
www.facebook.com/nutrahealthpro
https://twitter.com/nutrahealthpro
https://in.pinterest.com/nutrahealthpro1
They need skin health management to vanish in light of the fact that they sense it will be better for them. That brought huge fulfillment. That is rudimentary. This is the way to create as a specialist. I have wide involvement with healthy skin. This is a radiant open door for someone. By goodness of what do a few ladies grab heavenly healthy skin materials? How about we start our healthy skin experience. I'm content with the job I've played in helping able individuals with understanding skin health management.
https://www.nutrahealthpro.com
https://in.pinterest.com/nutrahealthpro1
https://twitter.com/nutrahealthpro
https://www.facebook.com/nutrahealthpro
Bomb keto Pro
Bomb keto Pro - 100% Special Ingredients for woman formula.This new supplement is intended to work best when dieting follow a ketogenic lifestyle. You'll take the ketogenic diet and create it simple. Stores energy in the body by extracting fat.
https://www.nutrakingdom.com/bombketo-pro/
Bomb keto Pro
Bomb keto Pro - 100% Special Ingredients for woman formula.This new supplement is intended to work best when dieting follow a ketogenic lifestyle. You'll take the ketogenic diet and create it simple. Stores energy in the body by extracting fat.
https://www.nutrakingdom.com/bombketo-pro/
Bomb keto Pro
Bomb keto Pro - 100% Special Ingredients for woman formula.This new supplement is intended to work best when dieting follow a ketogenic lifestyle. You'll take the ketogenic diet and create it simple. Stores energy in the body by extracting fat.
https://www.nutrakingdom.com/bombketo-pro/
https://www.iwebwire.com/ 1st information site. Newspaper articles and all the news continuously: International, Society, Economy, Culture, Environment
we will adapt to wellness. I had partial get admission to (most beginners keep away from the highflying route). are you able to believe it? keep in mind, i'll cross easy on you. we will think that well being isn't always a huge deal. You cannot financial institution on that.
https://www.nutrahealthpro.com/hemp-max-lab-oil/
https://nutrahealthprodiet.blogspot.com/2021/02/hempmaxlaboil.html
https://sites.google.com/view/hempmaxlaboil-review/home
https://www.facebook.com/Hemp-Max-Lab-Oil-110368737763219
https://www.facebook.com/Hemp-Max-Lab-Oil-110368737763219
https://www.pinterest.com/pin/596867756864867010
https://www.instagram.com/p/CLoW78blU-2/
http://vle.ar-raniry.ac.id/eportfolios/13897?view=preview
How can alliances glean transcendent Wellness items? I was then the proud owner of a Wellness. Perhaps you should change your modus operandi. I have flawless data. A spending spree could get that rolling.
This looked like a very good Wellness. There were a few eyewitnesses. These elements are indicative of a market that favors Wellness buyers.
https://twitter.com/nutrahealthpro
https://www.facebook.com/nutrahealthpro
https://in.pinterest.com/nutrahealthpro1
Great Post with valuable info. Thank you for the updates.
Learn Dot NET Online
Dot NET certification course online
Nice article, its very informative content..thanks for sharing...Waiting for the next update.
what is swift language?
Advantages of swift programming language
Infycle Technologies, the best software training institute in Chennai offers the Data Science Certification in Chennai for students, tech professionals, and freshers. Apart from the Data Science Course, other courses such as Python, Cyber Security, Oracle, Java, Hadoop, Selenium, Android, and iOS Development, Big Data will also be trained with 100% hands-on training. After the completion of training, the students will be sent for placement interviews in the core MNC's. Dial 7502633633 to get more info and a free demo.