The Secret Of Oracle 1z0-485 Free Dumps

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

Answer: AE

Explanation:
* Oracle has shifted the strategy to patching the exadata in 11.2.3.2.0 onwards to using Yum as the method of patching.
* Database servers are patched using yum; there is a yum channel for each Exadata image version. Recently, this functionality replaced the “minimal pack.”
* In the README for each storage server patch, Oracle provides detailed rollback instructions that are to be followed in the event of a patch failure.

NEW QUESTION 2
Identify the three values to which the cell_flash_cache attribute can be set.

• A. read
• B. WRITE
• C. KEEP
• D. DEFAULT
• E. NONE

Answer: CDE

Explanation:
There are three values the CELL_FLASH_CACHE attribute can be set to.
DEFAULT specifies the cache used for a DEFAULT object is automatically managed as described in the previous section. NONE specifies that the object will never be cached. KEEP specifies the object should
be kept in cache.
Note: The CELL_FLASH_CACHE can be assigned to a database table, index, partition and LOB column.

NEW QUESTION 3
Which Exadata feature uses Flash as a parallel write cache to Disk Controller Cache?

• A. Exadata DRAM
• B. InfiniBand network cache
• C. high performance SAS disks
• D. Smart Flash Log
• E. Hybrid Columnar Compression

Answer: D

Explanation:
Smart Flash Logging takes advantage of the flash memory in Exadata storage to speed up log writes.

NEW QUESTION 4
In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?

• A. Enable Smart Flash Log.
• B. Execute alter table … cell_flash_cache=keep on heavily scanned tables.
• C. Enable Write Back Flash Cache.
• D. Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

Answer: B

Explanation:
In earlier releases, database administrators had to mark an object as KEEP to have it cached in flash cache for large scan workloads. This feature primarily benefits table scan intensive workloads such as Data Warehouses and Data Marts. Random I/Os such as those performed for Online Transactional Processing (OLTP)
continue to be cached in the flash cache the same way as in earlier releases.
Note: With the Exadata Storage Server Software 11.2.3.3.0 and above, the Exadata Smart Flash Cache
software automatically caches objects read, in large table scans, in the flash cache based on how
frequently the objects are read. Previously, the default behavior was to bypass the flash cache for
such large sequential scans.

NEW QUESTION 5
A control file tracks the physical components of a database. It is the root file that the database uses to find all the other files used by the database. Because of the importance of the control file, Oracle recommends that the control file be ?

• A. size constrained, to prevent size overruns
• B. multiplexed, or have multiple identical copies
• C. stored on an HA USB Drive, to ensure that it does not get overwritten
• D. managed by EM12c, to ensure proper maintenance

Answer: D

NEW QUESTION 6
After migrating from legacy disk-based configuration, which three approaches would you use to evaluate the efficiency of Exadata Flash Cache?

• A. Review the Flash Hit rate via cellcli metrics.
• B. Compare Optimized Physical Reads and Total Read Requests in Automatic Workload Repository (AWR).
• C. Review the IOSTAT data that is gathered from each compute node by OS Watcher.
• D. Evaluate the Smart Flash Logging efficiency metrics via CellCLI.
• E. Check I/O latency on large I/O to Temp in AWR.

Answer: ACD

Explanation:
A: You wish to determine which database objects are currently cached in Smart Flash Cache.
Use the list flashcachecontent CellCLI command to report the objects
currently stored in Smart Flash Cache and map these to database object names. Using dcli or cellcli from a storage cell, run the following command: [oracle@cm01dbm01 ~]$ dcli -g ./cell_group cellcli -e list flashcachecontent \
> attributes dbUniqueName,hitCount,missCount,cachedSize,objectNumber cm01cel01: EDW 0 2 98304 3
cm01cel01: DWPRD 0 0 57344 8
cm01cel01: VISY 0 0 8192 8
cm01cel01: EDW 9 15 729088 18
cm01cel01: DWPRD 0 0 16384 18
Output omitted for brevity
C: IOSTAT can be used to get both DISK and FLASH performance data.
D: Using Storage Cell Metrics to Measure IORM (Exadata IO Resource Manager) Performance Impact
Exadata provides a number of performance metrics for each of the Category, Interdatabase, and Intradatabase IORM types. You can find these metric and their descriptions using
CellCLI commands.
With a representative database workload running and after your IORM plan has been created, use the list metriccurrent or list metrichistory CellCLI command to report your current or historical IORM metrics.

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

