-
How to Test Database Procedures and Triggers?
Swathi
- Sep 24th, 2015
Make a transaction to create entry employee table, where the same row already exists in department table.
Here we will get violation error.Gaurav.khurana
- Aug 25th, 2015
If you put entry in employee table, an entry is created in department table with some values. Now make a transaction such that employee table gets an entry. To verify correctly you can see the body o...
-
-
How do you test whether the database is updated as and when an information are added in the front end?Give me an example?
kurtz182
- Jan 6th, 2010
Depending on the information you are validating, you can check using simple or complex queries in the Query Editor of the SQL Management Studio There are a few things you may wish to c...
vsubraya
- Dec 17th, 2009
1. Enter the required input to complete the transaction or process so that the data or information updated into back end tables.2. Note the Transaction number, or date/time stamp during which you have...
-
What is the difference between functions & procedures?
krishna pal singh
- Aug 28th, 2007
Function always return a values using the return statement but a procedure may or may not return values
-
-
How can we write testcases from Requirements..?Do the Requirements represent exact Functionality of AUT
kurtz182
- Jan 6th, 2010
I think you've got it backwards: The application under test (AUT) must represent the exact requirements. To answer your first question, the requirements are authored by someone in the b...
abhishektuppada
- Oct 15th, 2007
Well I would slightly differ from all the others, As per my knowledge the Test Cases are to be written based on the Business Requirements & not the Use Cases. Writing Test cases based on the Use C...
-
What is join and explain about types of joins?
Rajnish Jha
- Jan 12th, 2012
Join: We can display data from two or more than two table using Join.
There are 4 Types of Join-
1) Natural Join
2) Inner Join
3) Outer Join
4) Cross Join
Outer Join is further divide into two types-
1) Left outer join
2) Right Outer Join
-
Is there any Freeware Tool to do Database Testing, frequently used in I.T. industry
-
What we normally check for in the 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.
goksn
- Sep 7th, 2009
In my experience , I have done the followign test activities as part of databaes application*Data Integrity: Whether relationship between tables (as defined while designing tables) are getting respect...
prasadmeduri
- Feb 4th, 2009
Based on the testcases written for the module, we have to cover the UI testing,Whichever modules we are testing, our main focus should be on database. 1) What are tables affected?2) From where the dat...
-
Identify Social Security Numbers
How will you verify that there are no social security numbers greater than or less than 9 digits long in a table called customer_info?
Write the SQL query that will identify any social security numbers that do not meet this criteria -
What is way of writing testcases for database testing?
mithr17
- Nov 2nd, 2011
Ok lets do this by taking an example. Lets say you are testing the integration between database and a user registration web application. User registration web site becomes your front-end and database...
govind kumar
- Aug 9th, 2011
For writing test cases in Database first one should define the project name, then module,Bug number,objective,steps/action undertaken,expected result,actual result, then status, priority and severity.
-
-
-
-
DataBase Testing Interview Questions
Ans