Db Security Flashcards
5 oracle db security options
Advanced security- encrypt and redact ($$$.$$.7189)
Db vault - block dbas from salary data
Audit vault and Db firewall - stop malicious sql before it hits db (or le, mysql, ss, db2)
Data mask & subsetting pack - convert sensitive data into realistic test data
Label security - add column with labels - public, confidential, restricted
Security g cloud dbs
Encryption by default
4 processing engines
Sql
Spark
Mr
Graph engine
Fully managed dwaas
Grow shrink Db storage and compute
Backup/recov
Patch upgrade
Allocate new dbs
Dwaas compute and storage
Independent scaling
Can burst CPUs
Add. Ew storage or compute is click of console
Db cloud service on bare metal
High speed connectivity betw db paas and compute
Fast flash storage - nvme
No Vm overhead
No noisy neighbor - dedicated server
Local storage - lowest latency
Do aws and azure offer bare metal?
No
Db cloud service 2 server shape
High io- Intel server 2-36 core 512 FBI mem 4tb triple mirrored flash Single instance Db
Dense io
Same as above except 9tb triple mirrored flash nvme storage
What are the 4 db cloud editions
Standard
Enterprise
Enterprise high perf - + partit, multi tenant, adv compression, multi tenant, adv security, label security, db vault, OLAP, data mask and subset
Enterprise xtreme perf - +in memory, RAC, active data guard
Database cloud service supports which versions of the database
11g
12c
Is the database cloud service fully automated
No
Must do backups and patching
What security is provided with Db cloud service
Ta l’espace encryption. Y default
Dbcs horiz scale limit
2 node, 16 ocpu
Extreme perf option only
Advantage of Db paas vs byol to iaas
Automated provis of Db vms
Auto backup
Auto patch and upgrade tools
Rac - extreme perf edition
Dataguard
What options does Exadata cloud service and Exadata cloud machine include?
All
