Name a tablespace automatically created when you create a
database.
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 purpose does the model database server? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
how does an oracle clusterware manage crs resources?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
which background process invoke at the time of upgradation tell me???
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is a crs resource?
how can a session indicate its interest in receiving alerts?
what are the types of connection load-balancing?
how can you implement fine-grained auditing?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what are the benefits of flashback feature?