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 and as keyword in pl sql?

0 Answers  

while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

What is pls_integer in pl sql?

0 Answers  

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,




Is it possible to create startup or shutdown trigger for on-schema?

0 Answers  

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

Can we use out parameter in function?

4 Answers   Infosys,

What is the most restrictive isolation level? : Transact sql

0 Answers  

what is overloading procedure or overloading function ?

3 Answers   Genpact,

How do I view tables in sql developer?

0 Answers  

Which are the different character-manipulation functions in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories