select * from emp
what happened internally when we write this query in the sql
prompt?
Answer Posted / purna
ALL DATA R STORED IN D PHYSICAL LAYER .....WHEN WE WRITE A QUARY D DATA WILL COM FROM PHYSICAL LAYER 2 SGA (SYSTEM GLOBAL AREA) THROUGH SQL*PLUS LOGICAL LAYER AND GIVES D OUTUT IN D VIEW LAYER
PHYSICAL LAYER...>SQL*PLUS LOGICAL LAYER...>SGA...>VIEW LAYER
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain oracle insert into command?
What is proxy method?
6. Display the client name and order date for all orders using the traditional method.
Is java required for oracle client?
Explain what are clusters?
List the parts of a database trigger.
What operating systems are supported by oracle database 10g xe?
What is meant by joins?
How can we create the complete backup of data in the oracle.
What is the meaning of recursive hints in oracle?
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 can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Differentiate between post-database commit and post-form commit?
What are the set operators union, union all, minus & intersect meant to do?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?