Oracle Exadata X5 Administration

Here you have the best Oracle 1z0-070 practice exam questions

You have 34 total questions to study from
Each page has 5 questions, making a total of 7 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on November 17, 2024

Question 1 of 34

Identify three valid reasons for creating multiple griddisks on a single harddisk-based celldisk.

to implement storage realms so that storage that can be reserved for specific resource consumer groups in the same database

to enable the creation of normal or high redundancy ASM diskgroups

to segregate storage into multiple pools with different performance characteristics

to enable disk mirroring for the system area

to implement storage realms so that storage can be reserved for specific databases

to implement storage realms so that storage that can be reserved for specific Grid Infrastructure

Correct Answer: A, C, E

Creating multiple griddisks on a single harddisk-based celldisk can serve several purposes. First, it can help in implementing storage realms so that storage can be reserved for specific resource consumer groups within the same database, ensuring that different groups have dedicated storage resources (A). Additionally, it can segregate storage into multiple pools with different performance characteristics, allowing for better management and optimization of storage resources based on performance needs (C). Lastly, it allows for the implementation of storage realms so that specific databases can have dedicated storage, thereby enhancing organization and management of storage based on database requirements (E).

Question 2 of 34

Which three storage components are available after nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks?

mirrored system area on hard disk 0, hard disk 1, and hard disk 2

Exadata Smart Flash Cache using all of the flashdisk space

the DBFS_DG diskgroup with high redundancy

mirrored system area on hard disk 0 and hard disk 1

the RECO_ ASM diskgroup

the DATA_ ASM diskgroup

Correct Answer: D, E, F

In a nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks, the mirrored system area is placed on hard disk 0 and hard disk 1. The RECO_<DBM_Name> ASM diskgroup is used for storing recovery-related files. The DATA_<DBM_Name> ASM diskgroup is used for storing database files. These three components ensure that the deployment has the necessary storage configuration in place.

Question 3 of 34

Which two completely prevent a Smart Scan from occurring?

querying a table containing many chained rows

querying a table containing many migrated rows

performing a minimum or maximum function on an indexed column

performing a Fast Full Index scan on a reverse key index

referencing more than 255 columns form an OLTP compressed table in a query

querying a table containing a JSON column

Correct Answer: D, E

Smart Scans are specific to Oracle's Exadata storage, which offloads certain SQL processing to the storage layer to improve performance. However, several situations prevent this from occurring. Performing a Fast Full Index scan on a reverse key index completely prevents a Smart Scan because reverse key indexes do not allow the storage layer to efficiently process the data. Similarly, referencing more than 255 columns in an OLTP compressed table query prevents a Smart Scan since the limitation of Smart Scans is transporting a maximum of 254 columns. Both of these scenarios result in falling back to conventional I/O, hence disabling Smart Scan.

Question 4 of 34

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.

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.

There are chained rows in the table, causing some "single block physical reads" to be requested by the database instance, resulting in additional I/O.

The table is a hash clustered table, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O.

The table is list partitioned, causing "cell list of blocks physical reads" to be requested by the database instance, resulting in additional I/O.

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

Correct Answer: A, B

The 'cell physical IO interconnect bytes' statistic is greater than the 'cell physical IO interconnect bytes returned by smart scan' for several potential reasons. First, if there is a transaction that has committed after the query began, some table blocks may have been modified, leading to 'cell single block physical reads' that result in additional I/O. Second, if there are chained rows in the table, this can cause 'single block physical reads' to be requested by the database instance, again resulting in additional I/O. These situations increase the total I/O beyond what is returned by smart scans alone.

Question 5 of 34

You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata

Database Machine.

You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.

You issue this command on the first cell:

You examine the output from the first cell which contains:

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?

CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC

CT_IO_UTIL_SM and CT_IO_UTIL_LG

CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC

CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ

Correct Answer: A, D

To determine if the I/O performance has improved for the OLTP category, it is crucial to look at both the request rates and waiting times. The metrics CT_IO_RQ_SM and CT_IO_RQ_LG provide the cumulative number of I/O requests, while CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC provide the rate of small and large I/O requests per second. These metrics indicate the workload. The metrics CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ indicate wait times, which are critical in understanding performance improvements. By comparing these metrics for the current period with historical data, you can determine if there has been an improvement in I/O performance.