Explain the difference between a procedure and a function?

1172

---

What is the difference between $oracle_base and $oracle_home?

1089

---

State and explain the different types of data models?

944

---

What is key preserved table?

1021

---

What is a sub query and what are the different types of subqueries?

1126

---

What are the different pseudo commands? Explain in general?

1080

---

Explain the different normalization forms?

1103

---

State the various uses of dbcc command?

1060

---

What are a collation and state the different types of collation sensitivity?

1171

---

State the difference between a primary key and foreign key?

935

---

What are the different types of trigger and explain its various uses and functions?

1095

---

Explain about functional dependency and its relation with table design?

1010

---

Explain about your project and its relation to the current job position you are applying to?

1011

---

What are privileges and grants?

1067

---

How to display row numbers with the records?

1080

---