There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

What are the different dml commands in sql?

0 Answers  

---

Differentiate pl/sql and sql?

0 Answers  

---

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

How can we optimize a sql query?

0 Answers  

---

What are secondary keys?

0 Answers  

---

What are inner outer left and right joins in sql?

0 Answers  

---

How many types of privileges are available in sql?

0 Answers  

---