Answer Posted / neha

in nonarchivelog mode the online redo log file are
overwritten each time a log switch occurs.LGWR does not
overwrite an online redo file group until the checkpoint
for that group is completed.ex-operating system crash
causes an instance crash.

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

2042

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1265

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2858

---

Why would you use sql agent? : sql server DBA

1130

---

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

3807

---

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

1056

---

what do you understand by flashback feature of oracle?

1043

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1078

---

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

2778

---

What are the different types of indexes available in sql server? : sql server DBA

1261

---

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

1182

---

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

2491

---

Which autogrowth database setting is good? : sql server DBA

1238

---

when does an alert gets signaled?

1110

---

What are the commands used in dcl? : sql server DBA

1130

---