Answer Posted / rashid ansari
shared pool contain data dictionary and library
cache.oracle make a execution plan into sheared pool
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to call a stored function with parameters?
How to bring a tablespace online?
Explain integrity constraint?
What are the different types of record groups in oracle? Explain each of them
Explain the use of record option in exp command.
Explain the use of analyse option in exp command.
Difference between varchar and varchar2 data types?
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.
WHAT IS ecc 6.0
What are the varoius components of physical database structure of oracle database?
How many anonymous blocks can be defined?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What language does oracle use?
How to run queries on external tables?
