How can one determine the status of a tablespace

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How can one determine the status of a tablespace?

By using the DISPLAY DATABASE command.

Other Job Interview Questions

• When does the SQL statement gets executed when you use cursor in the application programming ?
• How do you declare a host variable ...
• How many buffer pools are there in DB2?
• Explain transactions, commits and rollbacks in DB2?
• What can the Locate option of the Repair Utility accomplish?
• What is the FREE command?
• How are write I/Os from the buffer pool executed
• What are foreign keys?
• What are some SQL aggregates and other built-in functions?
• What is deadlock?
• More...