Answer / hemant shrimali (dba)

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

Answer / vinoth kumar

alter tablespace <tablespacename> add datafile 'u01
\oradata\db\test01.dbf' size 10m autoextend on next 5m
maxsize 50m

in prodution database autoextend off is to be avoid.

Answer / suman

alter database tablespace ts1 add datafile
'/u01/oradata/directory name/ts1.dbf' size 5m autoextend on;

what is a user-defined lock?

0 Answers   Oracle,

---

What does coalescing a tablespace do?

1 Answers  

---

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.

0 Answers   Infosys,

---

what r the types of backup?

5 Answers   CSC,

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

What is dbcc? : sql server DBA

0 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

what is meant by gateway

1 Answers   IBM,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---