Interested to Buy Any Domain ? << Click Here >> for more details...
Name a tablespace automatically created when you create a
database.
- 5 Answers
- 12370 Views
- I also Faced
- E-Mail Answers
Answer Posted / md azhar alvi
At the time of database creation SYSTEM.DBF AND SYSAUX.DBF tablespaces are created.
SYSTEM.DBF contains the data dictionary views and objects which in owned by sysdba.
in oracle 11g if we are omitting the creation of sysaux.dbf tablespace oracle will automatically create the sysaux.dbf tablespace.
sysaux.dbf contain repository values of oracle tools.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the recovery models for a database? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What the different types of replication and why are they used? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how does an oracle clusterware manage crs resources?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what are the performance views in an oracle rac environment?
how can a session indicate its interest in receiving alerts?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what do you understand by flashback feature of oracle?
who owns the operating system files created by the utl_file package?
how can you communicate with operating system files from oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
