How many memory layers are in the shared pool?
Answer / md mubeen
Shared pool buffers cache consists of two layer
1)Library cache (LC) 2) Data dictionary cache (DDC)
in the Library cache the parsed information data will be
stored 2)DDC contains the dictionary tables which stores
the meta data information .
| Is This Answer Correct ? | 2 Yes | 0 No |
How to delete a column in an existing table in oracle?
What are the arithmetic operations?
what is foreign key?
How to build data dictionary view an new database?
How can you merge two tables in oracle?
What is a tns service name?
Can a View based on another View ?
Explain the use of show option in imp command.
How do I connect to oracle database?
Will you be able to store pictures in the database?explain.
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));