Answer Posted / m.madhusudan reddy

1. listener.ora
2. tnsnames.ora

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

1108

---

what is asm?

1111

---

What is dbcc? : sql server DBA

1347

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1251

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2216

---

how can you record information about current session?

1100

---

internal architecture

2250

---

how can you process messages in order asynchronously?

1034

---

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

4404

---

How would you go about verifying the network name that the local_listener is currently using?

3271

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2150

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2390

---

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

2091

---

What are the different ways you can create databases in sql server? : sql server DBA

1191

---

what do you understand by flashback feature of oracle?

1043

---