IBM DB2 11.1 Assessment
$16.00
IBM DB2 11.1 Assessment
$16.00
| Number of questions | 54 |
| Competencies tested | DB2 using SQL Databases and Database Objects DB2 Data types Concurrency Security Database Administration and Design |
| Tasks tested | Nested Queries in DB2 Expression-Based Index Updating Data into Table Foreign Key Constraint FULL OUTER JOIN List of Tables Containing Specified Column Compiling DB2 Stored Procedures Exporting Data in DB2 Conditional Updating Data for Multiple Rows into Table DB2 SQL Joins Create tables using extended row size feature Reorganizing Tables Order of Precedence Table Structure Definition Commit, Rollback and Savepoint in DB2 SQL Clauses Modifying the Size of Column Fetch First 10 Rows Creating DB2 Stored Procedures Create a User-Defined Module Global Variable DMS vs SMS Table Spaces Table Views Database Object Creation Available Database Directories Creating Database Default Bufferpool Size Listing DB2 Indexes Viewing Tables in Schema Clustered Tables in DB2 Initialize DB2 Command Line Environment Default Tablespace in DB2 DB2 Triggers Connecting to a DB2 Database User Defined Data Types Large Graphics Character Data Locking Tables Table Locking CREATE USER Command RCAC (Row and Column Access Control) Grant SYSCTRL Authority DB2 LOAD Authority Check Roles Assigned to User Granting Privileges in DB2 DB2 Authorities - Upgrade/Delete/Revoke Privileges Locks an Application is Waiting for Convert Row-Organized Table to Column-Organized Table LOCKTIMEOUT Parameter in Database Configuration Check Table Space Utilization Activate Event Monitors Hidden Columns of a Table Restrictions of HADR Formatting DB2 Explain Plans Database Configuration |