Oracle 1z1-070 Value Pack (Frequently Bought Together)

Which two are true about the allocation of I/O resources by IORM within the CELLSRV process?

• A. If two consumer groups C and D in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively, and were remapped to a different category by the DBA, provided that the category plans and the interdatabase plans are unchanged.
• B. Log Writer I/O and Control File I/O are always prioritized over all user I/O.
• C. If two consumer groups P and Q in the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups P and Q are still mapped to the same categories.
• D. Database Writer I/O is always prioritized over all user I/O.
• E. If two consumer groups A and B in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and interdatabase plans are unchanged, and consumer groups A and B are still mapped to the same category.

You are evaluating the performance of a SQL statement that accesses a very large table.
You run this query:

Identify two reasons why the "cell physical IO interconnect bytes" statistic is greater than the "cell physical IO interconnect bytes returned by smart scan" statistic.

• A. There are chained rows in the table, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.
• B. The table is a hash clustered table, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O.
• C. There is a local index on a list partitioned table on the column used in the WHERE clause, causing "cell list of blocks physical reads" to be requested by the database instance, resulting in additional I/O.
• D. The table is list partitioned, causing "cell list of blocks physical reads" to be requested by the database instance, resulting in additional I/O.
• E. There is a transaction, which committed after the query began, that has modified some of the table blocks, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.

Identify the four software components that run only on an Exadata Database Machine Database Server.

• A. Oracle Enterprise Manager Agent (OMA)
• B. Cell Serve (CELLSRV)
• C. DISKMON
• D. DSKM
• E. ASM instance
• F. CELLCLI
• G. Automatic Diagnostic Repository Command Interpreter (ADRCI)

Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?

• A. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.
• B. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.
• C. The "keep" cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.
• D. Multiblock reads can benefit from Smart Flash Cache.
• E. Single block reads can benefit from Smart Flash Cache.

Which two Exadata X5 security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A. Using EXADCLI instead of CELLCLI to create the griddisks
• B. Exadata storage realms using ASM-scoped security mode
• C. file permissions on the griddisks in each storage server
• D. file permissions on the griddisks in each database server
• E. Exadata storage realms using database-scoped security mode