Answer Posted / sumit singh

Satish sir and krishna reddy sir in Naresh Technology...

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.

1425

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4523

---

How to use "for" statements in oracle?

1076

---

What are a query and state the different types of queries and their uses?

1019

---

How to delete multiple rows from a table in oracle?

1064

---

What language does oracle use?

1109

---

what is the scenario where you take the database to NoArchivelog mode?

2332

---

How to upsert (update or insert into a table)?

1005

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2129

---

What privilege is needed for a user to delete rows from tables in another schema?

1070

---

What is bulk copy or bcp in oracle?

1124

---

 What are the oracle DML commands possible through an update strategy?

1066

---

How to define a record variable to store a table row?

1059

---

Explain the use of indexes option in imp command.

1182

---

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

2104

---