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
Why would you use sql agent? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what are the types of connection load-balancing?
What is the difference between clustered and non-clustered index? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
what is the diffrence between core dba and apps dba?
Which autogrowth database setting is good? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you create a user-defined lock?
what is grd?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?