Answer Posted / ramakrishnach.dba

oracle searches parameter file in following manner

1) spfile$ORACLE_SID.ora
2) spfile.ora
3) init$ORACLE_SID.ora
4) init.ora

if oracle finds spfile$ORACLE_SID.ora file it ignores rest of the files

What is a system database and what is a user database? : sql server DBA

1116

---

What is replication? : sql server DBA

1102

---

What types of replication are supported in sql server? : sql server DBA

1226

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1945

---

What is the default fill factor value? : sql server DBA

1063

---

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

2521

---

how can you find out if a table can be redefined?

964

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1025

---

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

1113

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1056

---

Why would you call update statistics? : sql server DBA

949

---

How do you trace the traffic hitting a sql server? : sql server DBA

1467

---

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

1923

---

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

988

---

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

1153

---