Oracle 1z0-338 問題集

質問 1：
The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-imaged with an Oracle Support installation image.
Which three tasks must be performed in order to re-image the compute node? (Choose three.)
A. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
B. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).
C. Mount the LVM backup image across the network and recover the system.
D. Create a CELLBOOT USB Flash Drive by using an external USB drive.
E. Reboot the new server by using a bootable recovery image from the external USB drive.
正解：A,B,E

質問 2：
Which three statements are true about the Enterprise Manager setup in Exadata? (Choose three.)
A. The Exadata Plug-In is automatically installed with EM Agent 12cR1.
B. InfiniBand Switches are monitored remotely.
C. When installing Enterprise Manager after a Platinum Services installation, you should reuse the existing EM Agent.
D. Enterprise Manager creates a schematic of all servers and their health in the Exadata rack.
E. Enterprise Manager shows the health of individual ports on the InfiniBand Switches.
正解：B,D,E

質問 3：
Which three features are unique to Exadata Storage? (Choose three.)
A. grid disks with default AU allocation sizes of 1 MB
B. prioritization of disk I/Os based on the database
C. database storage flash cache space allocation guarantees and limits
D. prioritization of OLTP I/Os over scan I/Os
E. usage of flash technology to cache recently used data
正解：A,B,C

質問 4：
What are three ways to be informed of an Exadata Storage Sever disk failure? (Choose three.)
A. alert notifications through email when SMTP notification is configured
B. review of the output of LIST ALERTHISTORY
C. alert notifications in the Enterprise Manager Exadata Plug-In
D. review of the database server iostat output
E. review of the ILOM log
F. review of the output of SELECT STATUS FROM V$DATAFILE
正解：A,B,C

質問 5：
You notice that a database node has hung, so you open a Service Request via My Oracle Support.
What diagnostic output will you send to My Oracle Support by default?
A. v$sessionoutput
B. pkginfo
C. oswatcher
D. list of database users
E. AWR
正解：E

質問 6：
Your customer wants to load source information into a database. The source files are generated on a remote HP-UX system and need to be written to the Exadata system. The ideal solution would be to use a remote file system where an ACFS file system is exported to the HP-UX system.
Which three options are supported using ACFS on Exadata 12.1.0.2 and later?
A. DBFS
B. ACFS is not supported on Exadata
C. NFS
D. SAMBA
E. HANFS
正解：A,C,D

質問 7：
The ipmi tool command is most commonly used to perform which two tasks?
A. To manage and maintain the Exadata storage servers and related cell commands.
B. To configure base networking and bonds within the Exadata server.
C. To show the ILOM SP server event logs in details for a listing of components status on a particular machine.
D. To manage cluster components.
E. To power on a chassis from another system in Exadata machine.
正解：C,E

質問 8：
Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata? (Choose three.)
A. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features.
B. The SQL statements that take advantage of Auto DOP can be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.
C. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.
D. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.
E. Auto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement and run it in parallel without special hints.
F. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features.
正解：C,D,F