What are the types of optimization?

0 Answers  

---

What is synchronized subquery?

0 Answers  

---

How can I speed up sql query?

0 Answers  

---

What does trigger mean in slang?

0 Answers  

---

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

What is a primary key example?

0 Answers  

---

define data blocks ? : Sql dba

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

Differentiate between syntax and runtime errors.

0 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---