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
7604 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

How to save query output to a local file?

1004

what is port in oracle? how is it related to database application.

1925

How to create a new table in your schema?

1066

How to start an oracle instance?

1005

How to turn on or off recycle bin for the session?

1084

What is the difference between count (*), count (expression), count (distinct expression)?

989

How to change user password in oracle?

1005

How to invoke the data pump export utility?

1162

Why does oracle 9i treat an empty string as null?

1034

What happens to the indexes if a table is recovered?

971

How do we display rows from the table without duplicates?

955

How to rename a tablespace in oracle?

1071

What is a trigger and what are its types?

1198

What is transport network substrate (tns) in oracle?

1031

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2317