DB2 Universal Database V8.1 Certification Exam 700 Study Guide

Working with DB2 UDB Data (31%)

  • Knowledge of transactions

  • Given a DDL SQL statement, knowledge to identify results

  • Given a DML SQL statement, knowledge to identify results

  • Given a DCL SQL statement, knowledge to identify results

  • Ability to use SQL to SELECT data from tables

  • Ability to use SQL to SORT or GROUP data

  • Ability to use SQL to UPDATE, DELETE, or INSERT data

  • Ability to call a procedure

Категории