Answer Posted / m.madhusudan reddy

1. listener.ora
2. tnsnames.ora

Explain materialized views and how they are used.

2437

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2036

---

What is the importance of a recovery model? : sql server DBA

1022

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2713

---

How can you control the amount of free space in your index pages? : sql server DBA

1304

---

What is dcl? : sql server DBA

1260

---

What is fill factor? : sql server DBA

1243

---

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

2628

---

how can you implement fine-grained auditing?

1127

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2100

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

996

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2435

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

987

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2356

---

What are the different types of indexes available in sql server? : sql server DBA

1192

---