|
INTERVIEW QUESTIONS
TESTING GLOSSARY
DATABASE TESTING
DETAILS
Question: What SQL statements have you used in Database Testing?
Answer: The most important statement for database testing is the SELECT statement, which returns data rows from one or multiple tables that satisfies a given set of criteria. You may need to use other DML (Data Manipulation Language) statements like INSERT, UPDATE and DELTE to manage your test data. You may also need to use DDL (Data Definition Language) statements like CREATE TABLE, ALTER TABLE, and DROP TABLE to manage your test tables. You may also need to some other commands to view table structures, column definitions, indexes, constraints and store procedures.
|
|
|
Category |
DataBase Testing Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7602 users |
Added on |
3/18/2013 |
Views |
68496 |
Rate it! |
|
|
Question:
What SQL statements have you used in Database Testing?
Answer:
The most important statement for database testing is the SELECT statement, which returns data rows from one or multiple tables that satisfies a given set of criteria. You may need to use other DML (Data Manipulation Language) statements like INSERT, UPDATE and DELTE to manage your test data. You may also need to use DDL (Data Definition Language) statements like CREATE TABLE, ALTER TABLE, and DROP TABLE to manage your test tables. You may also need to some other commands to view table structures, column definitions, indexes, constraints and store procedures. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is database testing and what we test in database testing?
|
View Answer
|
|
How to use SQL queries in WinRunner/QTP
|
View Answer
|
|
What are the different stages involved in Database Testing
|
View Answer
|
|
What steps does a tester take in testing Stored Procedures?
|
View Answer
|
|
How do you test whether the database is updated as and when an information are added in the front end?Give me an example?
|
View Answer
|
|
How do you test whether a database in updated when information is entered in the front end?
|
View Answer
|
|
How to test a SQL Query in Winrunner? without using DataBase CheckPoints?
|
View Answer
|
|
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?
|
View Answer
|
|
How to Test Database Procedures and Triggers?
|
View Answer
|
|
Is a "A fast database retrieval rate" a testable requirement?
|
View Answer
|
|
How to check a trigger is fired or not, while doing database testing?
|
View Answer
|
|
What is data driven test?
|
View Answer
|
|
How to Test database in Manually? Explain with an example.
|
View Answer
|
|
What is Database testing?
|
View Answer
|
|
What we normally check for in the Database Testing?
|
View Answer
|
|
What we normally check for in the Database Testing?
|
View Answer
|
|
How the stored procedure is tested? Please explain with example
|
View Answer
|
|
How the data base testing is been performed in industry? What is retrival rate testing in database testing and how its calculated?.
|
View Answer
|
|
How to integrate the test director with QTP or Win Runner?
|
View Answer
|
|
What we normally check for in the Database Testing?
|
View Answer
|