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

What are the Restrictions on Cursor Variables?

2 Answers  

Differentiate between pl/sql and sql?

0 Answers  

What are the differences between implicit and explicit cursors?

0 Answers  

Can a view be mutating? If yes, then how?

0 Answers  

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  




How is data stored in sql?

0 Answers  

using comand prompt how can import table data and table space with example

2 Answers  

what is the difference between trigger and constraint?

3 Answers   HSBC,

What do you think about pl/sql?

0 Answers  

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

Describe different types of general function used in sql?

0 Answers  

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories