Tag: databases

Test your knowledge of PL/SQL programming including data types, blocks, functions, procedures, and concurrent execution in Oracle databases.

Test your knowledge of IMS (Information Management System) database concepts, including segments, DBD, PSB, processing options, and hierarchical database management.

Test your knowledge of Oracle SQL functions, PL/SQL cursors, loops, and exception handling

Covers SQL statements, RDBMS concepts, data manipulation, and database design fundamentals including sorting, wildcards, comparison operators, and logical components

Test your knowledge of SQL queries, PL/SQL, database operations, and ETL transformations

Test your knowledge of database operations, data warehousing concepts, slowly changing dimensions, datamarts, and ETL transformation processes including mapping and loading strategies.

Covers general database concepts including SQL queries, joins, subqueries, and embedded SQL, along with specific IMS database topics such as SSA, PSB, status codes, and retrieval methods.

Test your knowledge of Oracle database architecture, SQL command categories (DDL, DML, DCL, TCL), and memory management components like Shared Pool, Large Pool, and SGA.

Test your knowledge of BlackBerry Enterprise Server administration, BES configuration, BlackBerry handheld management, BlackBerry databases, and BlackBerry communication protocols.

Test your knowledge of Oracle database concepts, SQL commands, constraints, joins, and RMAN backup/recovery features