Answer Posted / hemant shrimali (dba)

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

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1764

---

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

1091

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

999

---

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

1216

---

what is a user-defined lock?

1071

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2479

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1021

---

Why would you call update statistics? : sql server DBA

994

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2414

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2554

---

What is transparent data encryption? : sql server DBA

1199

---

How to start SQL Server in minimal configuration mode?

7982

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1979

---

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.

2285

---

Why would you use sql agent? : sql server DBA

1092

---