Answer: BD

Explanation:
To maximize storage savings with Hybrid Columnar Compression, data must be loaded using data warehouse bulk loading techniques. Examples of bulk load operations commonly used in data warehouse environments are:
* Insert statements with the APPEND hint
* Parallel DML
* Direct Path SQL*LDR
* Create Table as Select (CTAS)
Incorrect:
Not A, Not C: DML operations (INSERT/UPDATE) against a Hybrid Columnar Compressed table/partition can reduce the overall compression savings over time since data INSERTED/UPDATED via DML operations will not be compressed to the same ratio as data that is bulk loaded.

NEW QUESTION 9
What are the three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Install on Exadata Engineered System.
• B. Provide individual x86 64-Bit gateway hardware.
• C. Install in Oracle Virtual Machine with required hardware.
• D. Install on Oracle Database Appliance.
• E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Answer: ACE

Explanation:
Oracle provides a flexible model for deployment of the Oracle Advanced Support Gateway via no charge software that can be
installed in three configurations:
1. On x86 customer provided servers;
2. On x86 servers purchased from Oracle;
3. Installed on Oracle Exalogic Elastic Cloud or Oracle SuperCluster systems.
Note:
Oracle Platinum Services provides enhanced support for high availability and performance to Oracle Premier Support customers running certified configurations of Oracle Exadata Database Machine, Oracle Exalogic Elastic Cloud, or Oracle SuperCluster, at no additional cost.

NEW QUESTION 10
A customer has three databases named CC. FIN, and DW. The CC database is for their CallCenter. Even a slight decrease in the response time of the database would mean more people "on hold" in their data center. The orders received through the CallCenter are stored in the Finance (FIN) database. Both databases, CC and FIN, serve as sources for the Data Warehouse (DW) database. All databases use the same Automatic Storage Management (ASM) diskgroup and therefore, the same physical disks on Exadata storage. The customer wants to dynamically control the resources that are available for the CallCenter database because this has direct impact on their operations?
Which option should be implemented?

• A. DBRM on the CC database
• B. DBRM on all the databases
• C. IORM, because DBRM cannot be changed for an existing session
• D. IORM and DBRM

Answer: B

Explanation:
Using the Database Resource Manager, you can:
Distribute available processing resources by allocating percentages of CPU time to different users and applications. In a data warehouse, a higher percentage may be given to ROLAP (relational on-line analytical processing) applications than to batch jobs.

NEW QUESTION 11
Which two statements are true about Exadata memory capabilities?

• A. X3-8 can be purchased in a Half Rack configuration with 2 TB of memory.
• B. X3-2 memory can be expanded to 512 GB per node from 256 GB.
• C. X3-2 memory can be upgraded to use Flash in the compute nodes.
• D. X3-8 memory is fixed at 4 TB per a Rack.
• E. X3-2 can be purchased in a Half Rack configuration with 256 GB per node.

Answer: DE

Explanation:
D: ORACLE EXADATA DATABASE MACHINE X3-8 features include: 160 CPU cores and 4 TB of memory for database processing
E: Database servers X3-2
A third generation was announced in 2012. Each Database Server with 2 x Eight-Core Intel Xeon E5-2690 Processors (2.9 GHz)
128 GB Memory (expandable to 256GB)

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

Answer: D

Explanation:
The storage cells in Exadata Database Machine are managed via two tools called CellCLI and DCLI.

NEW QUESTION 13
CORRECT TEXT
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.

