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 / vishu

3. The ROWS AFFECTED clause

Is This Answer Correct ?    0 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is procedure function?

710


How do you drop a trigger?

711


what is the bond code in materialized view?

2683


What is error ora-12154: tns:could not resolve the connect identifier specified?

826


Is json a nosql?

723






What is pivot query?

830


What are expressions?

757


What is natural join in sql?

710


What is memory optimized?

750


What does closing a cursor do?

985


How do I count records in sql?

731


Can we create clustered index without primary key?

710


What is the use of partition by in sql?

718


What is the purpose of my sql?

684


What is meant by <> in sql?

693