Answer Posted / santo

export/import...attach/detach...DTS....backup/restore!

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?

2981

---

Where would you look for errors from the database engine?

2360

---

What is fill factor? : sql server DBA

658

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2201

---

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

1689

---

---

how can you create a user-defined lock?

594

---

Explain about your sql server dba experience? : sql server DBA

558

---

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

3814

---

how can you communicate with operating system files from oracle?

570

---

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?

1569

---

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

749

---

how can you record information about current session?

505

---

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

1956

---

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

580

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1844

---