Answer Posted / mohapatra.gouranga@gmail.com

In RAC env.

select instance_name,status,host_name,to_char
(startup_time,'DD-MON-YY HH24:MI:SS')
from gv$instance order by instance_name;

What is fill factor? : sql server DBA

1232

---

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?

2793

---

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

1053

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1897

---

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.

1981

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1927

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1742

---

Explain about your sql server dba experience? : sql server DBA

1073

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2429

---

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

1009

---

what functionality does oracle provide to secure sensitive information?

979

---

Where would you look for errors from the database engine?

2842

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2096

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2531

---

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

1025

---