Interested to Buy Any Domain ? << Click Here >> for more details...
select * from emp
what happened internally when we write this query in the sql
prompt?
- 5 Answers
- 7658 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
What is oracle rowcount?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is ASM (Automatic Storage Management) in Oracle?
Explain the use of record length option in exp command.
How to get maxsal , minsal, ename department wise in single query
Can multiple cursors being opened at the same time?
How to define a sub function?
What is dual table oracle?
What are the different types of failures that occur in Oracle database?
What is index in Oracle?
How to use subqueries with the exists operator in oracle?
How to use values from other tables in update statements using oracle?
In oracle there is column command, how will you explain that?
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
What is PL/SQL ?
