Answer Posted / kittu_chintu2005

Method 1:
SQL>STARTUP NOMOUNT;
SQL>CREATE CONTROLFILE REUSE DATABASE "DB_NAME" ARCHIVELOG RESETLOGS
LOGFILE
GROUP 1 ( 'location of redo1a.log','location of redo1b.log') size XXmb,
GROUP 2 ( 'location of redo2a.log','location of redo2b.log') size xxmb
DATAFILE
'location of system.dbf',
'location of users.dbf',
'location of temp.dbf',
'location of ts1.dbf';
SQL>RECOVER DATABASE;
SQL>ALTER DATABASE OPEN RESETLOGS;

What the different topologies in which replication can be configured? : sql server DBA

1179

---

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.

1936

---

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

1035

---

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

---

how can you connect from 10g user to 11g user??

2062

---

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

2365

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1021

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1039

---

Explain materialized views and how they are used.

2381

---

what is asm?

994

---

How do you open a cluster administrator? : sql server DBA

1032

---

How can you control the amount of free space in your index pages? : sql server DBA

1232

---

How do you trace the traffic hitting a sql server? : sql server DBA

1464

---

Which autogrowth database setting is good? : sql server DBA

1058

---

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

2226

---