Answer Posted / ganeshanmsc

Backup To Flash Drive
=========================
ans:
BACKUP DATABASE test TO DISK = 'I:\backup.bak'WITH INIT

What the different components in replication and what is their use? : sql server DBA

541

---

what do you understand by fine-grained auditing?

634

---

What is replication? : sql server DBA

627

---

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

3312

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2107

---

---

how can you create a user-defined lock?

587

---

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

614

---

which background process invoke at the time of upgradation tell me???

2230

---

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

546

---

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?

2176

---

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

602

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

1730

---

who owns the operating system files created by the utl_file package?

565

---

. 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?

1984

---

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

599

---