Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert
Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel
Oracle Interview Questions And Answers
|
Page 23 of 95
It is a measure of well the data cache buffer is handling requests for data. Hit Ratio = (Logical Reads - Physical Reads - Hits Misses)/ Logical Reads. 45. When will be a segment released ? When Segment is dropped. When Shrink (RBS only) When truncated (TRUNCATE used with drop storage option) 46. What are disadvanteges of having raw devices ? We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can use dd command which is less flexible and has limited recoveries. 47. List the factors that can affect the accuracy of the estimations ? The space used transaction entries and deleted records does not become free immediately after completion due to delayed cleanout. Trailling nulls and length bytes are not stored. Inserts of, updates to and deletes of rows as well as columns larger than a single datablock, can cause fragmentation an chained row pieces. DATABASE SECURITY & ADMINISTRATION 48. What is user Account in Oracle database ? An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges. 49. How will you enforce security using stored procedures ? Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure. 50. What are the dictionary tables used to monitor a database spaces ? DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES. 51. What are the responsibilities of a Database Administrator ? |