Oracle 1z0-070 問題集

質問 1：
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to an X6 Exadata Database Machine.
The database currently supports an application requiring fast response times to satisfy stringent business requirements, and most of the application queries use indexed access to tables.
For which two cases would you consider dropping indexes that are not used for constraints after the migration to assure that Smart Scans occur?
A. if Smart Scans performs equally well to any type of index scan on the corresponding table.
B. if Smart Scan performs better that any type of index scan on the corresponding table.
C. if Smart only occur instead of index skip scans on the corresponding table.
D. if Smart only occur instead of index range scans on the corresponding table.
正解：B,D

質問 2：
You are in the process of upgrading your X5 Database Machine half rack to a full rack.
The new storage servers are called DM01CEL08 through DM01CEL14.
After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATA diskgroup by executing this SQL statement?
A. 0, because the new griddisks will be added to the existing failgroups
B. 12, consisting of seven griddisks each
C. 96, consisting of seven griddisk each
D. 1, consisting of all 96 griddisks
E. 7, consisting of 12 griddisks each
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You are planning the migration of a large data warehouse to a Little Endian X6 Database Machine using which is running database version 12.2.0.1.
The current database version is Oracle Database 11.2.0.4.0 hosted on a Big Endian platform.
The current database characterset is WE8ISO8859P15.
Which two migration methods are supported?
A. cross-platform Transportable Database
B. Data Pump
C. Physical Standby database
D. Logical Standby database
正解：B,D

質問 4：
Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?
A. Oracle Solaris must be used on the server where ASR Manager is installed.
B. ASR Manager must be installed on one of the database servers.
C. ASR Manager may be installed on any type of server running Oracle Solaris.
D. Oracle Linux must be used on the server where ASR Manager is installed.
E. HTTPS connectivity must be enabled from the ASR Manager host to the Internet.
F. SMTP must be enabled on at least one database server.
G. ASR Manager may be installed on any type of server running Oracle Linux.
正解：C,E,G
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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 メンバーにのみ表示されます)

質問 6：
An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.
Identify the two steps that you must perform to replace this failed physical disk.
A. Add the griddisks back into the ASM diskgroup they used to be a member of.
B. Replace the failed physical disk.
C. Create a new celldisk and new griddisks on the replaced physical disk.
D. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
E. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?
A. cellsrv returns all blocks that have been or might have been changed since the last backup, and RMAN filters the blocks that do not require backup.
B. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in archivelogmode.
C. Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.
D. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelogmode.
E. Block Change tracking (BCT) is not needed for databases in an X5 Database Machine, because ASM automatically does block change tracking when diskgroups are built from griddisks.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which three statements are true about Exadata storage server alerts in an X5 Database Machine?
A. A threshold- based alert gets cleared automatically when the measured value no longer violates the threshold.
B. Storage server alerts are all stateless alerts.
C. Storage server alerts notifications may be sent using SNMP.
D. Storage server alerts are all stateful alerts.
E. A storage server alert is only ever issued as a warning or at a critical situation.
F. Storage server alerts notifications may be sent using SMTP.
正解：A,C,E