1Z0-338 Online Practice Questions and Answers

Which statement explains the difference between Normal and High redundancy ASM failure groups?

A. Normal redundancy protects the DATA diskgroup, whereas High redundancy protects the RECO diskgroup.

B. Normal redundancy (best practice) provides protection against two simultaneous disk failures, whereas High redundancy provides protection against a single disk failure or an entire storage server failure.

C. High redundancy gives more usable storage, whereas Normal redundancy provides better I/O performance.

D. Normal redundancy protects from disk failure when a cell is offline or being updated, whereas High redundancy protects the system when all the cells are offline.

E. Normal redundancy tolerates a single cell failure, whereas High redundancy tolerates a two-cell failure.

Which statement is true about the patching features provided in Platinum Services?

A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

B. Patching support includes Exadata, Exalogic, and Database Appliance.

C. Patching services are available for the full software stack up to twice per year.

D. The rolling window and complete down time approaches are two options to patching.

You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line.

Identify two other ways that you can connect. (Choose two.)

A. Use the ILOM Web GUI.

B. Use the dcli command at the root prompt on a database node.

C. Attach a terminal device to the back panel of the server with a serial cable.

D. Connect by using SQL*Plus.

E. Log in as root on the database node by using the Net1 IP address.

Identify two ways that Smart Flash Cache can be enabled on an Exadata Database Machine. (Choose

two.)

A. It is enabled through OEDA by selecting the Enable FlashCache check box in the hardware configuration section.

B. It can be enabled with the ‘cellcli - I alter flashCache=on’command.

C. It can be enabled manually with the CREATE FLASHCACHEcommand from CellCLI.

D. It can be enabled by default during installation.

E. It can be enabled by using the cellCLI DROP FLASHCACHEcommand.

Which two terms correctly describe the concept of moving database processing from the database layer to the storage layer to reduce the volume of data that needs to be processed by the database server? (Choose two.)

A. sharding

B. offloading

C. Smart Scan

D. predicate filtering

E. column projection

Which two steps are needed to set up instance caging on an Exadata system? (Choose two.)

A. Set the CPU_COUNT parameter to the maximum number of CPUs that the database instance should utilize at any time.

B. Enable a resource plan to manage the CPUs.

C. Specify the optimization objective as low_latency or high__throughput.

D. Set PGA_AGGREGATE_LIMIT to an acceptable level for the intended instances.

E. Change the initialization parameter THREADED_EXECUTION to TRUE and restart the instance.

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. When installing Enterprise Manager after a Platinum Services installation, you should reuse the existing EM Agent.

C. InfiniBand Switches are monitored remotely.

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.

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 simultaneously

B. upgrades one or more Exadata Storage Servers listed in the dm01 file

C. upgrades one or more Exadata Storage Servers, one at a time

D. rolls back one or more Exadata Storage Servers to the previous release

E. upgrades one or more Exadata Storage Servers and InfiniBand Switches

F. upgrades an Exadata Storage Server named dm01

Identify three default ways to connect to Oracle Exadata Cloud Service that is running on Oracle Public Cloud.

A. using the UNIX-based telnet command

B. using SQL *Net from clients that are running on a compute cloud service

C. using SSH for administrative purposes

D. using Oracle Net from on-premise applications

E. using the Remote Desktop client and the RDP protocol

Which statement is true about High Availability (HA) in an Exadata environment?

A. When a standby database is in place, DB_BLOCK_CHECKINGis not required and thus is not recommended.

B. The checksums that are performed on the Exadata Storage Server ensure logical consistency of the block content.

C. Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.

D. Due to the different architecture that Exadata has with storage servers when compared to regular Storage Area Network, DB_LOST_WRITE_PROTECTneed not be set.

E. The Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUMon a database.