Interested to Buy Any Domain ? << Click Here >> for more details...
Name a tablespace automatically created when you create a
database.
- 3 Answers
- 8861 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
SYS_UNDOTBS and SYSTEM tablespace gets created automatically
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / david
and users tablespace also get create during the installation
of database .....
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / hai hia
1.SYSAUX
2.SYSTEM --- permanent table spaces for system users
3.USERS --- permanent tablespace for non-system users
4.TEMP --- temporary tablespace for all users
5.UNDOTBS --- undo tablespace for all users
...these are the default table spaces created at database creation.
| Is This Answer Correct ? | 0 Yes | 0 No |
How would you go about increasing the buffer cache hit ratio?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What is an Oracle database Partial Backup?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is the disk migration? what is the steps involved in oracle disk migration?
What is the difference between recovery and restoring of the oracle database?
What view would you use to determine free space in a tablespace?
What is difference b/w Credit memo and Adjustment in AR.
You have just compiled a PL/SQL package but got errors, how would you view the errors?
How can you gather statistics on a table?
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
Oracle General 
