1Z0-338 Online Practice Questions and Answers

Which statement is true about Exadata Storage Servers?

A. Exadata Storage Servers automatically delete old diagnostic and metric files.

B. Exadata requires a running database instance on all storage servers and database servers.

C. Redundancy for the user data that is stored in a database that is running on Exadata is achieved with RAID5.

D. Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.

E. Exadata uses network affinity to determine which storage server data is written.

How does Advanced Compression differ from Hybrid Columnar Compression?

A. Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.

B. They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.

C. Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.

D. Advanced Compression is good for tables with active updates and deletes, whereas Hybrid Columnar Compression is best applied to tables or partitions where data is fairly static.

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. Create a CELLBOOT USB Flash Drive by using an external USB drive.

B. Mount the LVM backup image across the network and recover the system.

C. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.

D. Reboot the new server by using a bootable recovery image from the external USB drive.

E. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

Which three tools can be used on a freshly re-imaged Exadata system to create, resize, or delete ACFS filesystems? (Choose three.)

A. SQL*Plus and ASMCMD

B. ASMCA

C. Enterprise Manager Express

D. Enterprise Manager Cloud Control

E. RMAN

F. OUI

Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B.

Which architecture would you suggest to solve this deployment issue?

A. Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B.

B. Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.

C. Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.

D. Define the split by setting up database services that are specific to department A and department B.

To patch an Exadata cloud instance, you need to run the exadbcpatchmulti command as root from the compute node. exadbcpatchmulti uses the exadbcpatch.cfg file to provide information about the location of files related to patching operations as well as additional parameters related to these operations.

What is the purpose of the sw_bkup_needed=1 parameter that can be set in the exadbcpatch.cfg file?

A. creates a backup of the patch in case of an error in the patching routine

B. performs a backup of each Oracle home directory before a patch is applied

C. forces the software to create a backup of the exadbpatch.cfg file

D. adds a dialog box that prompts for a backup before the patch can be applied

E. creates a backup of the Oracle database data files

Identify the two choices a customer must make that impact diskgroup creation when the customer wants to have only a DATA diskgroup and a RECO diskgroup? (Choose two.)

A. the number of databases that will run on the cluster

B. the OS that will be run

C. the level of redundancy required

D. the ratio to use to split the available and usable storage between DATA and RECO

What are two value propositions for using the Oracle Configuration Manager (OCM) on Exadata? (Choose two.)

A. automatic resolution of configuration issues without customer intervention

B. improved access to best practices and Oracle knowledge base

C. fewer SRs to open

D. guaranteed better performance

E. faster issue resolution

Your Exadata Cloud instance has been fully provisioned and you continue the setup by logging in to the newly created Virtual Machines (VMs) by using SSH.

Which two default usernames can be used to log in to the VMs? (Choose two.)

A. administrator

B. oracle

C. root

D. system

E. opc

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 three options describe the flash memory capabilities of the Exadata X6-2 database and storage servers? (Choose three.)

A. no flash storage on the database server

B. 4 x 3.2 TB NVMe flash cards on the HC storage server

C. 8 x 3.2 TB NVMe flash cards on the EF storage server

D. 4 x 3.2 TB NVMe flash cards on the database server

E. 8 x 3.2 TB NVMe flash cards on the HC storage server

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

Where would your customer go to find the latest Exadata patches?

A. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and InfiniBand patches.

B. The Exadata owner guide.

C. The patch database in my Oracle support.

D. My Oracle Support note 888828.1.

E. The database machine in Exadata storage server 11g release 1 (11.1) supported version (Doc ID: 835032.1).

Which two statements are true about the two types of Exadata storage servers, the HC storage server and the EF storage server?

A. The EF storage servers contain 8 X 3.2TB PCIe flash cards.

B. The HC storage servers contain 12 X 8TB hard disks and 4 X 3.2TB PCI flash cards.

C. The HC storage server is an all disk storage server with no flash containing 12 X 8TB hard disk.

D. The EF storage server contains 8 X 3.2TB PCI flash card and can be upgraded with 4 more a total of

12.

E. The EF storage server contain 8 X 3.2TB PCI flash cards and 4 X 8TB disk drives.