Database Administrator (PostgreSQL / Oracle) — SeniorCovers PostgreSQL and Oracle administration: indexing, query tuning, backup and recovery, and replication, matching the depth senior DBA interviews test.Price: US$ 24.89. 100 published questions in this package.Objectives

SQL Fundamentals

Schema Design

Transactions

Indexing & Performance

Administration

High Availability

Performance Tuning

Internals

Security

Monitoring

Data Types

Backup & Recovery

Replication

Concurrency

Oracle

SyllabusSQL FundamentalsSchema DesignTransactionsIndexing & PerformanceAdministrationHigh AvailabilityPerformance TuningInternalsSecurityMonitoringData TypesBackup & RecoveryReplicationConcurrencyOracleSample questions

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?

To buy and practice you need to enable JavaScript and create an account.