Answer Posted / ramesh

System Tablespace is Created when a New oracle Database is
created.
It,s Not-> while Creation of Tablespace
However ,Ensure No user objects created in System Tablespace

Cheers,
Ramesh

What are the different ways you can create databases in sql server? : sql server DBA

1146

---

who owns the operating system files created by the utl_file package?

1087

---

Why does Oracle not permit the use of PCTUSED with indexes?

2951

---

which background process invoke at the time of upgradation tell me???

2739

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2471

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2632

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2057

---

What would you do with an "in-doubt" distributed transaction?

1897

---

What is the default port no on which sql server listens? : sql server DBA

1169

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4358

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1054

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1091

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1218

---

what do you understand by fine-grained auditing?

1065

---

how can you record information about current session?

1059

---