Answer / Anil Singh Dariyal

Stored Procedures are precompiled collections of SQL statements and optional control-of-flow logic that can be executed on demand. They serve several purposes: 1) Encapsulating logic for reuse, improving code organization and maintainability. 2) Improving performance by compiling the procedure once and executing it multiple times instead of parsing and compiling the SQL statements each time they are run. 3) Controlling access to data by defining custom security policies.

What are the key constraints in dbms?

1 Answers  

---

What is dba stand for?

1 Answers  

---

What is primary key in dbms?

1 Answers  

---

What is natural key?

1 Answers  

---

How to drop all foreign keys in database?

1 Answers  

---

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

1 Answers   eBay,

---

What are the properties of a database?

1 Answers  

---

What is the role of database server in database management system?

1 Answers  

---

what are the differences between network and hierarchical database model?

1 Answers  

---

Define cursor.

1 Answers  

---

What are the different types of keys in the database?

1 Answers  

---

What is the use of OWNER option in EXP command ?

1 Answers  

---