Oracle 1z0-338 Online Practice Questions and Exam Preparation

Oracle 1z0-338 Online Questions & Answers

• Question 61:

  Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata? (Choose three.)

  A. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.
  B. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.
  C. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features.
  D. Auto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement and run it in parallel without special hints.
  E. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features.
  F. The SQL statements that take advantage of Auto DOP can be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.
  A. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.
  B. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.
  C. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features.

  ---

  Reference:

  https://books.google.com.pk/books?id=iY8Mt8SbWicCandpg=PA619andlpg=PA619anddq=Oracle%27s+Auto +DOP+algorithms+calculate+the+Degree+of+Parallelism+based+on+a+table%27s+block +countsandsource=blandots=2WytrJOjqandsig=wR8LwE3H4NgaDEZ8rQP8uVs2I1Mandhl=enandsa=Xandved=0ahUKEwjb_8iSy_jXAhUGzRQKHdeC Ag0Q6AEIJzAA#v=onepageandq=Oracle's%20Auto%20DOP%20algorithms%20calculate%20the% 20Degree%20of%20Parallelism%

  20based%20on%20a%20table's%20block%20countsandf=false.

• Question 62:

  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
  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

  ---

  Reference: https://www.oracle.com/webfolder/technetwork/tutorials/Architecture_Diagrams/ecs_arch/ ecs_arch.html

• Question 63:

  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.
  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.

• Question 64:

  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.
  E. The Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.

• Question 65:

  Your customer is implementing a storage consolidation strategy on their existing Exadata.

  Which step represents the Oracle recommended action that the customer should take in their approach?

  A. Do not use IORM because it will interfere with the shared database functionality on Exadata.
  B. Use ASM to create separate diskgroups for each database instance that is running on Exadata.
  C. Use IORM to distribute disk bandwidth among the databases.
  D. Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
  E. Set up a resource consumer group within each database instance and manage it individually.
  C. Use IORM to distribute disk bandwidth among the databases.

  ---

  Reference: http://www.oracle.com/technetwork/topics/cloud/whatsnew/mixedworkloadmgmtexadata- 300345.pdf page 42

• Question 66:

  In a customer's ACFS filesystem, they would like you to set up replication between the existing local primary and the remote standby Exadata system.

  Which tool would you use to administer the replication process?

  A. Replication is controlled by using Enterprise Manager Cloud Control.
  B. Replication is controlled by using sqlplus while you are logged in as SYSASM.
  C. Replication is controlled by using the acfsutil command-line tool.
  D. Replication of ACFS filesystems for non-database files on Exadata is not supported.
  E. Replication is controlled by using the exacli command-line tool.
  C. Replication is controlled by using the acfsutil command-line tool.

  ---

  Reference: http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/acfs/ learnmore/acfs-replication-122-3634228.html

• Question 67:

  Which two statements are true about metrics in the DBMCLI utility? (Choose two.)

  A. Metric values are computed and stored in memory, and then permanently stored on disk.
  B. DBMCLI can be used to report on Exadata storage server metrics.
  C. Metrics are reported as one of four types: cumulative, instantaneous, rate, or transition.
  D. Fields in AlertHistory cannot be modified.
  E. DBMCLI reported metrics are informational only and cannot be used to trigger alerts or reported events.
  A. Metric values are computed and stored in memory, and then permanently stored on disk.
  C. Metrics are reported as one of four types: cumulative, instantaneous, rate, or transition.

  ---

  Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/app_dbmcli.htm#DBMMN22246

• Question 68:

  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. ILOM
  B. ICMP
  C. RPC
  D. IPMI
  E. SNMP
  E. SNMP

• Question 69:

  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
  A. upgrades one or more Exadata Storage Servers simultaneously
  F. upgrades an Exadata Storage Server named dm01

• Question 70:

  Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

  A. Flash Cache
  B. database views
  C. InfiniBand networking
  D. high performance SAS2 disk drives
  E. cell offloading
  A. Flash Cache
  E. cell offloading