Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

Can we perform dml on view?

0 Answers  


How many developers work on postgresql?

0 Answers  


What makes a good primary key?

0 Answers  


How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,


what is the boundary line in varrays?

1 Answers   HCL,


What is acid property in a database?

0 Answers  


What are the string functions in sql?

0 Answers  


When the mutating error will comes? and how it will be resolved?

2 Answers  


Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,


How to use boolean type in select statement?

0 Answers  


Is sql sequential or random?

0 Answers  


What is function and procedure?

0 Answers  


Categories