Answer Posted / nishi

yes

How can windows applications connect to oracle servers?

1115

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1833

---

What is oracle rowcount?

1145

---

What is the difference between alert log file and tarce file ?

2229

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176

---

What is the max number of columns in an oracle table?

1047

---

What is ASM (Automatic Storage Management) in Oracle?

1244

---

Which is better Oracle or MS SQL? Why?

6483

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

---

What happens if the update subquery returns multiple rows?

1169

---

How to experiment a data lock in oracle?

1111

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1235

---

State the difference between a primary key and foreign key?

996

---

Explain the use of indexes option in exp command.

1210

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2118

---