Oracle 1Z0-485 Online Practice Questions and Exam Preparation

Oracle 1Z0-485 Online Questions & Answers

• Question 1:

  When using IORM, which statement accurately describes when redo log file writes take place?

  A. Based on the priority of the user
  B. Immediately
  C. Based on the resource group of the user
  D. Based on the intradatabase resource plan
  B. Immediately

• Question 2:

  What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?

  A. Configure IORM to disable Flash Cache usage for batch workload.
  B. Build a Database Resource Management Plan, giving priority to query workload.
  C. Deploy Instance Caging to control batch jobs.
  D. Configure and enable Parallel Query.
  E. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workload.
  B. Build a Database Resource Management Plan, giving priority to query workload.

• Question 3:

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

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

• Question 4:

  Which three statements accurately describe update of software on Exadata Database Machine?

  A. The Oracle Database patchset software (for example, 11.2.0.3) requires the Exadata-specific version.
  B. Rolling patching is faster than non-rolling patching, but database down time is longer.
  C. The Oracle Database software on Exadata is updated using standard OPatch and the Oracle Universal Installer.
  D. Running Exadata with different storage server software versions is supported, but should be minimized to rolling patching scenarios.
  E. The database server operating system software (other than kernel and OFED) may be installed or updated from non-Exadata sources
  F. Storage server updates require access to an Unbreakable Linux Network (ULN) based repository.
  C. The Oracle Database software on Exadata is updated using standard OPatch and the Oracle Universal Installer.
  D. Running Exadata with different storage server software versions is supported, but should be minimized to rolling patching scenarios.
  F. Storage server updates require access to an Unbreakable Linux Network (ULN) based repository.

• Question 5:

  Identify two tasks that the Database Resource Manager can perform, which the I/O Resource Manager cannot.

  A. Manage I/O based on the application that is connected to the database.
  B. Manage the number of parallel sessions for a query.
  C. Manage I/O and CPU between databases on the same cluster or physical database host.
  D. Terminate database sessions when certain limits have been reached.
  E. Manage the throughput of an I/O-bound application based on the service name used for the connection.
  B. Manage the number of parallel sessions for a query.
  D. Terminate database sessions when certain limits have been reached.

• Question 6:

  When running OS Watcher, which two data outputs are valid for Exadata storage cell performance analysis? Select the two correct choices that apply?

  A. lostat
  B. mpstat
  C. netstat
  D. pkginfo
  E. label
  A. lostat
  C. netstat

• Question 7:

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

  Which two statements are true about CellCLI?

  A. Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers.
  B. Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell.
  C. With a simple CellCLI command, you can synchronize changes to all the storage cells in the Exadata realm.
  D. Using a CellCLI command, you can see whether grid disks are being used by ASM or not.
  E. You cannot use CellCLI to gather the serial numbers of physical disks.
  B. Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell.
  D. Using a CellCLI command, you can see whether grid disks are being used by ASM or not.

• Question 9:

  Why is ASM High redundancy an important configuration choice when rolling Exadata Storage Server patching is planned?

  A. High redundancy protects from partner disk failure while a cell is offline being updated.
  B. High redundancy forces ASM rebalance before allowing disks to be taken offline.
  C. High redundancy speeds up ASM fast mirror resync when a cell is brought back online after patching.
  D. Normal redundancy provides the same protection during rolling patching, so High redundancy is not important in this case
  A. High redundancy protects from partner disk failure while a cell is offline being updated.

• Question 10:

  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