Answer: CD

Explanation:
Databases on Exadata use ASM. Incorrect:
Not A: 3 network choices: 10 Gb/s Ethernet
40 Gb/s InfiniBand
1 Gb/s Ethernet (No fibre channel)

NEW QUESTION 14
Which two migration will result in the least down time for a physical or logical migration of a database with active users during the migration?

• A. using GoldenGate
• B. using SQL Developer migration tools
• C. using Data Guard Physical Standby
• D. using cross-platform transportable tablespaces
• E. using incremental cross-platform RMAN restore

Answer: AE

Explanation:
A: Zero Downtime Migration to Oracle Exadata using Oracle GoldenGate
– Reduce downtime for any method
– Zero data loss fallback
– Phased migration
E: Cross Platform Incremental Backups
– Reduce downtime for Transportable Tablespaces

NEW QUESTION 15
Your customer has purchased their brand new Exadata Database Machine X3-2 Full rack to achieve 20-TB-per-hour backups on their 300 TB database. You have been called to determine why they are not able to achieve even half that rate. Use the information in the image below to identify two reasons their backups are still slow.

• A. The Media Server to Tape Library transfer is causing a bottleneck.
• B. The number of tape drives is causing a bottleneck.
• C. Exadata backups are being performed using RMAN over the 10 Gigabit Ethernet network.
• D. The number of database servers is causing a bottleneck.

Answer: BC

Explanation:
The following bottlenecks will be reached first if using InfiniBand fabric to media server:
1. Media server to tape library SAN transfer rate
2. Number of tape drives

NEW QUESTION 16
Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

• A. Remove the doors of the 1/8th rack.Add the new servers.Cable the Database Servers in the rack.Cable the Exadata Storage Servers in the rack.Close the rack.
• B. Activate all cores by using a software command.Activate all hard drives and flash drives.Create the grid disks.Expand the Oracle ASM diskgroups.Review the new configuration.
• C. Remove the doors of the 1/8th rack.Add an additional Sun Datacenter InfiniBand Switch.Add the new servers.Cable the Database Servers in the rack.Cable the Exadata Storage Servers in the rack.Close the rack.Configure the new hardware.
• D. Activate all cores by using a software command.Activate all hard drives and flash drives.

Answer: B

Explanation:
Not A: no need to remove doors. Not C: No additional Infiband Switch needed. Note:
* Database Machine Upgrades

* Database Machine Components and Upgradeability

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

Answer: BD

Explanation:
IORM is similar to Oracle Database Resource Manager (DBRM) in that it provides a means for controlling allocation of system resources. Where DBRM’s primary goals are to control CPU resources, limit the degree of parallelism, and impose resource consumption constraints for different types of sessions within an Oracle database, IORM’s goal is to govern I/O resource allocations between databases on a shared storage infrastructure. When consolidating Oracle databases on Exadata, IORM can be used to ensure that I/O is controlled between databases as well as classifications of consumes that utilize the same ASM disk infrastructure and, as such, provide resource control capabilities beyond what DBRM provides within a database.
/ Using the Database Resource Manager, you can:
* Guarantee certain users a minimum amount of processing resources regardless of the load on the system and the number of users
* Distribute available processing resources by allocating percentages of CPU time to different users and applications. In a data warehouse, a higher percentage may be given to ROLAP (relational on-line analytical processing) applications than to batch jobs.
* Limit the degree of parallelism of any operation performed by members of a group of users etc

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

Answer: CD

Explanation:
Incorrect:
Not A: The InfiniBand switches use an OpenSMInfiniBand subnet manager to manage the switch configuration.

NEW QUESTION 19
If your customer wants to save storage space by compressing tables that are read frequently but rarely updated, which compression technique would you recommend?

• A. OLTP
• B. ARCHIVE HIGH
• C. QUERY HIGH
• D. ARCHIVE LOW
• E. BASIC

Answer: B

Explanation:
Compression Comparisons

NEW QUESTION 20
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 21
......