Oracle Continuous Innovation

ORACLE 11g-R2 INTERACTIVE QUICK REFERENCE

CHECK INFO

ASMCMD> ls -l

State    Type    Rebal  Name

MOUNTED  EXTERN  N      ARCH/

MOUNTED  EXTERN  N      ASM_SHARING/

MOUNTED  EXTERN  N      DATA/

ASMCMD> lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512   4096  1048576      2047     1688                0            1688              0             N  ARCH/

MOUNTED  EXTERN  N         512   4096  1048576       203      106                0             106              0             N  ASM_SHARING/

MOUNTED  EXTERN  N         512   4096  1048576      3067      140                0             140              0             N  DATA/

CREATE VOLUME ON DISKGROUP

ASMCMD> volcreate -G ARCH -s 256M vol_sharing                

Note: minimum size of Volume is 256M; DiskGroup containt Volume must free >=256MB

VOLUME INFO

ASMCMD> volinfo -G ARCH vol_sharing

Diskgroup Name: ARCH

         Volume Name: VOL_SHARING

         Volume Device: /dev/asm/vol_sharing-153

         State: ENABLED

         Size (MB): 256

         Resize Unit (MB): 256

         Redundancy: UNPROT

         Stripe Columns: 4

         Stripe Width (K): 128

         Usage:

         Mountpath:

REGISTER VOLUME WITH ACFS (ASM Cluster File System)

root@rac1 ~]# mkfs -t acfs /dev/asm/vol_sharing-153

mkfs.acfs: version                   = 11.2.0.1.0.0

mkfs.acfs: on-disk version           = 39.0

mkfs.acfs: volume                    = /dev/asm/vol_sharing-153

mkfs.acfs: volume size               = 268435456

mkfs.acfs: Format complete.

MOUNT/UNMOUNT VOLUME

root@rac1 ~]# mount -t acfs /dev/asm/vol_sharing-153          /u02

[root@rac1 ~]# df -k

Filesystem           1K-blocks      Used Available Use% Mounted on

/dev/mapper/VolGroup00-LogVol00

                       3935944   3300992    431792  89% /

/dev/sda3              1019240     36260    930368   4% /tmp

/dev/sda2             13204256   9555020   2967680  77% /u01

/dev/sda1               101086     15430

QUESTION 61
You have completed initial installation of an Exadata Database Machine. Which type of components can you add after installation?

A.
Software in the Exadata Storage Server

B.
Hardware in the Exadata Storage Server

C.
Software in the Database Servers

D.
Hardware in the Database Servers


Answer: C
Section: (none)

Explanation/Reference:
Oracle® Exadata Database Machine
Owner's Guide

Oracle Exadata Database Machine Restrictions
The following restrictions apply to hardware and software modifications to Oracle
Exadata Database Machine. Violating these restrictions can result in loss of warranty
and support.
¦ Oracle Exadata Database Machine (Database server) hardware cannot be modified or customized.
There is one exception to this. The only allowed hardware modification to Oracle
Exadata Database Machine is to the administrative 48-port Cisco 4948 Gigabit
Ethernet switch included with Oracle Exadata Database Machine.
¦ Oracle Exadata Storage Server Software and the operating systems cannot be
modified, and customers cannot install any additional software or agents on the
Exadata Storage Servers.
¦ Customers may load additional software on the database servers. However, to
ensure best performance, Oracle discourages adding software except for agents,
such as backup agents and security monitoring agents, on the database servers.






QUESTION 62
Which statement would you make about sharing I/O resources in an Exadata environment?

A.
You can manage workloads accross multiple databases with Database Resource Manager

B.
You can manage workloads within a database with 10 Resource Maanger

C.
You can manage workloads

QUESTION 51
What is the rule for using different types of compression on difference of a single table stored on an Exadata Storage Server?

A.
All partitions must either be compressed or uncompressed

B.
All partitions must use either OLTP compression or Hybrid Columnar Compression

C.
You can not mix compression types among  partitions of the tables

D.
Any partition can use any type of compression, regardless, compression of  other partitions


Answer: D
Section: (none)

Explanation/Reference:









QUESTION 52
The Oracle Exadata Database Machine retrieves data from disks in response to a SQL statement in the same way as a standard database server.

A.
TRUE

B.
FALSE


Answer: B
Section: (none)

Explanation/Reference:
Using iDB




QUESTION 53
A Database Resource manager plan includes which three attributes?

A.
Database names, allocations and resource groups

B.
Database names, resource groups and categories

C.
Database names, levels and allocations

D.
Database names, levels and resource groups


Answer: A
Section: (none)

Explanation/Reference:












QUESTION 54
Which Exadata Storage server users can only view Exadata cell objects?

A.
Root

B.
Celladmin

C.
Cellmonitor

D.
CellCLI


Answer: C
Section: (none)

Explanation/Reference:
Luu ý: nh?ng gì celladmin và cellmonitor làm du?c thì root cung làm du?c ngoài ra calibrate ch? ch?y du?c v?i root.



QUESTION 55
Which three load characteristics will benefit from IORM plans?

A.
Conflicting workloads, both of which are latency sensitive

B.
When CPU is a bottleneck

C.
Conflicting workloads,

QUESTION 11
Your customer’s high priority applications are throughput-sensitive. The feature of the Oracle Exadata Database Machine is Crucial to service high priority applications?

A.
Flash Cache

B.
IORM

C.
ASM

D.
RAC


Answer: A
Section: (none)

Explanation/Reference:



QUESTION 12
How much Fash memory comes with an Oracle Exadata Database Full Rack?

A.
348 TB

B.
1TB

C.
2.6TB

D.
5.3TB


QUESTION 41
Your customer has designated a number of database objects to be persistently in the Exadata Smart Flash Cache. What happens if  the total size of these objects is greater than 80% of the size of the available Exadata Smart Flash Cache?

A.
Nothing

B.
Exadata Smart Flash Cache expands the allocations to hold the objects

C.
Not all objects will be stored in Exadata Smart Flash Cache

D.
Overall performance is increased as more objects fit in to Exadata Smart Flash Cache


Answer: C
Section: (none)

Explanation/Reference:
Exadata Smart Flash Cache provides a caching mechanism for frequently accessed data on each Exadata cell. Exadata Smart Flash Cache works in conjunction with Oracle Database to intelligently optimize the efficiency of the cache.

Each database I/O is tagged with the following metadata:
• The CELL_FLASH_CACHE setting for the object associated with the I/O:
- DEFAULT specifies that Exadata Smart Flash Cache is used normally.
- KEEP specifies that Exadata Smart Flash Cache is used more aggressively.
- NONE specifies that Exadata Smart Flash Cache is not used.

When suitable data is inserted into a full cache, a prioritized least recently used (LRU) algorithm determines which data to replace.
Objects with a CELL_FLASH_CACHE setting of KEEP are subject to a different cache retention policy than objects with a CELL_FLASH_CACHE setting of
DEFAULT. KEEP objects have priority over DEFAULT objects so that new data from a DEFAULT object will not push out cached data from any KEEP objects.
To prevent KEEP objects from monopolizing the cache, they are allowed to occupy no more than 80% of the total cache size.
Also, to prevent unused KEEP objects from indefinitely occupying the cache, they are subject to an additional aging policy, which periodically purges unused KEEP object data.


QUESTION