1z1-338 by Oracle Actual Free Exam Q&As

Question 1

Which two statements are true about CellCLI? (Choose two.)

A. Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers. B. Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell. C. Using a CellCLI command, you can see whether grid disks are being used by ASM or not. D. CellCLI can be used to back up the Exadata storage cells or make a bootable disk to restore the cell. E. With a simple CellCLl command, you can synchronize changes to all the storage cells in the Exadata realm.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

Identify four significant changes when a backup of Exadata compute nodes must be performed. (Choose four.)

A. application of operating system patches B. before shutdown to preserve storage indexes C. reconfiguration of significant operating system parameters D. addition of an Exadata storage expansion rack E. installation or reconfiguration of significant non-Oracle software F. application of Oracle patches G. storage server rebalancing

Discussion 0

Correct Answer: A,C,D,F Vote an answer

Question 3

When provisioning Oracle Exadata Cloud Service, the wizard requests information about backup and restore options.
Which two options are provided to customers? (Choose two.)

A. backup directly to a Storage Cloud Software Appliance B. backup to Oracle Replication Cloud C. backup to Oracle Tape Library Cloud D. backup to Exadata storage (if this option was chosen during configuration) E. cloud storage through Oracle Database Backup Cloud Service

Discussion 0

Correct Answer: D,E Vote an answer

Question 4

What type of SRs does the ASR Manager generate for Exadata?

A. data entry errors B. operating system components C. software assets D. hardware assets E. backup and restore failures

Discussion 0

Correct Answer: C Vote an answer

Question 5

Consider the following command:
./patchmgr -cells dm01 -patch -rolling
Which two actions does this command perform? (Choose two.)

A. upgrades one or more Exadata Storage Servers, one at a time B. upgrades one or more Exadata Storage Servers listed in the dm01 file C. upgrades one or more Exadata Storage Servers simultaneously D. rolls back one or more Exadata Storage Servers to the previous release E. upgrades an Exadata Storage Server named dm01 F. upgrades one or more Exadata Storage Servers and InfiniBand Switches

Discussion 0

Correct Answer: C,E Vote an answer

Question 6

Your customer would like to install security software on all systems that are hosted out of their datacenter. Which statement correctly identifies Oracle guide line on where security software can be installed on Exadata?

A. The security software can be installed on the database server or a storage cells as long as the software is certified for Oracle enterprise Linux. B. The security software can be installed on database server but not on the storage cells unless the software is explicitly certified for Oracle enterprise Linux. C. The security software can be installed on database server but not on the storage cell. D. The security software can be installed on the database server or storage cells as required.

Discussion 0

Correct Answer: C Vote an answer

Question 7

You are measuring the I/O savings provided by storage indexes for Table A.
One of your scripts displays the I/O sayings as a result of the storage indexes.
Which two statements are true? (Choose two.)

A. The storage index data is not on the Cell Server's region index memory structures yet because this predicate has not been used. B. The storage indexes reduced the amount of physical I/O bytes significantly for this query. C. Since the database was started, no queries were run against this table with the same predicate. D. The accumulated I/O saved by the storage index is 1.68 MB. E. The storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.

Discussion 0

Correct Answer: A,B Vote an answer

Question 8

Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata? (Choose three.)

A. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features. B. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features. C. Auto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement and run it in parallel without special hints. D. 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. E. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter. F. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.

Discussion 0

Correct Answer: A,E,F Vote an answer

Question 9

A customer has received an email notification about a temperature alert on one of the storage servers on their Exadata system.
What action can the customer take to further investigate the alert?

A. Run exachk to find the system component that might be having a problem. B. Log in to the Oracle database and query v$temperature. C. Log in to the ILOM service processor and view the current status of the sensors and indicators on the system. D. SSH to the storage server and use the CeIICLI sensor_check command to get information about the storage server's health. E. Enter the data center and immediately power off the storage server.

Discussion 0

Correct Answer: D Vote an answer

Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials - 1z1-338 Exam Practice Test