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

1 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

Describe what redo logs are.

1 Answers  

---

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

3 Answers   TCS,

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---