Oracle 1z0-485 Dumps 2021

NEW QUESTION 1
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

Answer: C

Explanation: The Exadata Smart Flash Cache feature of the Exadata Storage Server Software intelligently caches database objects in flash memory, replacing slow, mechanical I/O operations to disk with very rapid flash memory operations. .

NEW QUESTION 2
What are two impacts of selecting high redundancy over normal redundancy for your diskgroups?

• A. High redundancy provides more usable storage.
• B. Normal redundancy provides more usable storage.
• C. High redundancy gives you better I/O performance.
• D. High redundancy provides High Availability (HA) during disk failure and rolling Storage Server patching
• E. Normal redundancy provides HA during rolling Storage Server patching.

Answer: BD

NEW QUESTION 3
Which three migration options are available when you migrate a database from the Big Endian format system to Exadata?

• A. Data Pump Export and Import
• B. transportable database
• C. transportable tablespaces
• D. Data Guard
• E. Insert as Select

Answer: BCD

Explanation: Methods at a Glance:
* Data Guard Physical Standby
* Transportable Database (Note:732053.1)
* Transportable Tablespace (TTS)

NEW QUESTION 4
Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.

• A. Transformations can be applied directly on the file data using SQL or PL/SQL constructions.
• B. External tables allow transparent parallelization inside the database.
• C. Parallelizing loads with external tables enables more efficient space management.
• D. External tables can take advantage of storage indexes to speed up data loads.

Answer: C

Explanation: Parallelizing loads with external tables enables a more efficient space management
compared to SQL*Loader, where each individual parallel loader is an independent database sessions with its own transaction.

NEW QUESTION 5
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

Answer: ACDG

NEW QUESTION 6
Consider the following setup:
User A1 belongs to resource group High on Database A. User B2 belongs to resource group Low on Database B. User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%. Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5 Database B: Share=30, limit=10 Database C: 5 shares
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?

• A. Al = 36%, B2=18%, and C3=9%
• B. Al = 33%, B2=33%, and C3=33%
• C. AI = 10%, B2=5%, and C3=20%
• D. Al = 8%, B2=12%, and C3=5%
• E. Al = 5%, B2=10%, and C3=85%

Answer: E

Explanation: IORM setup limits Database A to 5%, and Database B is limited to 10%, while Database C has not IORM limit.
Not that the resource groups are for CPU allocation.

NEW QUESTION 7
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?

Answer: AB

Explanation: B: There are a number of ASM disk group attributes that you can set when creating your disk groups, but the following
are the most important:
* (B) compatible.rdms: Set this to the software version of your RDBMS home.
* au_size: Set this to 4 MB.
* compatible.asm: Set this to the software version of your Grid Infrastructure home.
* cell.smart_scan_capable: Set this to TRUE. If this attribute is set to FALSE, Smart Scan will be
disabled to segments that reside in the disk group.
* disk_repair_time: Leave this defaulted to 3.6 hours unless you’re performing maintenance on a call and know that your outage window will be greater than 3.6 hours.
A:
Once you identify candidate grid disks, use the CREATE DISKGROUP command to create your ASM disk groups.
Here are some of the more important considerations to think about when creating ASM disk groups on Exadata:
* (A) When capacity planning, take your redundancy specification into consideration.
Normal
redundancy will have the effect of reducing your usable storage to half the raw capacity, and
high redundancy will shrink it to a third of your raw disk capacity.
* Simplicity is best on Exadata. Using wild-carded CREATE DISKGROUP syntax not only offers the most terse command syntax, but also ensures your ASM disk groups are spread evenly across your Exadata Storage Server disks.
* Take the time to plan grid disk prefix names and overall grid disk configuration in the context
of your desired ASM disk group design.
* Make sure to set the appropriate compatible.asm and compatible.rdbms attributes when creating ASM disk groups.
* Whenever possible, use a 4 MB extent size when creating disk groups on ASM storage.

NEW QUESTION 8
When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?

• A. Replace the disk and run MegaCLI to rebuild the degenerate mirror.
• B. No manual action is required because Automatic Storage Management (ASM) fast mirror resync is automatic
• C. No manual action is required because ASM rebalancing is automatic.
• D. Replace the disk and manually copy the mirror extents to the new drive.
• E. Run RMAN REPAIR FAILURE.

Answer: C

Explanation: As soon as the Hard Disk failure is noticed by the MS (Management Server) background process on the Cell, it will raise an alert that will also be published to Grid Control, if configured. Immediately, due to Pro-Active Disk Quarantine, the ASM-, Grid- and Celldisks get dropped. ASM rebalancing is triggered. You as the responsible Admin notice the alert and order a replacement Disk resp. use a Spare Disk to plug it into the Cell after you plugged out the damaged one. The Cell can stay online, because the Hard Disks are hot-pluggable.
No further administrative work to be done, typically.

NEW QUESTION 9
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 Exadat
• C. Remote monitoring is the best practice.
• D. EM Agents can communicate to storage cells via SSH.
• E. The Exadata Plug-In for monitoring switches is installed in each EM Agent.
• F. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.

Answer: D

Explanation: All the code required for monitoring the various Oracle Exadata hardware components has been bundled into the Oracle Exadata plug-in that is pushed to the agents running on the Oracle Exadata Compute (or Database) nodes. Once the plug-in is deployed on the compute nodes, the database machine is ready for discovery with Oracle Enterprise Manager.
Incorrect:
Not A: Since agents only run on the compute nodes it is important to assign specific agents to different Oracle Exadata components. Not B: Oracle Exadata Discovery in Oracle Enterprise Manager 12c

