How to start SQL Server in minimal configuration mode?

1 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

Explain CREATE DATABASE syntax?

2 Answers  

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

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  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---