How to run create database statement again?
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.
How many memory layers are in the oracle shared pool?
Is it possible to split the print reviewer into more than one region ?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
various types of hints and their usage
What are the types of synonyms?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
How to connect to a local oracle 10g xe server?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What is a Private Synonyms ?
what are views?
Can we create more than one constraint to column ?