12c Flashcards

1
Q

12cr2 avail in cloud

A

Fall 2016

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

12cr2 avail on premises

A

March 2017

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Exadata express GA DATE

A

9/17/16

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Want pct of Helpdesk calls are 12c

A

40 pct

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

NYSE case study

A

ExData
350 TV
Large transactional systems
1 pb transactions daily

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Mysql cloud service ga date

A

9/20/16

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Db service on bare metal ga date

A

12/15/16

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

3 types exadata

A

Private cloud - Exadata db machine

Cloud @customer - Exadata cloud machine

Public cloud - Exadata cloud service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Project exacloud

A

Massive pool Exadata storage servers shared across thousands of dbs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Exadata moving from 40 FBI infiniband to

A

100 FBI/sec Ethernet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Nvram ga?

A

2018

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Omega

A
Absolute avail
No applis change
In memory oltp
Fast
Scale out
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Dw cloud service

A

Openworld
No dba
Load and go

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Ula 2 Paas

A

$2 paas investment yields $1 support decrease

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Exadata express cloud service pricing

A

X20 - $175/mo 20 gb
X50 - 750/mo 50 gb
X50-im- 50 FBI +dbim $950/mo

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Oracle db machine learning product

A

Autonomous Health Framework

17
Q

Ahf components

A
Hang Mgr 
Mem guard
Who's mgt
Cluster verif util 
Orachk
Cluster health monitor
Cluster health advisor 
Trace file analyzer
18
Q

Big data sql query targets

A

Nosql (oracle nosql, apache hbase -no sql sits on hdfs)
Oracle db
Hadoop hdfs, apache hive (sql access hdfs), parquet (columnar storage in hdfs), apache orc(columnar storage for Hadoop), apache avro

19
Q

Oracle db cloud services -4

A

Exadata express - 5/20/50 gb
Database cloud service - se2, we, HP, ep

Database cloud access bare metal

Exadata cloud avec - 42 TV - pbs

20
Q

Big data sql storage differentiator

A

Smart query at storage - no sql, oracle db, Hadoop

21
Q

Big data cloud service

A
3 node start
Cloudera full - cdh, spark(in memory query engine), impala(sql query engine), hbase, kafka - handle real time data feeds
Oracle big data connectors
Big data spatial and graph
Odi 
Bdd 
Big data sql - coming
22
Q

Free db cloud service when?

23
Q

Masking and audit vault svcs eta?

24
Q

Zdlra service eta

25
Big data cloud machine eta?
End 2017
26
Sparc m7 cores ghz
32 core | 4 ghz
27
Sparc m7 software in silicon How many database Accel engines on chip?
32
28
Sparc m7 simd vector
Independent search for all values that match calif in a column -170b rows/sec
29
Capacity in silicon m7
Doubles memory capacity by compressing data on chip and m7 adds 32 decompress engines
30
ExadatA sl6
Sparc Linux 6 X86 database servers replaced. Y sparc servers 2x faster than x86 32 core sparc m7
31
Exadata cloud service
All advanced options included | Compute. Bursting
32
Min cores for exdata cloud machine
16
33
Amazons compute and storage services
Amazon elastic compute cloud - ec2 Amazon simple storage service - s3
34
Amazon database offerings
Redshift - dw AurorA - mysql compatible db Dynamodb - nosql Amazon relational database service - supports mysql, oracle db, sql server, postgresql, Maria db Amazon EMR - Elasticache - IMDb Simpledb
35
Non volatile memory
Between flash and dram speed wise Survive power failure Better write endurance than flash Larger capacity than dram Cost bête flash and dram