How do you add a data file to a tablespace?

3 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

what is ora 600?

1 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---