Interested to Buy Any Domain ? << Click Here >> for more details...
What are the ways tablespaces can be managed and how do they
differ?
- 2 Answers
- 6657 Views
- IBM, I also Faced
- E-Mail Answers
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
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Can you redefine a table online?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is a correlated sub-query? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is a crs resource?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you process messages in order asynchronously?
how to restore files with rman?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
how can a session indicate its interest in receiving alerts?
What is transparent data encryption? : sql server DBA
what is the role of dip user in our database?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
