1. Categories >> Software >> Testing >> Manual Testing
  2. Suggest New Category

table X havng 3 column A,B,C....A column havng data 10 20
30.....now i wanna have 1o value in A columns all three rows

Question Posted / navnee

Answers were Sorted based on User's Feedback



table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / navnee

update X

set A=10

where A=20 and A=30

PLZ C0RRCT MY QUERY

Is This Answer Correct ?    10 Yes 2 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / prakash

update x set a=10
where
A!=10

Is This Answer Correct ?    5 Yes 1 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / ravikumar3123

update x set a=10

even this wil do..

Is This Answer Correct ?    5 Yes 2 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / thilaka

SELECT * FROM X WHERE A= 10

Is This Answer Correct ?    6 Yes 4 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / ramthiraviyam

UPDATE 0X SET A=10 where A!=10

Is This Answer Correct ?    0 Yes 0 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / n@n!

hi Ravikumar3123,

where ever ur writting the querie is for update row in a
table.
but the row is already in the table.so,what is the
necessity of using update querie?

the question is finding the low value in the colomn 'A'
so,i think what ever the querie that am written above is
true.
plz check it out.

Is This Answer Correct ?    1 Yes 3 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / n@n!

select * from X where A < 10

Is This Answer Correct ?    0 Yes 10 No

Post New Answer

More Manual Testing Interview Questions

What is the Test Case?What is the Testing?

10 Answers   iSoft, Patni, Verisoft,

what is functionality testing?? what is system testing?? does system testing involves functionality testiting??

5 Answers   FIC,

Hi to group..coule any please let me know the availablitiy of Database Testing Related Stuff?

0 Answers  

What is the difference between windows application and Client server application ?

3 Answers   IBM, MMT,

performance testing is only done for online(website) applications or even offline(desktop) applications

2 Answers  




What is decision table testing?

0 Answers  

If there are so many bugs open and still the client want the s/w what will you do?

2 Answers   TCS,

how to write testcase for this particular textbox.i have textbox and it accepts only values from 1-9.how to write testcases for this using bva and ecp?need some more testcases any sites which provide testcases information? mainly for webapplication.

3 Answers  

Wht is the use of vss (management tool)

3 Answers  

who is preparing PIN document?

1 Answers  

how can u differentiate intgration test cases with functional test cases

4 Answers   TCS,

in an online banking software,users are connecting to bankserver by login.This login module can take below inputs for user. a/c number prefix-3 digits but doesnot start with 0&1 a/c number sufix-6 digits number password-5to 10 chars alphanumerics in lowercase areacode-3 digits number but optional purpose- cheque deposit money trasfer mini statement bills pay After filling above fields,user can click submit button to connect to bank server.prepare test scenarios for online banking s/w login.

0 Answers  

For more Manual Testing Interview Questions Click Here
Categories