What is materialized view. What are different methods of refresh?

0 Answers  

---

What are the datatypes a available in PL/SQL ?

2 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

What is difference between stored procedures and application procedures?

0 Answers  

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

What do you know by pl/sql cursors?

0 Answers  

---

How much ram can sql express use?

0 Answers  

---