Answer Posted / jeshani

Fact tables and dimension tables.
A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2691

---

What are the steps you will take to improve performance of a poor performing query?

2855

---

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

1033

---

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

2725

---

How do you open a cluster administrator? : sql server DBA

1111

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1738

---

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

1213

---

what is grd?

1103

---

What is the difference between clustered and non-clustered index? : sql server DBA

1094

---

What are statistics, under what circumstances they go out of date, how do you update them?

2257

---

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

1085

---

how can you get actual data change values from previous transactions in oracle?

1094

---

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

1025

---

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

2050

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1765

---