Answer Posted / nagarani k

system and sysaux tablespaces are automatically created in
oracle 10gR2 when database created

what is asm?

605

---

What is fill factor? : sql server DBA

642

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

560

---

What is replication? : sql server DBA

622

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3940

---

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2057

---

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

1587

---

when does an alert gets signaled?

578

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1511

---

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

3801

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1743

---

what is a crs resource?

595

---

What the different topologies in which replication can be configured? : sql server DBA

656

---

What is transparent data encryption? : sql server DBA

562

---

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

578

---