Answer Posted / suman

we are restore the control file from cold/hot backup
after that
$sqlplus / 'as sysdba'
>startup nomount
>recover database using backup controlfile until cancel;
>alter database mount;
>alter database open resetlogs;

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

2296

---

What are the operating modes in which database mirroring runs? : sql server DBA

1186

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1067

---

Where would you look for errors from the database engine?

2849

---

what do you understand by flashback feature of oracle?

994

---

What is dbcc? : sql server DBA

1283

---

What is the importance of a recovery model? : sql server DBA

1026

---

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

1071

---

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?

1983

---

What is transparent data encryption? : sql server DBA

1193

---

when does an alert gets signaled?

1049

---

how can you find out if a table can be redefined?

1012

---

what is a crs resource?

1166

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2229

---

What are the different sql server versions you have worked on? : sql server DBA

1011

---