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
- 6 Answers
- 12029 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar.ramasamy
The where clause
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How does index help in query performance?
What is difference between inner join and cross join?
What can you do with pl sql?
How many types of keys are there in sql?
What is the difference between local variables and global variables?
Why is theta join required?
Does oracle roll back the transaction on an error?
Can you have a foreign key without a primary key?
What is an exception in PL/SQL? What are the two types of exceptions?
How is a process of pl/sql compiled?
What is a recursive stored procedure?
Which normal form is best?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Describe sql comments?
What is compound trigger?
