How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

What are different types of functions in sql?

0 Answers  

---

What is not null in sql?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

What is intersect?

1 Answers  

---

How do I view output in sql developer?

0 Answers  

---

What is a relationship and what are they?

0 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

What is the primary key?

0 Answers  

---

Are views faster than queries?

0 Answers  

---