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 is dense_rank?

0 Answers  

---

What is synchronized subquery?

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

How to call DDL statements from pl/sql?

5 Answers  

---

What is the difference between partition and index?

0 Answers  

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

Do we need to create index on primary key?

0 Answers  

---

What is partition by in sql?

0 Answers  

---

Does truncate require commit?

0 Answers  

---