What are the ways tablespaces can be managed and how do they
differ?
Answer Posted / kittu
tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed
In dictionary managed tablespace oracle will take care of tablespace
In locally managed tablespace we need to take care of tablespace
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain materialized views and how they are used.
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is grd?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what functionality does oracle provide to secure sensitive information?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
how does an oracle clusterware manage crs resources?
what are the benefits of flashback feature?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What purpose does the model database server? : sql server DBA
what is the use of ocr?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?