What are three advantages to using sql?

0 Answers  

---

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

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   HCL,

---

Can we use out parameter in function?

4 Answers   Infosys,

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

What is the difference between stored procedure and view?

0 Answers  

---

What is the difference between instead of trigger and after trigger?

0 Answers  

---

What are local and global Indexes and where they are useful.

0 Answers  

---

Describe sql comments?

0 Answers  

---

What is data manipulation language?

0 Answers  

---

How do you respond to dementia behavior?

0 Answers  

---

What does partition by mean in sql?

0 Answers  

---