|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 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 Latest Answer : As I know In database Testing We generally check CURD FunctionC-CreateU-UpdateR-RetriveD-DeleteThis is the core functionality of Database .That we need to checkThanksAmit ... Latest Answer : Join is basically used to join tables by means of primary key and foreign key. After joining tables, we can retrive data from multiple tables by firing single query. Join are of various types.a) equi joinb) cartesion productc) outer join ... Read Answers (10) | Asked by : Mukul Latest Answer : The concept is simple.Let us take the example of a trigger, say, an update trigger for the employee table.Now, the logic here is, let's say when a row is modified(for eg, Emp name is being changed), that information needs to be emailed to a person.We ... How to check for correct stored procedures and how to check if the triggers are fired or not in Db testing? Latest Answer : Step 1 ) First we should know what the trigger is doing,this we discuss with development team or else tester should be able to know it with knowledge of tables or by reading the trigger in the database.Step 2) e.g say on inserting a record ,in table 1 ... How a trigger can help in improving performance? How many types of triggers are there and What do they do? Read Answers (2) | Asked by : prasad.gandra
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
