Top 100+ Tablespace Interview Questions And Answers
Question 1. What Is The Difference Between Dictionary Managed Tablespace And Locally Managed Tablespace?
Answer :
In dictionary controlled tablespace, loose block information is maintained in records dictionary cache there by way of will increase IO. In locally managed tablespace, the equal data is maintained in datafile header itself there by using reducing the IO. Hence LMT is better than DMT.
Question 2. What Is Coalescing And Which Process Will Handle This?
Answer :
Combining unfastened blocks collectively is referred to as coalescing and SMON will manage this best if ASSM is enabled for the tablespace.
Oracle 8i Interview Questions
Question 3. Can We Create Dictionary Managed Tablespace In 10g/11g?
Answer :
Yes, however SYSTEM tablespace additionally have to be dictionary for that.
Question four. Explain Pctfree And Pctused?
Answer :
PCTFREE is the reserved area that is to be utilized by rows for future updates.
PCTUSED is the extent of facts in the block which allows in addition statistics insertion simplest after the level decreases beyond that.
Oracle 8i Tutorial
Question 5. Can We Take System And Sysaux Tablespace Offline?
Answer :
We can take SYSAUX, but now not SYSTEM.
Oracle Interview Questions
Question 6. How To Change The Segment Management Type For An Existing Tablespace?
Answer :
Once described, we cannot change segment space control for any tablespace.
Question 7. A Select Query Is Executing And You Observed Temp Tablespace Is Getting Full. You Added 50gb, But Even That Is Eaten Up. What Is Your Next Action?
Answer :
We need to look what that query is and if required we need to music it.
Oracle DBA Tutorial Oracle DBA Interview Questions
Question eight. What Happens When You Take A Tablespace/datafile Offline Immediate?
Answer :
Any existing transactions might be stopped and datafiles of this tablespace need recoverywhen we cause them to on line.
Question 9. How To Identify Which Datafiles Are Modified Today?
Answer :
By looking at the timestamp of the documents at OS degree.
SQL Database Interview Questions
Question 10. Is It Possible To Reduce The Size Of Datafile?
Answer :
Yes, however facts level should not were crossed the restrict.
SQL Database Tutorial
Question eleven. What Is The New Feature Of 11g Tablespace Management?
Answer :
Encryption of the tablespace.
Oracle 11g Interview Questions
Question 12. What Is Bigfile Tablespace And Its Use?
Answer :
It offers easy managebility for VLDB by means of supplying terabytes length to a unmarried datafile itself.
Oracle 8i Interview Questions
Question thirteen. How Will Do Capacity Planning For Your Production Databases?
Answer :
We will take every sector for normal databases and every week for important and rapid developing databases.
Oracle 11g Tutorial
Question 14. What Is Ora-1555 Error And How To Avoid That?
Answer :
It is photograph too antique errors as a way to occur if statistics is not determined in undo or datafile via a select statement. Increasing undo tablespace length, undo retention time, the usage of retention gurantee clause with DML assertion are the solutions.
Question 15. If A Transaction Is Running And Dba Has Taken Particular Rollback Segment Offline. What Happens To That Transaction?
Answer :
It will start the use of SYSTEM tablespace.
DB2 Using SQL Interview Questions
Question sixteen. How To Convert Dictionary Managed Permanent Tablespace To Temporary Tablespace?
Answer :
It isn't always possible.
DB2 Using SQL Tutorial
Question 17. You Are Trying To Add A Datafile, But Its Not Allowing And Saying You Cannot Add It. What Might Be The Reason?
Answer :
Either MAXDATAFILES controlfile parameter or DB_FILES parameter in pfile may have reached its max price.
SQL Interview Questions
Question 18. What Is Omf? What Are Its Advantages And Disadvantages?
Answer :
It enables in managing documents by using oracle automatically. But naming convention might be the hassle.
Oracle Interview Questions
Question 19. How You Will Get Timezone Of Database?
Answer :
NLS_TIMESTAMP_TZ_FORMAT
Performance Management Tutorial
Question 20. How Will You Find Out The Current Users Who Are Using Temporary Tablespace Segments?
Answer :
By checking in v$tempseg_usage.
MYSQL DBA Interview Questions
Question 21. How To Drop A Datafile Without Dropping A Tablespace?
Answer :
SQL> alter database datafile ‘path’ offline drop;
Question 22. How To Check Scn Of The Database?
Answer :
SQL> pick current_scn from v$database;
Question 23. Can We Make Temporary Tablespace Read Only?
Answer :
Not feasible
RMAN (Recovery Manager) Interview Questions
Question 24. What Is The Relation Between Db_files And Maxdatafiles?
Answer :
Both will specify how many max datafiles may be there within the database.
Oracle DBA Interview Questions
Question 25. When A Tablespace Is Offline, Can We Make It Read Only?
Answer :
Not possible.
