Interested to Buy Any Domain ? << Click Here >> for more details...
write testcase for sql table? this is the question asked by
interviewer?
- 4 Answers
- 11942 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravi
The Question is not clear.what is write testcase for SQL
table?..for which table...what are the fields in the
table..?Before writting we should be clear about the
requirements...
| Is This Answer Correct ? | 27 Yes | 0 No |
Answer / nag
verify to create the table
verify to create the constraints
verify to create the char, varchar2, number......
verify to insert the data into table
verify to update the data into table
verify to delete the data into table
verify to select the data into table
verify to sort the data into table
.
.
.
.
Nag
9989093551
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / pradyumna
I think the answer will be
1- write the query to create the table.
2-insert the values into the table.
3-retrive the values from that table
If i m wrong then posty the correct answer
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / narayan
column definitions
data ranges for values
referential integrity - primary / foreign keys
| Is This Answer Correct ? | 1 Yes | 2 No |
While doing export to Quality Center it always shows Excel file does not respond???? Please suggest as why it is happening??
Requirement from Market “Alice is talking to Bob. Bob thinks that Alice should talk to Chris for more information. Currently, Bob will pass on the directory number of Chris to Alice; Alice/Bob will disconnect the call and then Alice will initiate a new call to Chris. What we need need, Bob should be able to transfer the call to Chris, without Alice making another call.” Implementation done by Unified CM Development Team When a basic call is connected, a new softkey “Transfer” will be displayed on the IP Phone. User (say, Bob) can press that and dial a target (say, Chris). Bob has two options (1) wait for Chris to answer and then tell Chris about call from Alice and then press “transfer” again to complete transfer (2) press “Transfer” immediately; when Chris answers he will be connected to Alice Please come up with test cases thinking from a user perspective, let’s say from a Bank (there could be users such as receptionists, accountants, managers etc.) – in what all scenarios transfer can happen, any negative scenarios (cases where we don’t get a positive response always). If you think you need an enhancement to the feature, please go ahead and suggest that as well.
Can any one tell me how to write test data. i mean, to test each input, 2 test input(1 for +ve, & other for -ve) are given. so , for example, if i want to write test data for login form, how many test data should i write in test case?
Imagine that hotmail is the application taht ur going 2 test write 10 critical test case to test it ?
Who will take care of test plan and test case?
How does the size of the OPCODE field limit the number of operations? Give an example to support your explanation?
Write the functional test case for opening a user email account on any website(like yahoo rediff,gmail)
Write all test cases for any credit card.
write a testcase for tea cup?
how to write testcase for the output of an program ****0 ***01 **012 *0123 01234
how to write test cases for the Sorting the Group Name, Group Number, Individual Count, Group Count.
write test case for pen cap if it is not present?
Automation Testing 
