Oracle 1z0-070 問題集

質問 1：
Examine this IORM plan:

Which two are true concerning this plan?
A. I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.
B. If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.
C. The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.
D. If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.
E. I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if no other databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two completely prevent a Smart Scan from occurring?
A. querying a table containing a JSON column
B. referencing more than 255 columns form an OLTP compressed table in a query
C. querying a table containing many chained rows
D. performing a Fast Full Index scan on a reverse key index
E. performing a minimum or maximum function on an indexed column
F. querying a table containing many migrated rows
正解：B,F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?
A. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
B. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
C. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage nodes.
D. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
E. Cloud control can monitor and manage a Database Machine compute node expansion rack.
F. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.
G. Computer nodes forward their SNMP traps to the Management Server process on the same computer node.
正解：A,D,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine?
A. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
B. ASR Manager must be installed and configured on one of the database servers.
C. ASR can upload configuration metadata to support problem resolution.
D. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
E. ASR communicates with Oracle support services using HTTPS.
F. Configuring ASR is mandatory for all Database Machine assets.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
In which scenario will griddisks residing on the same celldisk have balanced performance characteristics in an X5 High Capacity Exadata Storage Server?
A. griddisks on memory based celldisks
B. griddisks on Flash-based celldisks
C. griddisks on hard disk-based celldisk consumed by ASM when creating diskgroups using ASM-based Intelligent Data Placement (IDP)
D. griddisks on hard disk-based celldisks consumed by the Database Smart Flash Cache
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
As part of planning for database consolidation, you grouped your databases into two categories based on different technical and business objectives.
Which three statements are true about possible configurations for your Exadata X6 Database Machine fabric?
A. The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization.
B. A single database cluster benefits from accessing multiple storage grids.
C. The database grid may be partitioned when deploying a multirack Database Machine configuration.
D. Multiple database clusters never benefit from accessing a single storage grid.
E. Multiple database clusters may access the same storage grid.
正解：B,C,E

質問 7：
You plan to migrate an Oracle database supporting an online transaction processing (OLTP) workload to an X5 Exadata Database Machine.
The database machine is running database version 12.1.0.2.
The source database has these attributes:
Database version: 12.1.0
Byte order: Big Endian
Database size: 24 TB
You have decided to perform physical migration using the Transportable Tablespace method.
Examine this list of possible steps to accomplish this task.
1. Create a new 12.1.0.2 Exadata-based database.
2. Export the source system metadata using Transportable Tablespace (TTS).
3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the little endian format.
4. Import the metadata into the target database.
5. Use the RMAN CONVERT to change the database files to the little endian format on the source system.
Identify the required steps in the correct order.
A. 1, 2, 4, 5
B. 1, 2, 3, 4, 5
C. 1, 2, 5, 3, 4
D. 1, 2, 5, 4
E. 1, 2, 3, 4
F. 1, 2, 5, 4, 3
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which two activities are supported on the storage servers in an Exadata X6 Database Machine?
A. Changing the root password
B. Upgrading the Storage Server software package using RPM
C. Upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
D. Installing an alternative package manager
E. Configuring secure shell user equivalency for the cellmonitor user
正解：B,D