DB2 5.x DBA Assessment
$27.37
DB2 5.x DBA Assessment
$27.37
Skills Assessment
| Total Questions | 60 |
| Question Types | Multiple Choice |
| Competencies Tested | Vocabulary Problem Resolution SQL DB2 Internals DB2 Performance Utilities and Commands |
| Tasks Tested | EXPLAIN Feature Joins Data Access Embedded SQL UNION Clause Search Criteria Referential Constraints Debugging SQL OCCURS Clause Convert Number to String Correlated Subqueries Data Modification with Cursors Consolidating Data STRIP Function SELECT Cursors Determine Number of Rows Stored Procedures DB2 Data Structures Identify SQL Technique Identify Structure LENGTH Function Cartesian Product Data Modification in Embedded SQL DATE Function SQL Techniques Operator Retrieve all Rows OPEN Cursors Identify Code VALUE Function GROUP BY and HAVING Arranging Data Control and Administration BIND Parameters Number of Locks DASD Volumes Lock Management Physical Storage DBAS Lock Acquisition Failure Locking Strategy Components Valid Lock Types WITH UR Clause Tablespace Lock Most Valuable Trace Writing Traces Analysis Specific Trace Types Tune Database Designs Trace Types DB2 Utilities Miscellaneous Utilities Backup Utilities CHECK DATA Utility Data Consistency Catalog Manipulation Reset Check Pending Data Organization |