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 |
Explain how are indexes update?
Is a rollback possible to any savepoint?
1.display list of all users from ur data base.what is the query?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
What is a cluster?
What are the factors causing the reparsing of SQL statements in SGA?
How do I start tns listener?
What is the difference between substr and instr?
How to define a procedure inside another procedure?
Can we store pictures in the database and if so, how it can be done?
what is null value?