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

Is primary key an index?

0 Answers  

Can we call a function containing dml statements in a select query?

0 Answers  

what does myisamchk do? : Sql dba

0 Answers  

What does t sql mean?

0 Answers  

Can dml statements be used in pl/sql?

0 Answers  




Why is sql*loader direct path so fast?

0 Answers  

Does sql view stored data?

0 Answers  

What are the sql versions?

0 Answers  

write a query to delete similar records in different tables with same structure

4 Answers  

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

What is an exception in pl/sql?

0 Answers  

how will u find statistics of a database objects?

2 Answers   iFlex,

For more SQL PLSQL Interview Questions Click Here
Categories