Answer / barun

Function-1.function used for calculation perpose.it must
return value.(call by pl/sql code block,by sql query)

Procedure-it is used to implement business logic.it may or
not return value.it pre compile and stored in server data
base.so it is faster.(call by pl/sql code block_

trigger-it is used to implement business logic and maintain
intigrity.it cant take any para-meter like fun or
procedure.it is automatically fired(implicitely)

Does inner join remove duplicates?

0 Answers  

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---

What is a sql profiler?

0 Answers  

---

How do I save a stored procedure?

0 Answers  

---

What is the purpose of primary key?

0 Answers  

---

---

What are some predefined exceptions in pl/sql?

0 Answers  

---

What is difference between primary and secondary key?

0 Answers  

---

How can a pl sql block be executed?

0 Answers  

---

What is the use of sql trace?

0 Answers  

---

What is transaction control language (tcl)?

0 Answers  

---

C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

0 Answers  

---

explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  

---