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;

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

---

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

0 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

what is ora 600?

1 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---