Answer Posted / amit bhagat

1). No, online backups is not possible in Noarchive log
mode.
2) Shutdown immediate
Starup mount
alter database archivelog;
alterdatabase open;
3) Database should run in Archivelog mode so that online
backup can be taken.

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

2566

---

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

1024

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1944

---

what is the use of ocr?

964

---

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

1029

---

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

1035

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2365

---

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

987

---

Why would you use sql agent? : sql server DBA

1017

---

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.

1937

---

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

2195

---

how can you find out if a table can be redefined?

962

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4383

---

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

1084

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2405

---