Tag: databases

Quiz covering database concepts, query optimization, transaction isolation, and administration across SQL Server and IMS database systems

Covers database concepts across multiple platforms including IMS status codes and utilities, Oracle SQL functions and indexing, and SQL Server DMVs, replication, and maintenance

Quiz covering Oracle Exadata Hybrid Columnar Compression features, CELL_OFFLOAD parameters, and SQL query techniques including MERGE statements, subqueries, views, sequences, roles, and indexing.

Test your knowledge of basic SQL queries, SQL*Plus commands, DDL statements, and database operations including SELECT, INSERT, TRUNCATE, subqueries, and Teradata-specific data types.

Test your knowledge of SQL database operations including SELECT, INSERT, UPDATE, DELETE statements, and data manipulation functions.

Covers Teradata database concepts including architecture, utilities, and indexes, plus Oracle PL/SQL programming fundamentals and SQL*Plus features.

Covers Sybase database concepts including indexes, constraints, cursors, SQL functions, stored procedures, and system tables

Covers core database concepts including Oracle/PL/SQL programming, schema objects, data integrity, constraints, views, data modeling, and SQL fundamentals.

This quiz covers Oracle database administration topics including database startup/shutdown, dynamic performance views, indexing, PL/SQL collections and packages, LOB handling, query result cache, fine-grained access control, SGA architecture, triggers, locking, transaction isolation, and views.

Test your knowledge of database administration, SQL coding standards, performance optimization techniques, security guidelines, and Oracle-specific features like parallelism and indexing.