Demand Paging
In my previous post I had discussed about virtual memory. In this post I will discuss how virtual memory can be implemented using demand paging. In demand paging, a page is loadedRead More…
All posts by DreamMaker
Virtual Memory
A virtual memory is a technique that allows the execution of process that may not be completely in memory. One major advantage of this scheme is that programs can be larger thanRead More…
Segmentation
In my previous post, I had discussed about how Paging scheme can be helpful to minimize the amount of fragmentation. In this post I will continue my discussion with segmentation scheme asRead More…
Paging
In my previous post I had discussed about “Fragmentation” and how it can be solve. In this and later post, I will discuss some of the memory allocation techniques that can beRead More…
Index
Some specific steps are perform by the oracle engine each time whenever user access record from the data base table. It will first search for a specific table on the hard diskRead More…
VIEW
A view is a logical entity which is created from the base table. The main purpose of creating a view is to provide security over the database table. In some cases whenRead More…
DUAL TABLE
A dual table is oracle’s in built table. It can be used for arithmetic calculations. We can retrieve data from the dual table but cannot insert the data. It has only singleRead More…
DEFAULT VALUE
Insert statement is used to insert record into the table but we have to specify each value for the column list. There are cases in which some value gets repeated for majorityRead More…
USER CONSTRAINTS
We can use describe command to view logical structure of the table. It displays table structure including column name, data type, size & not null constant. It does not provide information aboutRead More…
Constraint Using ALTER TABLE
In our post “I/O Constraint” and “Business Constraints” we had seen how we can add constraints at the time of table creation using Create table command. If you have not read ourRead More…