Answer Posted / monal

BLOCKING MEANS ONE PROCESS HAS LOCKS ON ONE OR MORE RECORDS
AND ANOTHER PROCESS TRIES TO ACQUIRE LOCK ON THE SAME SET OF
ROWS. SO BASICALLY SECOND PROCESS HAS TO WAIT TILL FIRST
PROCESS FINISH WORKING ON THE RECORDS AND THEN SECOND
PROCESS CAN TAKE OVER AND FINISH IT'S TASK. BLOCKING IS
DIFFERENT THEN DEADLOCK. BLOCKING CAN LAST LONGER AS IT IS
NOT AUTOMATICALLY STOPPED BY SQL SERVER LIKE DEADLOCK.

HERE'S GOOD SITE WHERE YOU CAN FIND INFO ABT BLOCKING.
http://www.builderau.com.au/program/sqlserver/soa/Find-blocking-processes-using-recursion-in-SQL-Server-2005/0,339028455,339286600,00.htm

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

1109

---

Explain materialized views and how they are used.

2410

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1938

---

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

7805

---

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

2426

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2292

---

what is ora 24313?what is the procedure to exclude that error?

2528

---

what functionality does oracle provide to secure sensitive information?

962

---

what is the role of dip user in our database?

2377

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2380

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2473

---

What purpose does the model database server? : sql server DBA

1124

---

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

2317

---

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

990

---

What is replication? : sql server DBA

1118

---