Oracle & Enterprise Databases

Quiz covering database concepts, Teradata utilities and architecture, and DB2 management tools and privileges (includes some legacy tool references)

Test your knowledge of DB2 database administration including configuration, tools (Task Center, Journal, Developer Work Bench), database extenders, authentication, and privilege management (GRANT/REVOKE on tables, views, indexes, and sequences).

Questions covering DB2 database security, permissions, tools, data warehousing, and product features.

Tests knowledge of DB2 database concepts including XML processing, spatial extenders, data warehousing, OLTP databases, and DB2 tools and products

Test your knowledge of DB2 product editions, licensing, and Oracle database concepts including SQL, triggers, tablespaces, and performance optimization

Covers advanced Oracle database topics including triggers, INTERVAL partitioning, REGEXP functions, and SQL performance tuning techniques.

Test your knowledge of Oracle database concepts including PL/SQL programming, SQL queries, views, cursors, functions, and database administration fundamentals.

Covers Oracle database concepts including PL/SQL programming, SQL syntax, constraints, indexes, normalization, cursor operations, and transaction management.

Test your knowledge of Oracle SQL including views, joins, subqueries, functions, constraints, and data types.

Covers Oracle PL/SQL concepts including cursors (explicit and implicit), packages, variable declarations, exceptions, triggers, and SQL functions

Covers database programming concepts including PL/SQL functions, procedures, triggers, and Teradata-specific features like Primary Index, Secondary Index, PPI tables, and utilities (Fastload, Multiload)

Test your knowledge of Oracle database programming including PL/SQL procedures, triggers, cursors, packages, views, and collection types

Test your knowledge of Oracle SQL including indexes, joins, constraints, views, sequences, and PL/SQL concepts

Test your knowledge of Oracle database concepts including table structure, indexes, constraints, views, SQL statements, and PL/SQL programming.

Quiz covering SQL Server and Oracle database administration topics including system databases, processes, recovery models, listener configuration, and SQL language classification.