Oracle 1z0-338 Online Practice Questions and Exam Preparation

Oracle 1z0-338 Online Questions & Answers

• Question 71:

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

  A. The database server come with 256GB memory default.
  B. The database server can contain 768GB memory.
  C. The HC and EF storage servers contain 128GB memory.
  D. The database server come with 512GB memory by default.
  E. The HC and EF server come with 512GB memory default.
  A. The database server come with 256GB memory default.
  B. The database server can contain 768GB memory.
  C. The HC and EF storage servers contain 128GB memory.

• Question 72:

  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 FLASHCACHE command from CellCLI.
  D. It can be enabled by default during installation.
  E. It can be enabled by using the cellCLI DROP FLASHCACHE command.
  C. It can be enabled manually with the CREATE FLASHCACHE command from CellCLI.
  E. It can be enabled by using the cellCLI DROP FLASHCACHE command.

• Question 73:

  When preparing to install ASR on your customer's Exadata Database Machine, which user account will you use first to configure the Exadata Database Server?

  A. asmadmin
  B. oracle
  C. asruser
  D. celladmin
  E. root
  F. asradmin
  E. root

  ---

  Reference: https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm#ASXQI103

• Question 74:

  Oracle Configuration Manager is the key to the proactive capabilities of MyOracle Support.

  Which three statements describe OCM? (Choose three.)

  A. It is used to collect configuration details and upload them to the management repository.
  B. Configuration collection happens once an hour.
  C. A customer can associate an SR to their configuration data to reduce issue resolution time.
  D. Oracle Base, ASM, and GRID home must have the same owner for installation to work.
  E. Configuration collection occurs every 24 hours.
  A. It is used to collect configuration details and upload them to the management repository.
  C. A customer can associate an SR to their configuration data to reduce issue resolution time.
  E. Configuration collection occurs every 24 hours.

• Question 75:

  Which CellCLI command is used to conclude that a storage server can be taken offline without impacting database availability?

  A. LIST GRIDDISK ATTRIBUTES name, status;
  B. LIST CELLDISK ATTRIBUTES name, raidLevel, asmModeStatus;
  C. LIST CELLDISK ATTRIBUTES name, raidLevel
  D. LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;
  E. LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;
  D. LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;

  ---

  ASMDeactivationOutcome recall that grid disks can be deactivated, which is effectively taking them offline. Since ASM mirroring ensures that the data is located on another disk, making this disk offline does not lose data. However, if the mirror is offline, or is not present, then making this grid disk offline will result in loss of data. This attribute shows whether the grid disk can be deactivated without loss of data. A value of "Yes" indicates you can deactivate this grid disk without data loss. CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus DBFS_DG_CD_02_cell01 Yes ONLINE DBFS_DG_CD_03_cell01 Yes ONLINE DBFS_DG_CD_04_cell01 Yes ONLINE

• Question 76:

  Your customer has encountered some system disk issues and has been told that a "storage cell rescue procedure" must be implemented.

  What will this procedure accomplish?

  A. It will perform a predictive disk failure replacement for cell disks.
  B. It will recover the Exadata system volumes by using the internal USB flash disk.
  C. It will perform cell flash cache failure replacement.
  D. It will perform a complete storage server hardware replacement.
  E. It will perform a database server disk replacement.
  B. It will recover the Exadata system volumes by using the internal USB flash disk.
  C. It will perform cell flash cache failure replacement.
  D. It will perform a complete storage server hardware replacement.

• Question 77:

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

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

• Question 78:

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

• Question 79:

  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
  B. offloading
  C. Smart Scan

  ---

  Reference: http://www.oracle.com/technetwork/database/exadata/exadata-dbmachine-x4-twp-2076451.pdf

• Question 80:

  Which user can create administrator accounts and change the administrator password in Oracle Exadata Cloud Service?

  A. system
  B. Account Administrator
  C. Identity Domain Administrator
  D. sys
  E. Service Instance Administrator
  C. Identity Domain Administrator

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/service-roles-and-users.html