Answer / mohapatra.gouranga@gmail.com

Data Guard Redo Transport Services coordinate the
Log Network Server (LNS);
transmission of redo from the primary database to the
standby database, at the same time the LGWR is processing
redo, a separate Data Guard process called the Log Network
Server (LNS) is reading from the redo buffer in the SGA and
passes redo to Oracle Net Services from transmission to a
standby database, it is possible to direct the redo data to
nine standby databases, you can also use Oracle RAC and
they don't all need to be a RAC setup. The process Remote
File Server (RFS) receives the redo from LNS and writes it
to a sequential file called a standby redo log file (SRL),
the LNS process support two modes synchronous and
asynchronous.

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

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

0 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  

---

How would you force a log switch?

4 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

What are the commands used in dcl? : 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  

---

what are the differences of where and if in SAS?

0 Answers  

---

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

0 Answers  

---