Answer Posted / kranthi

Permanent tablespace is used to store permanent objects etc
temporary tablespace is used for sorting

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1077

---

Where would you look for errors from the database engine?

2897

---

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.

2215

---

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

2163

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2024

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2211

---

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

1056

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1090

---

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

1045

---

What are the steps you will take to improve performance of a poor performing query?

2896

---

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

---

what is the diffrence between core dba and apps dba?

2624

---

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?

2551

---

how can you create a user-defined lock?

1055

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1264

---