Answer Posted / arkchowdary

we use Dept table or Any table Insert Command

Insert into dept(Dname,deptno,location.....)values
('Darway',30,'Sweadon');

Or

Insert into dept values('&dname',deptno,'&location'....)

What is control file used for?

1124

---

What is a partition in oracle?

1055

---

How to find the duplicate rows count from employees table in oracle?

1054

---

What is meant by joins? List out the types of joins.

974

---

What are the system predefined user roles?

991

---

What is a tns service name?

958

---

How to invoke the data pump import utility?

1093

---

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

1047

---

How to do paging with oracle?

958

---

How to save query output to a local file?

983

---

What are the restrictions on external table columns?

1007

---

How to use "while" statements in oracle?

1252

---

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

2076

---

Explain what are the uses of rollback segment?

972

---

what is the difference between substr and instr function in oracle?

1049

---