Oracle Oracle Certifications 1Z0-485 Questions & Answers

• Question 51:

  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. 100% Real QandAs | 100% Real Pass

  Correct Answer: C

• Question 52:

  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.

  Correct Answer: CD

• Question 53:

  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

  Correct Answer: D

• Question 54:

  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.

  Correct Answer: CD

• Question 55:

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

  100% Real QandAs | 100% Real Pass

  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

  Correct Answer: D

• Question 56:

  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?

  Correct Answer: AB

• Question 57:

  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

  Correct Answer: AB

• Question 58:

  Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

  A. INSERT

  B. INSERT with an APPEND hint

  C. UPDATE

  D. CREATE TABLE AS SELECT

  Correct Answer: BD

• Question 59:

  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.

  Correct Answer: AE

• Question 60:

  Identify three Exadata Storage Server software processes and their purpose?

  A. CELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing offload.

  B. CELLSRV: The Cell Server is responsible for balancing workload to other storage servers. 100% Real QandAs | 100% Real Pass

  C. MS: The Management Server is responsible for storage cell management and configuration.

  D. MS: The Management Server is responsible for starting a local Enterprise Manager agent.

  E. RS: The Restart Server is responsible for Automatic Storage Management (ASM) instance restart.

  F. RS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.

  Correct Answer: ACF