Tag: databases

Covers Oracle database administration topics (control files, tablespaces, RMAN, initialization parameters, backups, and background processes) and DB2 standalone utilities (DSN1 and DSNJ utilities for data management and recovery).

Test your knowledge of IBM DB2 standalone utilities including DSN1SDMP, DSN1PRNT, DSN1LOGP, DSN1COPY, DSN1COMP, DSN1CHKR, DSNJU004, DSNJU003, and DSNJLOGF, plus Oracle SQL concepts including iSQL*Plus commands, date formatting, indexes, substitution variables, aliases, sequences, TRUNCATE, datetime types, and multi-table inserts.

Tests knowledge of Oracle Database Administration including RMAN backup and recovery, tablespaces, listener configuration, archivelog mode, background processes, and SQL operations.

Test your knowledge of SQL Server database concepts including indexes, query optimization, performance tuning, DDL operations, and SQL syntax

Quiz covering SQL commands, functions, PL/SQL programming, cursors, triggers, and database management concepts

Test your knowledge of Oracle PL/SQL programming, database triggers, stored procedures, and database administration concepts. Includes questions on PL/SQL blocks, exceptions, indexes, and database constraints.

Covers concepts and utilities for Sybase IQ, DB2, and IMS database management systems including query optimization, indexing, storage structures, and administration utilities

Covers basic SQL SELECT statements, operators, subqueries, DML operations, and SQL Server Integration Services (SSIS) concepts including control flow elements and transformations.

Test your knowledge of SQL functions (ROUND, TRUNC, MOD, SYSDATE, LAST_DAY), join types (self join, outer join, equi-join), and other essential SQL concepts.

Covers SQL data manipulation, aggregate functions, GROUP BY/HAVING clauses, NULL handling, and Oracle-specific features like MERGE and NVL