Answer Posted / siva kishore

Def:- Stored Procedure is a set of pre-compiled sql statements.

Advantages:
* No need to compile the sql queries again n again when
using frequently.

* Increases execution performance and also reduces the
burden on the database connection.

What is odm database?

942

---

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1685

---

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1926

---

What is the advantage of varchar2 over char?

1211

---

What do you mean by foreign key and primary key?

999

---

List some advantages of dbms.

1085

---

Give the syntax of exception handling used in DBMS?

1142

---

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

1170

---

Explain normalization in one line?

1038

---

Difference between sql and mysql?

2039

---

What the various ways to tune a teradata query

3203

---

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

1064

---

What is difference between clustered, non-clustered and unique index?

1029

---

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

2380

---

What are different types of blocks used in stored procedure?

1062

---