Oracle 1Z0-485 Online Practice Questions and Exam Preparation

Oracle 1Z0-485 Online Questions & Answers

• Question 51:

  Which two actions are permitted with Exadata Database Machine?

  A. replacing the Ethernet switch with an equivalent 1U 48-port Gigabit Ethernet switch
  B. installing a second Ethernet switch in the Exadata rack for client access network connectivity
  C. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand Gateway Switch
  D. configuring a Linux active-active channel bonding on the database servers by using two 10-Gigabit Ethernet port
  E. configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers
  A. replacing the Ethernet switch with an equivalent 1U 48-port Gigabit Ethernet switch
  C. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand Gateway Switch

• Question 52:

  Which statement is true about Exadata Storage Servers?

  A. The Exadata Storage Server automatically deletes old diagnostic and metric files.
  B. Exadata requires a running database instance on all storage servers and database servers.
  C. Redundancy for user data stored in a database that is running on Exadata is achieved with RAID5.
  D. Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.
  E. Exadata uses network affinity to determine which storage server data is written.
  C. Redundancy for user data stored in a database that is running on Exadata is achieved with RAID5.

• Question 53:

  Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would recommend?

  A. adding a High Capacity Storage expansion rack
  B. expanding the Exadata rack from a Half Rack to a Full Rack
  C. moving underutilized grid disks from the RECO diskgroup to DATA
  D. adding a ZFS storage appliance
  E. adding a High Performance Storage expansion rack
  A. adding a High Capacity Storage expansion rack
  B. expanding the Exadata rack from a Half Rack to a Full Rack

• Question 54:

  Identify the three values to which the CELL_FLASH_CACHE attribute can be set.

  A. READ
  B. WRITE
  C. KEEP
  D. DEFAULT
  E. NONE
  C. KEEP
  D. DEFAULT
  E. NONE

• Question 55:

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

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

• Question 56:

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

  The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-image with an Oracle Support installation image. Which three tasks would you need to perform to re-image the compute node?

  A. Mount the LVM backup image across the network and recover the system.
  B. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
  C. Create a CELLBOOT USB Flash Drive using an external USB drive.
  D. Reboot the new server using a bootable recovery image from the external USB drive.
  E. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).
  B. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
  C. Create a CELLBOOT USB Flash Drive using an external USB drive.
  E. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

• Question 58:

  Which is a best practice for High Availability (HA) in an Exadata environment?

  A. Checksums performed on the Exadata Storage Server ensure logical consistency of block content.
  B. When a standby database is in place, DB_BLOCK_CHECKING is not required and thus not recommended.
  C. Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.
  D. Due to the different architecture that Exadata has with storage servers, compared to regular Storage Area Network, DB_LOST_WRITE_PROTECT need not be set.
  E. Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.
  C. Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.

• Question 59:

  When should you use Hybrid Columnar Compression?

  A. always
  B. on large active tables where deeper compression is desired
  C. on tables or partitions that have fairly static data
  D. on every table where Advanced Compression is not used
  C. on tables or partitions that have fairly static data

• Question 60:

  You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line. What are two other ways in which you can connect?

  A. Use the ILOM Web GUI.
  B. Use the dcli command at the root prompt on a database node.
  C. Attach a terminal device to the back panel of the server with a serial cable.
  D. Connect by using SQL *Plus.
  E. Log in as root on the database node using the Net1 IP address.
  A. Use the ILOM Web GUI.
  C. Attach a terminal device to the back panel of the server with a serial cable.