NEW QUESTION 10
Identify two ways to reduce the risks associated with the software updates that are performed on a production Exadata system.

• A. Patch all systems at once instead of one at a time.
• B. Test on an Exadata system that is identical to the production system first.
• C. Updating an engineered system has no risk.
• D. Patch on the standby system first by using Data Guard Standby First Patch Apply.
• E. Create a system-wide firmware and software snapshot first.

Answer: BD

Explanation: Patch Installation and Testing Guidelines
1. Review patch documentation
• README and referenced Support Notes
2. (B) Validate in test environment
• Verify patch installation (HealthCheck Note 1070954.1)
• Verify functionality and performance
• Automate
• Define and test fallback plans
3. Apply in production environment
• (D) Data Guard Standby-First Patch Apply
• Monitor for regressions Support Note 1262380.1

NEW QUESTION 11
Consider this CellCLI command:
CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;
Which two statements describe what happens when you execute this command?

• A. It creates one 423 GB grid disk on the first available cell hard disk.
• B. It creates one 423 GB grid disk on each available cell hard disk.
• C. It creates grid disks on the outermost 423 GB that is available on each hard disk.
• D. It creates grid disks on the innermost 423 GB that is available on each hard disk.
• E. It creates an Exadata Smart Flash Cache on all flash drives.

Answer: BC

Explanation: * Example:
CellCLI> create griddisk all harddisk prefix=temp_dg, size=570G
This command will create 12 Griddisks, each of 570G in size from the outer (fastest) sectors of the underlying Harddisks. It fills up the first 2 Celldisks entirely, because they have just 570G space free – the rest is already consumed by the OS partition.

NEW QUESTION 12
Which statement is true about Oracle compression?

• A. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.
• B. A partitioned table can define the use of Advanced Compression or Hybrid Columnar Compression for each partition.
• C. Hybrid Columnar Compression can be defined for a single column.
• D. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.

Answer: CD

Explanation: C: • Tables are organized by column and compressed. This makes it much easier to get similar
values together, which enhances the compression greatly. D: It is recommended that HCC be enabled on tables or partitions with no or infrequent DML operations. If frequent DML operations are planned on a table or partition, then the Oracle Advanced Compression Option is better suited for such data.

NEW QUESTION 13
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(*)
103000
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 (•cell physical IO bytes eligible for predicate offload',
•cell physical IO interconnect bytes',
•cell physical IO bytes saved by storage index',
•cell 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.

Answer: BC

Explanation: * cell physical I/O bytes eligible for predicate offload Number of bytes eligible for predicate offload, an indication of smart scan
* (not D) cell physical I/O bytes saved by storage index Here 0.
Number of bytes saved by a storage index; this is a reflection of how many physical disk I/O bytes (and by proxy, requests) were saved due to a storage index eliminating candidate blocks

NEW QUESTION 14
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.

Answer: BC

Explanation: B: Exadata storage version 11.2.3.2.1 is the minimum version required to use this write back flash cache option.
C: Steps for Enabling Write back flash cache:
First of all, you don’t need the stop CRS or database (This is ROLLING method) ,you can do it cell by cell.
* drop flashcache
* Be sure asmdeactivationoutcome is YES is before disabling grid disk

NEW QUESTION 15
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.
• 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.

Answer: ACF

Explanation: A: CELLSRV (Cell Services) is the primary component of the Exadata software running in the cell
and provides the majority of Exadata storage services. CELLSRV is multi-threaded software that
communicates with the database instance on the database server, and serves blocks to databases
based on the iDB protocol. It provides the advanced SQL offload capabilities, serves Oracle
blocks when SQL offload processing is not possible, and implements the DBRM I/O resource
management functionality to meter out I/O bandwidth to the various databases and consumer groups issuing I/O.
C: The MS is the primary interface to administer, manage and query the status of the Exadata cell. It works in cooperation with the Exadata cell command line interface (CLI) and EM Exadata plug-in, and provides standalone Exadata cell management and configuration. For example, from the cell, CLI commands are issued to configure storage, query I/O statistics and restart the cell. Also supplied is a distributed CLI so commands can be sent to multiple cells to ease management across cells.
F: Restart Server (RS) ensures the ongoing
functioning of the Exadata software and services. It is used to update the Exadata software. It also ensures storage services are started and running, and services are restarted when required.

NEW QUESTION 16
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

Answer: AB

Explanation: A: Oracle Exadata Storage Expansion Rack X4-2 enables you to grow the Oracle Exadata storage capacity and bandwidth of Oracle Exadata Database Machine X4- 2 and X3-8 and Oracle SuperCluster. It is designed for database deployments that require very large amounts of data, including historical or archive data; backups and archives of Oracle Exadata Database Machine data; documents; images; file and XML data; LOB's; and other large unstructured data.

NEW QUESTION 17
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

Answer: D

Explanation: #1: Check for updates frequently.
#2: Execute before & after system changes.
#3: Make part of regular planned maintenance

NEW QUESTION 18
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.

Answer: C

Explanation: Incorrect:
Not B: Only on database servers.
not D: Exadata Storage Servers have dual 40 Gigabit InfiniBand links that provide connectivity
many times faster than traditional storage or server networks.