What is SYSTEM tablespace and When is it Created?
Answers were Sorted based on User's Feedback
Answer / chaudhry
Every ORACLE database contains a tablespace named SYSTEM, which
is automatically created when the database is created. The
SYSTEM tablespace always contains the data dictionary tables
for the entire database.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / nishi
Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is difference between cartesian join & cross join even they give same result?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What are the different types of failures that occur in Oracle database?
candidate key is subset of super key but not vice-verse explain
Explain an extent?
how to handle exceptions in post production
Is insert autocommit in oracle?
Explain the use of file option in exp command.
How to define a sub function?
List the various oracle database objects?
Explain oracle’s system global area (sga).
Can multiple cursors being opened at the same time?