Oracle 1Z0-485 Online Practice Questions and Exam Preparation

Oracle 1Z0-485 Online Questions & Answers

• Question 1:

  You are calculating the storage capacity that your customer will require on their ZFS Backup Appliance. Identify the set of factors that will affect this calculation.

  A. database size, full/incremental cycle, RPO (Recovery Point Objective), and RTO (Recovery Time Objective)
  B. database size, retention period, RPO (Recovery Point Objective), and compression
  C. database size, full/incremental cycle, compression, and retention period
  D. database size, compression, and backup window
  E. full/incremental cycle, retention period, and ZFS Backup Appliance model
  C. database size, full/incremental cycle, compression, and retention period

• Question 2:

  What are two choices that a customer must make that impact diskgroup creation?

  A. What is the level of redundancy required?
  B. What OS will be run?
  C. Where will disk backups be written?
  D. How many databases will run on the cluster?
  A. What is the level of redundancy required?
  B. What OS will be run?

• Question 3:

  When would be the best time to run an Exadata health check (exachk)?

  A. before patching, before upgrades, before backups, and on a regular basis
  B. after patching, after upgrades, and after backups
  C. only when advised by Oracle Support
  D. before and after patching, when advised by Oracle Support, and on a regular basis
  E. only after a hardware failure
  F. monthly and after a hardware failure
  D. before and after patching, when advised by Oracle Support, and on a regular basis

• Question 4:

  Which statement is true about instance caging setup?

  A. Instance caging is the right approach to make sure that database instances are not stealing memory from each other.
  B. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
  C. Database instances need to be restarted to make changes to cpu_count effective.
  D. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing
  E. The init.org parameter resource_manager_plan should be set.
  D. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing

• Question 5:

  Which two statements describe correct network configuration for Exadata Database Machine?

  A. The InfiniBand network subnet manager runs on all database servers to achieve High Availability.
  B. Oracle Clusterware communication is configured to use the management network.
  C. The InfiniBand network interfaces on Linux servers are configured using active- passive bonding.
  D. Database connections to the SCAN listener route through the Ethernet switch in the Exadata rack.
  E. Database servers are deployed with three logical network interfaces configured: management, client access, and private.
  C. The InfiniBand network interfaces on Linux servers are configured using active- passive bonding.
  D. Database connections to the SCAN listener route through the Ethernet switch in the Exadata rack.

• Question 6:

  You are asked to enable Write Back Flash Cache for one of your customers X3-2 Full Rack in a rolling fashion. Put the following steps in the right order:

  A. G. B, C, A, F, E, D, and G
  B. G, A, B, C, F, E, D, and G
  C. G, C, B, A, F, E, D, and G
  D. G, E, C, B, F, A, D, and G
  E. Create the Flash Cache.
  F. Start up cellsrv and activate all grid disks.
  G. Check grdidksk asmdeactivationoutcome and asmmodestatus for all grid disks to ensure that all grid disks on all cells are set to Yes and online, respectively.
  C. G, C, B, A, F, E, D, and G

• Question 7:

  Which statement is true about the patching features provided in Platinum Services?

  A. Patching services are available for the full software stack up to twice per year.
  B. Patching support includes Exadata, Exalogic, and Database Appliance.
  C. Rolling window and complete down time approaches are two options to patching.
  D. Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.
  D. Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

• Question 8:

  How would you execute CellCLI commands and scripts?

  A. using SQL*Plus on database nodes
  B. by CellCLI commands executed on the database nodes
  C. using third party tools after installing the CellCLI RPM plug-in
  D. directly executing the commands and scripts on the Exadata storage cell
  E. remotely by connecting to Port 1521 using SSL
  D. directly executing the commands and scripts on the Exadata storage cell

• Question 9:

  Identify three best practices for applying asmdeactivationoutcome es on Exadata Database Servers and Exadata Storage Servers?

  A. Backing up database servers and storage cells is not recommended before performing planned maintenance.
  B. Database server updates can be rolled back using the the "yum downgrade" procedure.
  C. Bundle patches do not require testing before being installed on a production system.
  D. It is recommended that Exadata systems with Data Guard configured use the "Standby First" patching approach.
  E. Patching should never be interrupted due to a connection drop. It is therefore recommended that you use VNC or the screen utility.
  F. Before patching cells in a rolling manner, you must check asmdeactivationoutcome amModestatus and make sure that cells on all disks are online and that disks can be deactivated.
  D. It is recommended that Exadata systems with Data Guard configured use the "Standby First" patching approach.
  E. Patching should never be interrupted due to a connection drop. It is therefore recommended that you use VNC or the screen utility.
  F. Before patching cells in a rolling manner, you must check asmdeactivationoutcome amModestatus and make sure that cells on all disks are online and that disks can be deactivated.

• Question 10:

  Which is the best location to point your customer to, for finding the latest Exadata patches?

  A. owner's guide
  B. Patch database in MyOracle Support
  C. MyOracle Support note 888828.1
  D. MyOracle Support for database patches, ULN for OS patches, and Sun Support for Server and InfiniBand patches.
  B. Patch database in MyOracle Support