Answer Posted / parna

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

When do I need to use a semicolon vs a slash in oracle sql?

1146

---

What is a user account in oracle?

1173

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2038

---

Explain a synonym?

1088

---

What happens to the indexes if a table is recovered?

1046

---

What is bind variable in oracle 11g?

1097

---

Explain the difference between a procedure and a function?

1241

---

How to convert character types to numeric types?

1193

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2150

---

How many types of auditing in Oracle?

1088

---

Where are the settings stored for each instance in oracle?

1154

---

Explain the different normalization forms?

1158

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114

---

What privilege is needed for a user to connect to oracle server?

1034

---

Give the advantages and disadvantages of clusters.

1097

---