oracle 1z0-338 practice test

Question 1

Which two statement are true about enabling the write-back flash cache?

• A. When enabling the write-back-flash-cache in a rolling manner dbcli should be used to inactivate the grid disks on all cells first.
• B. Before write-back-flash-cache is enabled you need to drop the flash cache first.
• C. Write back flash cache requires a minimum required software version.
• D. When enabling write-back-flash-cache in a non-rolling manners it is important to ensure that asmdeactivationoutcome is set to yes and asmmodestatus is set to online for all grid disks.
• E. flashcachemode should be set to write back by updating cellinit.ora and restarting cellsrv.

Answer:

B C

Question 2

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.

Answer:

C

Question 3

Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)

• A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
• B. Install in Oracle Virtual Machine with required hardware.
• C. Install on Exadata Engineered System.
• D. Provide individual x86 64-Bit gateway hardware.
• E. Install on Oracle Database Appliance.

Answer:

A B C

Explanation:
Reference: http://www.oracle.com/us/assets/platinum-services-faq-1653259.pdf

Question 4

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

• A. When a standby database is in place, DB_BLOCK_CHECKING is 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_PROTECT need not be set.
• E. The Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.

Answer:

E

Question 5

Identify two uses for flash storage in an Exadata Database Machine that uses High Capacity or High Performance Storage
Servers? (Choose two.)

• A. location for storing redo log and archive log files for faster recovery
• B. flash-based grid disks for persistent database storage
• C. Smart Flash Cache for database performance
• D. backup location for storage indexes so that they can be rebuilt after a reboot
• E. operating system file storage to help system performance

Answer:

A C

Question 6

Which statement is true about Hybrid Columnar Compression (HCC)?

• A. HCC is a good choice for LOBs, BLOBs, and CLOBs.
• B. HCC data resides compressed in flash.
• C. HCC being a database feature will work with all types of storage hardware.
• D. HCC is best suited for OLTP type databases with a large number of ongoing transactions.

Answer:

C

Explanation:
Reference: https://www.dewpoint.com/sites/default/files/images/Dewpoint%20White%20Paper%20-%
20Hybrid%20Columnar%20Compression%20HCC%20Jan2013.pdf

Question 7

How do ASM failure group provide redundancy?

• A. Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.
• A. For external redundancy ASM disk groups are placed in a Raid 1+0 configuration to ensure the no blocks are lost during an outage.
• B. They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.
• B. They ensure that the ASM disks are accessed via ADB protocol and not physically mounted on the database server.
• C. Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.
• C. They assign ASM disks to failure groups to ensure that the mirror copies of a block are not in the same failure group.
• 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.
• D. They ensure that the cell disks are sliced into grid disks by using cellsrv processes.

Answer:

C

Question 8

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. SAMBA
• 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. NFS
• B. The security software can be installed on the database server or storage cells as required.
• C. HANFS
• C. The security software can be installed on database server but not on the storage cell.
• D. DBFS
• D. 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.
• E. ACFS is not supported on Exadata

Answer:

C

Question 9

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

• A. Replication is controlled by using Enterprise Manager Cloud Control.
• A. The EF storage servers contain 8 X 3.2TB PCIe flash cards.
• B. Replication is controlled by using sqlplus while you are logged in as SYSASM.
• B. The HC storage servers contain 12 X 8TB hard disks and 4 X 3.2TB PCI flash cards.
• C. Replication is controlled by using the acfsutil command-line tool.
• C. The HC storage server is an all disk storage server with no flash containing 12 X 8TB hard disk.
• D. Replication of ACFS filesystems for non-database files on Exadata is not supported.
• 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. Replication is controlled by using the exacli command-line tool.
• E. The EF storage server contain 8 X 3.2TB PCI flash cards and 4 X 8TB disk drives.

Answer:

A,B

Question 10

Which three statements describe the memory capabilities of the X6-2 Exadata system?

• A. To configure base networking and bonds within the Exadata server.
• A. The database server come with 256GB memory default.
• B. To power on a chassis from another system in Exadata machine.
• B. The database server can contain 768GB memory.
• C. To show the ILOM SP server event logs in details for a listing of components status on a particular machine.
• C. The HC and EF storage servers contain 128GB memory.
• D. To manage and maintain the Exadata storage servers and related cell commands.
• D. The database server come with 512GB memory by default.
• E. To manage cluster components.
• E. The HC and EF server come with 512GB memory default.

Answer:

A,B,C