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.

How would you determine the time zone under which a database was operating?

2 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1 Answers  

---

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.

1 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

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

0 Answers  

---

what is asm?

1 Answers   Oracle,

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

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?

1 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 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,

---