write testcase for sql table? this is the question asked by interviewer?

write testcase for sql table? this is the question asked by
interviewer?

Question Posted / nagapawan

4 Answers
12185 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write testcase for sql table? this is the question asked by interviewer?..

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

write testcase for sql table? this is the question asked by interviewer?..

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

write testcase for sql table? this is the question asked by interviewer?..

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

write testcase for sql table? this is the question asked by interviewer?..

Answer / narayan

column definitions
data ranges for values
referential integrity - primary / foreign keys

Is This Answer Correct ?

1 Yes

2 No

Post New Answer