Tag: databases

Test your knowledge of Oracle database internals including SGA and PGA memory structures, background processes (DBWR, LGWR, SMON, PMON), buffer cache management, and instance recovery mechanisms.

Test your knowledge of data modeling concepts, entity-relationship diagrams, database normalization, and database design principles including keys, relationships, and schemas.

Covers data architecture, database modeling, PL/SQL procedures, triggers, packages, functions, and database administration concepts

Covers Oracle database concepts including SQL operations, transactions, data dictionary, schema objects, and performance monitoring tools like AWR and Statspack.

Questions about IBM DataStage tool, Oracle Enterprise stage, ODBC connections, parallel processing, partitioning, lookup operations, and file sets in data integration and ETL workflows

Covers Teradata architecture, indexing, loading utilities, and performance management tools

Test your knowledge of Oracle Applications administration, data warehousing concepts including schemas and transformations, and SQL Server database management tasks.

Test your knowledge of SQL fundamentals including SELECT, INSERT, DELETE, ORDER BY, GROUP BY, sub-queries, views, and operators, plus Teradata-specific utilities like FastLoad and TPUMP for data warehousing operations.

Covers database concepts including Oracle performance tuning, SQL Server indexing and replication, data warehouse architecture, and database administration tasks.

Test your knowledge of SQL Server database administration including replication, isolation levels, backup strategies, and dynamic management views