Oracle 1Z0-485 Online Practice Questions and Exam Preparation

Oracle 1Z0-485 Online Questions & Answers

• Question 41:

  Which two statements are true about troubleshooting failed patching activities?

  A. Dependency issues found during yum updates require rolling back to a previous release before retrying.
  B. Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.
  C. Failed OS patches on database servers can be rolled back.
  D. Failed storage cell patches are rolled back to the previous release automatically.
  E. Database server OS updates can be rolled back using opatch auto -rollback.
  F. Dependency issues found during yum updates should be ignored using the force option.
  A. Dependency issues found during yum updates require rolling back to a previous release before retrying.
  E. Database server OS updates can be rolled back using opatch auto -rollback.

• Question 42:

  Identify a recommended configuration to set up Auto Service Request (ASR) for Exadata.

  A. Install ASR Manager on Exadata Database Server.
  B. Install ASR Manager on Exadata Storage Server.
  C. ASR is not recommended for Exadata; the Oracle Configuration Manager is preferred.
  D. Install ASR Manager on a Standalone Server.
  D. Install ASR Manager on a Standalone Server.

• Question 43:

  Identify the relevant steps in the correct order for activating an Auto Service Request (ASR) configuration.

  1.

  Add SNMP traps manually or using OneCommand.

  2.

  Install ASR Manager.

  3.

  Activate a node on ASR Manager.

  4.

  Validate the configuration.

  5.

  Register ASR Manager with Oracle.

  A. 2, 5, 1, 3, and 4
  B. 2, 4, I, 3, and 5
  C. 5, 2, 4, 1, and 3
  D. 5, 4, 2, 1, and 3
  A. 2, 5, 1, 3, and 4

• Question 44:

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

  A. When enabling write-back flash cache in a non rolling manner, it is important to ensure that asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all grid disks.
  B. Before using write-back flash cache, you need to verify the minimum required versions.
  C. Before write back-flash cache is enabled, you need to drop the Flash Cache first.
  D. The setting flashCacheMode should be set to writeback by updating cellinit.ora and restarting cellsrv.
  E. When enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid disks on all cells first.
  B. Before using write-back flash cache, you need to verify the minimum required versions.
  C. Before write back-flash cache is enabled, you need to drop the Flash Cache first.

• Question 45:

  You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O savings as a result of the storage indexes. Which two statements are true?

  SQL> select count (*) from transmap.mymap_comp

  2 where map_id between 400 and 500;

  COUNT(*)

  Elapsed: 00:00:00.08

  SQL> select b.name, a.value/1024/1024 value

  from vSmystat a, vSstatname b,

  where b.statistic# = a.statistic#

  and b.nafne in (穋ell physical IO bytes eligible for predicate offload', 穋ell physical IO interconnect bytes', 穋ell physical IO bytes saved by storage index',

  穋ell physical IO interconnect bytes returned by smart scan') order by 1;

  Statistic Value (MB) --------------------------------------------------------------------------------------------- ----------------- cell physical IO bytes eligible for predicate offload 2,255 .09 cell physical IO bytes saved by storage index .00 cell physical IO interconnect bytes 1.72 cell physical IO interconnect bytes returned by smart scan 1.68

  A. The storage indexes were disabled using the DISABLE_STORAGE_INDEX Parameter.
  B. Storage Index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.
  C. Since the database was started, no quires were run against this table with the same predicate.
  D. The storage indexes reduced the amount of physical I/O bytes significantly for this query.
  B. Storage Index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.
  C. Since the database was started, no quires were run against this table with the same predicate.

• Question 46:

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

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

• Question 47:

  Which two statements are true about migrating your database to Exadata?

  A. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.
  B. Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.
  C. ASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,
  D. Logical migration methods allow more flexibility than physical methods to change the database structure for best performance.
  E. All indexes should be dropped when migrating to Exadata.
  C. ASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,
  D. Logical migration methods allow more flexibility than physical methods to change the database structure for best performance.

• Question 48:

  Which two statements appropriately describe the backup and recovery procedures on Exadata?

  A. Cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.
  B. Data stored in a database is backed up and restored by using CellCLI commands.
  C. Database server software backup is automatic and recovery is accomplished by using a rescue procedure.
  D. Data stored in a database is backed up and restored by using RMAN commands.
  E. Cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.
  A. Cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.
  D. Data stored in a database is backed up and restored by using RMAN commands.

• Question 49:

  Which statement is true about Enterprise Manager 12c for Exadata?

  A. EM Agents are installed on each database and storage node.
  B. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.
  C. EM Agents can communicate to storage cells via SSH.
  D. The Exadata Plug-In for monitoring switches is installed in each EM Agent.
  E. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.
  D. The Exadata Plug-In for monitoring switches is installed in each EM Agent.

• Question 50:

  A control file tracks the physical components of a database. It is the root file that the database uses to find all the other files used by the database. Because of the importance of the control file, Oracle recommends that the control file be __________?

  A. size constrained, to prevent size overruns
  B. multiplexed, or have multiple identical copies
  C. stored on an HA USB Drive, to ensure that it does not get overwritten
  D. managed by EM12c, to ensure proper maintenance
  D. managed by EM12c, to ensure proper maintenance