Answer / swapna

stored procedures are subprogrammes stored in the database
and can be called & execute multiple times where in an
application procedure is the one being used for a
particular application same is the way for function.

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

How do you take the union of two tables in sql?

0 Answers  

---

What do you mean by query optimization?

0 Answers  

---

What are the advantages of sql? Explain

0 Answers  

---

what is meant by tuning and tk proof?

2 Answers  

---

Can you alter start with clause?

1 Answers   TCS,

---

How many types of privileges are available in sql?

0 Answers  

---

What company owns postgresql?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What is the maximum size of sqlite database?

0 Answers  

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---