What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

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

0 Answers  

---

What is dbcc? : sql server DBA

0 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

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

0 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

Describe what redo logs are.

1 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---