Tag: databases

Test your knowledge of DB2 database concepts including sequences, data types, constraints, authentication, schemas, packages, and SQL performance optimization.

Covers enterprise database systems including IBM IMS, AS400 database files, Oracle database administration, and data warehousing concepts

Quiz covering stored procedures, triggers, indexes, and job scheduling in Oracle and SQL Server databases.

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).

Test your knowledge of Oracle SQL syntax, functions, querying, and database concepts including ROWNUM, TO_DATE, indexes, triggers, and SQL*Plus commands.

Tests knowledge of Oracle SQL string functions (TRANSLATE, REPLACE, INSTR), numeric operations, set operations (UNION ALL, MINUS), and error handling with DUAL table queries.

Test your knowledge of SQL commands, database operations, and Oracle-specific features including SELECT statements, table creation, views, constraints, and data manipulation.

Test your knowledge of SQL character functions, DML/DDL commands, database indexing including Sybase IQ, and Oracle SQL*Loader data loading options and control files.

Covers database triggers (Oracle), ETL transformations (Informatica), and Teradata database architecture concepts

Test your knowledge of SQL Server administration (configuration, recovery models, DMVs, services) and general database concepts including table partitioning, query optimization, views, and SQL DML operations.