Answer Posted / anuram

CREATE OR REPLACE PROCEDURE PROCEDURENAME{(PARAMETERSLIST)}
AUTHID|CURRENT_USER
IS/AS
DECLARATION OF VARIABLES;
BEGIN
STATEMENTS;
EXCEPTION
STATEMENTS;
END PROCEDURENAME;

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2280

---

Explain about normal forms?

1108

---

What are the key features of dbms?

1046

---

Explain the rollup operator?

1143

---

Can an extended stored procedure be called from inside a user-defined function?

1117

---

State the acid rules?

1183

---

How would you design a database for an online site, which would average a million hits a day?

1056

---

What is dbms and its application?

1058

---

How can you log an error to the server event log from a stored procedure?

1175

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4056

---

How you can make a parameterized view?

1071

---

Explain about post-relational databases?

1080

---

fact table and dimension table containg one to many relationship or many to one relastionship

2553

---

What is the physical representation for a many-to-many relationship?

1141

---

Explain about a primary key?

1046

---