Explain Why A Physical Oid Must Contain More Information Than A Pointer To A Physical Storage Location?

In The Sequential File Organization, Why Is An Overflow Block Used Even If There Is, At The Moment, Only One Overflow Record?

If Possible, Determine The Buffer-management Strategy Used By The Operating System Running On Your Local Computer System, And What Mechanisms It Provides To Control Replacement Of Pages. Discuss How The Control On Replacement That It Provides Would Be Useful For The Implementation Of Database Systems?

Explain Why The Allocation Of Records To Blocks Affects Database-system Performance Significantly?

Give An Example Of A Database Application In Which The Pointer Method Of Representing Variable-length Records Is Preferable To The Reserved-space Method?

Give An Example Of A Database Application In Which The Reserved-space Method Of Representing Variable-length Records Is Preferable To The Pointer Method.

Raid Systems Typically Allow You To Replace Failed Disks Without Stopping Access To The System. Thus, The Data In The Failed Disk Must Be Rebuilt And Written To The Replacement Disk While The System Is In Operation. With Which Of The Raid Levels Is The Amount Of Interference Between The Rebuild And Ongoing Disk Accesses Least?

How Does The Remapping Of Bad Sectors By Disk Controllers Affect Data-retrieval Rates?

List The Physical Storage Media Available On The Computers You Use Routinely. Give The Speed With Which Data Can Be Accessed On Each Medium?

Compare The Use Of Embedded Sql With The Use In Sql Of Functions Defined In A General-purpose Programming Language. Under What Circumstances Would You Use Each Of These Features?