Answer Posted / amsu

4. No you can't take online backup while database in
NOARCHIVELOG mode.

5. shutdown immediate
startup mount
alter database archivelog;
alter database open;
6. Best way is keep the database in archive log mode.
That will help to recover the database up to last
committed transaction. Oracle recommendation is keep
the database in archive log mode.

what is the use of recording information about current session?

1012

---

how can you implement fine-grained auditing?

1086

---

What authentication modes does sql server support? : sql server DBA

1155

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2150

---

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

2803

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2535

---

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.

1955

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

949

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

943

---

What is the default port no on which sql server listens? : sql server DBA

1103

---

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

2585

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

966

---

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

3715

---

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

7797

---

how can you record information about current session?

999

---