Database Administrator (PostgreSQL / Oracle) — SeniorCovers PostgreSQL and Oracle administration: indexing, query tuning, backup and recovery, and replication, matching the depth senior DBA interviews test.Precio: US$ 24.89. 100 preguntas publicadas en este paquete.Objetivos

SQL Fundamentals

Schema Design

Transactions

Indexing & Performance

Administration

High Availability

Performance Tuning

Internals

Security

Monitoring

Data Types

Backup & Recovery

Replication

Concurrency

Oracle

Contenido del programaSQL FundamentalsSchema DesignTransactionsIndexing & PerformanceAdministrationHigh AvailabilityPerformance TuningInternalsSecurityMonitoringData TypesBackup & RecoveryReplicationConcurrencyOraclePreguntas de ejemplo

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN?

What are primary keys, foreign keys, and unique constraints, and how do they differ?

What does ACID stand for and what does each property guarantee?

Para comprar y practicar necesitas activar JavaScript y crear una cuenta.