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

Answer Posted / anup

The WHERE clause

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of %rowtype?

537


Is sqlexception checked or unchecked?

541


How does join work in sql?

556


what is union? : Sql dba

586


What is equi join in sql?

613






hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1529


which tcp/ip port does sql server run on? : Sql dba

519


Can we create foreign key without primary key?

536


Is sql a backend?

551


what is dbms? : Sql dba

545


How can a pl sql block be executed?

531


What is a null value?

659


What are synonyms in sql?

535


What is data type in database?

548


What is rollback?

586