table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna h

Categories >> Software >> Testing >> Manual Testing
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

7 Answers
10797 Views
Hewitt, I also Faced
E-Mail Answers

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

Explain test metric and the information it provides.

0 Answers

Hi frnds im mini. can any one give correct answers for this interview questions. i have an interview in 4days..pls 1.What are tests that u have participated in Testing. 2.What is diff between Load testing Stress testing? 3.What is sanity testing when do u start it? 4.how can you test ur application with negative testing? 5.when can u start test case writng? 6.what is the tool your are using and the version? 7.what is the tool you used to report the bug ? 8.what is a formate of test case document in your company and also bug report document formate? pls send me reply.. tank u frnds.............

1 Answers

what is change request, and how to manage the changes..

1 Answers

How to do integration testing on duster......

0 Answers

What is industry standard for code coverage numbers?

1 Answers

Condition testing is a control structure testing technique where the criteria used to design test cases is that they Option 1 Rely on basis path testing Option 2 Exercise the logical conditions in a program module Option 3 Select test paths based on the locations and uses of variables Option 4 Focus on testing the validity of loop constructs

1 Answers

what are the 3 test tool categories and describe what each can do.

0 Answers

Tell the procedure to close word file?

4 Answers

Hi, what is tier1.tier2.tier3 company.

5 Answers

Any one please tell the adhoc testcases for Gmail application?

1 Answers

Define Non-functional testing?

2 Answers Crea,

could u please suggest good coaching center in hyderabad to learn testing for a fresher

21 Answers

For more Manual Testing Interview Questions Click Here