Answer Posted / bolla

At o/s level we are restore control.file from cold/hot backup
after
]$sqlplus /'as sysdba'
sys>startup nomount
sys>recover database using backup controlfile until cancel;
sys>alter database mount;
sys>alter database open resetlogs;

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

2113

---

What is the default fill factor value? : sql server DBA

1126

---

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

1313

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2041

---

What is dcl? : sql server DBA

1268

---

what is the use of recording information about current session?

1053

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2501

---

how can you record information about current session?

1048

---

what functionality does oracle provide to secure sensitive information?

993

---

Explain materialized views and how they are used.

2441

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1076

---

What authentication modes does sql server support? : sql server DBA

1215

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1116

---

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

---

how can you create a user-defined lock?

1017

---