HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

0 Answers  

---

How to create index-by table in oracle?

3 Answers  

---

What is the usage of merge statement?

0 Answers  

---

How to set a transaction to be read only in oracle?

0 Answers  

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers   TCS,

---

---

Explain rename?

0 Answers  

---

Difference between join and a subquery?

8 Answers   Base Automation, NMDC,

---

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,

---

What is the implicit cursor in oracle?

0 Answers  

---

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

---

What is private procedure oracle?

0 Answers  

---

Explain the use of rows option in imp command.

0 Answers  

---