Answer Posted / cerey27873

Hi everyone,

Recently I completed an Oracle PL/SQL course from igmGuru, and now I'm preparing for upcoming interviews. I’ve gone through a lot of practice questions, but I’d really appreciate some insights from real interview experiences.

Can anyone share the kind of Oracle PL/SQL questions they were asked during their interviews? Also, are there any specific topics or tricky areas I should focus on that interviewers tend to test?

Thanks in advance for your help!

How can we view last record added to a table?

1031

---

Is oracle a relational database?

909

---

What is a data dictionary and how can it be created?

1130

---

Can a formula column be obtained through a select statement ?

2310

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1061

---

what are steps for interface? where is exchange rate defined in which table?

2140

---

How to create a new table in your schema?

1076

---

How to filter out duplications in the returning rows using oracle?

1014

---

How do I connect to oracle?

1025

---

Does oracle charge for java?

1051

---

Explain self joins in oracle?

1007

---

Explain the use of log option in exp command.

1107

---

How would you go about verifying the network name that the local_listener is currently using?

2037

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2287

---

What is a table index?

1086

---