Between Active Data Guard & Golden Gate, which can be used with non-Oracle Databases?
GG
100
Which 4 add-ons are "essential" for running high performance workloads on Exadata?
RAC, Diag, Tuning, Partitioning
100
What are the two key security features of ASO?
Redaction, Encryption
100
Which can run all database workloads? RAC or RAC One Node?
Both
200
Which DB edition includes Data Guard?
EE
200
How many ways can you configure GoldenGate?
SIX
200
AWR is a crucial part of which add-on?
Diagnostics
200
Which add-on can be found within the architecture of SPARC based servers?
ACO, ASO
200
Which is better for managing a shared cluster database? RAC or RAC One Node?
RAC
300
This Edition includes RAC.
What is SE2?
300
Which DR product is ideal for long distance scenarios?
ADG
300
Which products are pre-requisites for Diagnostics? Which are pre-reqs for Tuning?
Diag - DB EE
Tuning - DB EE, Diag
300
What are the pre-reqs for ACO? What are the pre-reqs for ASO?
DB EE for both
300
A customer wants to light up 8 more total cores in their ODA X6-2-HA. They are leveraging RAC One Node currently. Name all Oracle licensing they need (proc based).
**DAILY DOUBLE**
2x DB EE CPU, 2x RAC ONE NODE CPU
400
Golden Gate is included with which DB version?
NONE!
400
Between ADG & GG, which eliminates unplanned downtime?
BOTH
400
Object Reorganization is a part of which addon?
***DAILY DOUBLE***
Tuning
400
Storage Snapshot Optimization is a part of which add-on?
ACO
400
Which is viewed as the more cost effective resource management tool? RAC or RAC One Node?
RAC
500
How many licenses of DB EE does the customer need to license their VMware environment?
There are 3 servers in the physical cluster.
Each one has two quad-core Intel procs.
12 DB EE CPU (or 300 NUP)
3 servers * 2 procs per server * 4 cores per proc = 24 * .5 core factor = 12 procs needed (or 12*25 = 300 NUP)
500
License the following scenario for all Oracle licenses needed.
The customer needs SE2 and wants you to quote out a way for them to replicate to a 3rd server. They have 1000's of employees using these apps.
2 production database servers supporting separate apps
1 DR database server
*procs are Xeon-based, all servers are single 8 core procs
3x DB SE2 CPU
12x GG CPU
500
What are the 3 reasons to partition a database?
Manageability, Performance, Availability
500
Joe Customer wants to bolster the security of his database environment. He already has ASO. Name one potential product that could also help.
Oracle Key Vault
Oracle Database Vault
Oracle Data Masking and Subsetting
Oracle Label Security
Oracle Audit Vault and Database Firewall
500
This product works with old AS400 systems run off of IBM DB2 as well as Oracle DB -- RAC or RAC One Node?