Answer Posted / hemant shrimali (dba)

alter tablespace T1
add datafile 'c:\xx\T1.dbf' size 4M autoextend off;

What the different types of replication and why are they used? : sql server DBA

1228

---

Can you redefine a table online?

1156

---

What authentication modes does sql server support? : sql server DBA

1265

---

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

2898

---

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

2152

---

how can you process messages in order asynchronously?

1037

---

what is ora 24313?what is the procedure to exclude that error?

2614

---

What is the difference between clustered and non-clustered index? : sql server DBA

1147

---

Which autogrowth database setting is good? : sql server DBA

1242

---

How would you extract DDL of a table without using a GUI tool?

2535

---

what is the diffrence between core dba and apps dba?

2624

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2352

---

What types of replication are supported in sql server? : sql server DBA

1356

---

how can you enable flashback feature?

1010

---

How do you open a cluster administrator? : sql server DBA

1152

---