Answer / Rituraj Pandey

We go for stored procedures to improve performance, reduce network traffic, increase code reusability, and enhance security by limiting direct access to sensitive data.

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

---

What is the largest value that can be stored in a byte data field?

1 Answers  

---

Why do we need databases?

1 Answers  

---

How many types of relationship are there?

1 Answers  

---

What is the full form of sql?

1 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What are database links used for?

1 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,

---

Explain the difference between triggers and constraints?

1 Answers  

---

what is index? : Sql dba

1 Answers  

---

How to call a javascript function from pl sql?

1 Answers  

---