ALL DATA R STORED IN D PHYSICAL LAYER .....WHEN WE WRITE A QUARY D DATA WIL

select * from emp
what happened internally when we write this query in the sql
prompt?

Question Posted / purna

5 Answers
7437 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are the attributes that are found in a cursor?

1011

How to see the table columns used in an index?

958

What is object data modeling?

904

What is an oracle user role?

937

How do we get field detail of a table?

1020

What do you understand by database schema and what does it hold?

1177

How to convert dates to characters in oracle?

983

what is the difference between functional dependecy and multilevel dependency?

2420

How to install oracle database 10g xe?

965

What do you know about normalization? Explain in detail?

879

What are the uses of linked server and explain it in detail?

1001

What is a initialization parameter file in oracle?

987

how to do daily transactions with out sql* loader control file regesterd in apps?

1626

What are the execution control statements in oracle?

1024

How to export data with a field delimiter?

970