Tag: databases

Test your knowledge of SQL, PL/SQL, Oracle database features, data warehousing concepts, and Cognos BI tools including Framework Manager and Report Studio.

Quiz covering SQL queries, data warehousing concepts, universe and report management, and business intelligence fundamentals

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

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)

Advanced database concepts covering space allocation (spool, permanent, temporary), table types (volatile, global temporary, multiset), keys and indexes, and SQL features

Test your knowledge of Oracle database concepts including SQL queries, transactions, triggers, constraints, data types, and PL/SQL programming

Quiz covering SQL database keys (Primary Key, Foreign Key, Unique Key), comparison operators, and basic DML statements including SELECT, INSERT, and ORDER BY clauses

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

Covers core database concepts including records, data items, database models, SQL fundamentals (views, indexes, keys, WHERE clause, HAVING, LIKE pattern matching), and data warehousing concepts (ETL tools, OLTP, SCD)

Test your knowledge of database fundamentals including views, constraints, joins, subqueries, and Oracle SQL functions like DECODE, NVL, NVL2, NULLIF, and date operations.