Oracle Memory Management Interview Questions
How does the System table space work?
What is the purpose of ROWS option in IMP command?
Why is Inctype option important in EXP Command?
Explain the function of Record Length optionn in exp command.
Explain the function of Tables option in exp command.
What is the function of INDEXES option in IMP command?
How does the grant option in imp command help?
How does the ignore option in imp command help?
What is the function of Analyse optioin in exp command?
How is Parfile option important to us in exp command?
What for do we have Record option in EXP Command?
Explain the function of owner option in exp command.
Explain the function of Full option in exp command
What is SHOW option used for?
For what purpose is File option used in imp comand?
What for do we use LOG option in exp command?
Why is Consistent option important in exp command?
Explain the function of Constraints option used in exp command.
Explain the function of Rows option used in EXP Command.
Explain the function of Indexes option used in exp command.
Describe the purpose of Compress Option used in Exp Command.
Describe the purpose of File option used in EXP Command.
Explain the various types of export backups.
Describe cold backup.
Various elements of cold backup.
What do you understand by logical backup?
Explain the function of Grant option used in EXP COmmand.
How do we take hot backup?
Explain the various ways of backing up oracle database.
How can we increase or decrease accuracy of estimations?
Various demerits of raw devices.
How is disk shadowing and mirroring useful to us?
Explain the process of Redo log file mirroring. How is it done?
Method for implementation of multiple control files for a database.
What do you mean by control file?
The right moment to release a segment.
What do you mean by hit ratio?
Describe a Rollback segment entry.
How is Rollback segment useful in database?
Can we have a raw device as data files?
How can we determine the space needed by a non clustered table?
Storage space required for large tables.
How are various rollback segments built in a database?
What do you mean by a data segment?
Various causes of reparsing SQL statements in SGA.
Why do we use Database buffers?
Describe the Dictionary cache.
What do you mean by Recursive hints?
How can we identify rollback segment status?
How can we find space allocation?
Why doesn’t a query succeed sometimes?
How do we allocate space within rollback segments?
What is the process of swapping objects into another table space for a current database?
Explain OFA of Oracla database. Describe Optional Flexible Architecture.
How can we make the database use any rollback segment?
Difference between SGA in ver 6.0 and 7.0
How is the performance of estima affected.
How is a space allocation table created in a block?
Describe the benefits of PCTFREE Parameter.
What is use of System table space?
What is the functionality of Optimal parameter?
Describe free extent.
Question regarding management of free extents in ver 6.0 and 7.0
How can we decrease the number of rows per block in storage clause?
Importance of a storage clause.
Define the Program Global Area or PGA.
Features of shared SQL pool
Various Memory Management Interview Questions and Practice Test Questions for Oracle Database Administrator Job Exams.