What are the advantages of oracle?

0 Answers  

---

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers   Microsoft, Wipro,

---

What is merge statement used for?

0 Answers  

---

How do we represent comments in oracle?

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

What are the restrictions in a oracle read only transaction?

0 Answers  

---

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,

---

What is the difference between a hot backup and a cold backup in oracle?

0 Answers  

---

What is difference between SUBSTR and INSTR?

1 Answers  

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers   iFlex,

---

How to end the current transaction in oracle?

0 Answers  

---