Can DASD types assigned to storage groups be intermixed ?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

Can DASD types assigned to storage groups be intermixed ?

Q: Can DASD types assigned to storage groups be intermixed (i. e., 3350s and 3380s?

An:
No

(Continued on next question...)

Other Interview Questions

• What is the syntax required for the creation of a cursor ?
• Can you define an Index if the table size less than 10 PAGES?
• When is the results table for the query in a DECLARE CURSOR statement created ?
• What is a clustering index?
• Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?
• How is a typical DB2 batch program executed?
• What is the maximum number of tables that can be stored on a Partitioned Tables Space?
• What is the COBOL picture clause for a DB2 column defined
• How do you achieve record level locking in DB2 versions when record level locking is not allowed?
• What is a clustering index?
• More...