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?

A

End 2017

23
Q

Masking and audit vault svcs eta?

A

Q4 2017

24
Q

Zdlra service eta

A

End 2017

25
Q

Big data cloud machine eta?

A

End 2017

26
Q

Sparc m7 cores ghz

A

32 core

4 ghz

27
Q

Sparc m7 software in silicon

How many database Accel engines on chip?

A

32

28
Q

Sparc m7 simd vector

A

Independent search for all values that match calif in a column -170b rows/sec

29
Q

Capacity in silicon m7

A

Doubles memory capacity by compressing data on chip and m7 adds 32 decompress engines

30
Q

ExadatA sl6

A

Sparc Linux 6
X86 database servers replaced. Y sparc servers
2x faster than x86
32 core sparc m7

31
Q

Exadata cloud service

A

All advanced options included

Compute. Bursting

32
Q

Min cores for exdata cloud machine

A

16

33
Q

Amazons compute and storage services

A

Amazon elastic compute cloud - ec2

Amazon simple storage service - s3

34
Q

Amazon database offerings

A

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
Q

Non volatile memory

A

Between flash and dram speed wise
Survive power failure
Better write endurance than flash

Larger capacity than dram

Cost bête flash and dram