oracle 1z0-338 practice test

Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials Exam

Last exam update: Feb 20 ,2024
Page 1 out of 6. Viewing questions 1-15 out of 81

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

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

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

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

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

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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

User Votes:
A
50%
B
50%
C
50%
D
50%

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

Discussions
vote your answer:
A
B
C
D
0 / 1000

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

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
0 / 1000

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

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000

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

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

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

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 11

When a customer use Enterprise Manager to monitor and maintain their Exadata machine, which
protocol does enterprise manager uses to send and receive information about component failure
event and status.

  • A. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and InfiniBand patches.
  • A. ILOM
  • B. The Exadata owner’s guide.
  • B. ICMP
  • C. The patch database in my Oracle support.
  • C. RPC
  • D. My Oracle Support note 888828.1.
  • D. IPMI
  • E. The database machine in Exadata storage server 11g release 1 (11.1) Supported Versions (Doc ID: 835032.1).
  • E. SNMP
Answer:

E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 12

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

  • A. iDB – Intelligent Database Protocol
  • A. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and InfiniBand patches.
  • B. InfiniBand protocol
  • B. The Exadata owner guide.
  • C. Ethernet protocol
  • C. The patch database in my Oracle support.
  • D. Secure Shell protocol
  • D. My Oracle Support note 888828.1.
  • E. Fibre Channel protocol
  • E. The database machine in Exadata storage server 11g release 1 (11.1) supported version (Doc ID: 835032.1).
Answer:

D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 13

Which three steps should you perform before executing the following command which will set the
cell flash cache mode to write back?
# cellcli e alter cell flashcachemode=writeback

  • A. Flash Cache
  • A. Inactivate all physical disks on the cell.
  • B. database views
  • B. Shutdown the cellsrv services on the cell.
  • C. InfiniBand networking
  • C. Disable the storage indexes on the cell.
  • D. high performance SAS2 disk drives
  • D. Inactivate the grid disks on the cell.
  • E. cell offloading
  • E. Create a new flash cache on the cell.
  • F. Drop the existing flash cache on the cell.
Answer:

B,D,F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 14

Which characteristics of DBFS on Exadata would you suggest as being a key benefit?

  • A. Use the ILOM Web GUI.
  • A. When using DBFS customers will not need to use FUSE or any client software to administer the file system.
  • B. Use the dcli command at the root prompt on a database node.
  • B. DBFS offers tremendous I/O bandwidth.
  • C. Attach a terminal device to the back panel of the server with a serial cable.
  • C. Tens of thousands of files are the perfect use case for DBFS on Exadata.
  • D. Connect by using SQL*Plus.
  • D. DBFS in an Exadata environment is faster than an NFS mount system because of smart scan performance gain.
  • E. Log in as root on the database node by using the Net1 IP address.
  • E. DBFS allow customer to store LOB and CLOB files external to database for more flexibility.
Answer:

C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 15

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

  • A. using the UNIX-based telnet command
  • 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. using SQL *Net from clients that are running on a compute cloud service
  • B. Before write-back-flash-cache is enabled you need to drop the flash cache first.
  • C. using SSH for administrative purposes
  • C. Write back flash cache requires a minimum required software version.
  • D. using Oracle Net from on-premise applications
  • D. When enabling write-back-flash-cache in a non-rolling manners it is important to ensure that asmdeactivationoutcome is set to yes andasmmodestatus is set to online for all grid disks.
  • E. using the Remote Desktop client and the RDP protocol
  • E. flashcachemode should be set to write back by updating cellinit.ora and restarting cellsrv.
Answer:

B,C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000
To page 2