Answer Posted / suman

trace]$ls

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

949

---

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

1231

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1914

---

what is the diffrence between core dba and apps dba?

2510

---

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

1986

---

Query processing is slow(eg select query)how will u solve that

7753

---

how can you process messages in order asynchronously?

930

---

what is the role of dip user in our database?

2363

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2095

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1038

---

Explain materialized views and how they are used.

2381

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1042

---

Which autogrowth database setting is good? : sql server DBA

1054

---

when does an alert gets signaled?

978

---

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

2640

---