Answer Posted / ram

alter database backup controlfile '\path';
alter database backup controlfile to trace;

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3452

---

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?

2042

---

Why would you use sql agent? : sql server DBA

1131

---

What is dbcc? : sql server DBA

1350

---

What is replication? : sql server DBA

1230

---

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

1060

---

what is asm?

1114

---

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?

2558

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2148

---

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?

2036

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4406

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1048

---

how can a session indicate its interest in receiving alerts?

1095

---

what is a crs resource?

1237

---

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

2093

---