What type of index should you use on a fact table?

1 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

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

0 Answers  

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---