Answer Posted / sandeep

select to_char(sysdate,'HH24:MM:SS') from dual;

What is an oracle database?

1043

---

Give the advantages and disadvantages of clusters.

1052

---

Please explain compound trigger in oracle?

1061

---

How to define and use table alias names in oracle?

943

---

Explain the use of owner option in exp command.

1048

---

How to create an oracle database?

1048

---

What is system tablespace?

1100

---

What happens to the indexes if a table is recovered?

993

---

In oracle there is column command, how will you explain that?

1057

---

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.

1424

---

How many types of tables are there in oracle?

1061

---

Point the difference between translate and replace?

1094

---

Explain the function of optimizer in oracle?

1145

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

---

What is proxy method?

976

---