Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Database Logical & Physical Architecture 5

84. How can we plan storage for very large tables?
Limit the number of extents in the table
Separate table from its indexes.
Allocate sufficient temporary storage.

85. How will you estimate the space required by a non-clustered tables?
Calculate the total header size
Calculate the available data space per data block
Calculate the combined column lengths of the average row
Calculate the total average row size.
Calculate the average number rows that can fit in a block
Calculate the number of blocks and bytes required for the table.

After arriving the calculation, add 10 % additional space to calculate the initial extent size for a working table.

86. It is possible to use raw devices as data files and what are the advantages over file system files?
Yes.
The advantages over file system files are that I/O will be improved because Oracle is bye-passing the kernel which writing into disk. Disk corruption will be very less.

87. What is a Control file?
Database's overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control files are advisable.

88. How to implement the multiple control files for an existing database?
Shutdown the database
Copy one of the existing controlfile to new location
Edit Config ora file by adding new control filename
Restart the database.



This post first appeared on Java Interview Questions, please read the originial post: here

Share the post

Database Logical & Physical Architecture 5

×

Subscribe to Java Interview Questions

Get updates delivered right to your inbox!

Thank you for your subscription

×