Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Which clause of an UPDATE statement allows you to affect
only certain rows of a table?

1. The WHERE clause
2. The SET clause
3. The ROWS AFFECTED clause
4. The ORDER BY clause

Question Posted / suresh

Answers were Sorted based on User's Feedback



Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. ..

Answer / tulsi

1)THE WHERE CLAUSE

Is This Answer Correct ?    21 Yes 1 No

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. ..

Answer / chandrasekar.ramasamy

The where clause

Is This Answer Correct ?    11 Yes 1 No

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. ..

Answer / anup

The WHERE clause

Is This Answer Correct ?    6 Yes 0 No

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. ..

Answer / abinaya

The ORDER BY clause

Is This Answer Correct ?    1 Yes 4 No

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. ..

Answer / jyothi

the SET clause

Is This Answer Correct ?    2 Yes 9 No

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. ..

Answer / vishu

3. The ROWS AFFECTED clause

Is This Answer Correct ?    0 Yes 11 No

Post New Answer

More SQL PLSQL Interview Questions

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

What are actual parameters and formal parameters?

0 Answers  

How does index help in query performance?

0 Answers  

What is the use of desc in sql?

0 Answers  

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,




how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

What are the events on which a database trigger can be based?

0 Answers  

Is sqlite thread safe?

0 Answers  

Describe types of sql statements?

0 Answers  

Why is stored procedure faster than query?

0 Answers  

What is the difference between having clause and where clause?

0 Answers  

What are the types of subqueries?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories