select * from emp
what happened internally when we write this query in the sql
prompt?
Answers were Sorted based on User's Feedback
it will display all the records of emp table.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Write a trigger example in oracle?
What is a table in oracle?
How to use select statement to count the number of rows in oracle?
What is the maximum limit on the number of columns in a table?
What is the purpose of save points in oracle database?
what is the difference between data migration and production migration.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is the recommended interval at which to run statspack snapshots, and why?
What are the different approaches used by Optimizer in choosing an execution plan ?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is oracle latest version?