Approved 1z0-485 Dumps Questions 2021

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

Answer: BCE

Explanation: C: Exadata provides a way for you to create your own CELLBOOT USB. All you have to is plug-in a USB disk which should be at least 1 GB and run the tool:
$ /opt/oracle.SupportTools/make_cellboot_usb
Exadata turns your USB disk into a bootable disk of active image of your system.

NEW QUESTION 2
What are three ways to be informed of an Exadata Storage Server disk failure?

• A. review of the output of list alerthistory
• B. review of the output of select status from vSdatafile
• C. review of the ILOM log
• D. alert notifications through email when SMTP notification is configured
• E. alert notifications in the Enterprise Manager Exadata Plug-In
• F. review of database server iostat output

Answer: ADE

Explanation: A: A disk status change would be associated with an entry in the storage cell alerthistory.
D: The Cell Alert Delivery Configuration Worksheet allows you to provide SMTP details to allow for e-mail communication of various cell alerts and failures.
Incorrect:
Not F: Use the iostat command to report statistics about disk input and output, and to produce measures of throughput, utilization, queue lengths, transaction rates, and service time.

NEW QUESTION 3
Which two statements appropriately describe the backup and recovery procedures on Exadata?

• A. Cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.
• B. Data stored in a database is backed up and restored by using CellCLI commands.
• C. Database server software backup is automatic and recovery is accomplished by using a rescue procedure.
• D. Data stored in a database is backed up and restored by using RMAN commands.
• E. Cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.

Answer: AD

Explanation: A: Your Exadata Storage Servers do not need to be backed up; Exadata automatically backs these up using a self-maintained internal USB drive.
D: Backup your Oracle databases using Oracle RMAN

NEW QUESTION 4
Which table compression technique will not work on Exadata without licensing the Oracle Advanced Compression Option?

• A. COMPRESS
• B. COMPRESS BASIC
• C. COMPRESS FOR OLTP
• D. COMPRESS FOR QUERY
• E. COMPRESS FOR ARCHIVE

Answer: C

Explanation: OLTP Table Compression is a part of the Oracle Advanced Compression option, which requires a license in addition to the Enterprise Edition.

NEW QUESTION 5
Which statement is true about instance caging setup?

• A. Instance caging is the right approach to make sure that database instances are not stealing memory from each other.
• B. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
• C. Database instances need to be restarted to make changes to cpu_count effective.
• D. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing
• E. The init.org parameter resource_manager_plan should be set.

Answer: D

Explanation: * In 11.2G there is new option called “Instance Caging” which enables to limit number of CPUs which can be seen/used by a database.
* Enabling Instance Caging
1. Manually set dynamic parameter cpu_count on instance level. As default this parameter is set to maximum number of cpu available on a hosts.
alter system set cpu_count=2;
2. Enable any resource manager plan that manages CPU. Most easy is to turn on default Oracle plan DEFAULT_PLAN.
alter system set resource_manager_plan=DEFAULT_PLAN;
* Provisioning CPU
There are generally 2 ways to distribute your CPU between databases
Partitioning – sum of all CPUs assigned to all your databases equals number of CPUs on a host. Databases don’t interfere with each other.
Over-provisioning – sum of all CPUs assigned to all your databases is higher that number of CPUs on a host. Databases can impact on each other performance.

NEW QUESTION 6
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 7
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;

Answer: A

Explanation: ASMDeactivationOutcome – recall that grid disks can be deactivated, which is effectively taking them offline. Since ASM mirroring ensures that the data is located on another disk, making this disk offline does not lose data. However, if the mirror is offline, or is not present, then making this grid disk offline will result in loss of data. This attribute shows whether the grid disk can be deactivated without loss of data. A value of “Yes” indicates you can deactivate this grid disk without data loss.
CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus DBFS_DG_CD_02_cell01 Yes ONLINE
DBFS_DG_CD_03_cell01 Yes ONLINE DBFS_DG_CD_04_cell01 Yes ONLINE
… output truncated …

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
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 10
Consider the following software changes that are performed manually on a Linux server:
1. Changes for Linux kernel firewall configuration
2. Changes for custom performance monitoring tools
3. Changes for security scan tools
4. Changes for Linux system performance optimization
Which of the software changes listed are permitted on Exadata Storage Servers?

• A. 1, 2, 3, and 4
• B. only 3 '
• C. none
• D. only 2
• E. only 1 and 2
• F. only 2 and 3

Answer: E

Explanation: 1: The Storage Server Patch is responsible for keeping our cell nodes always up-to-date, fixing possible problems, and this patch includes different component patches, like kernel patches, firmware, operation system, etc… for the Storage Server.
Incorrect:
3,4: security scan tools changes and Linux system performance optimization changes would be on the database server.

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

Answer: A

Explanation: To ensure redundancy during a rolling upgrade of the Exadata Storage Server Software, MAA recommends ASM high redundancy disk groups.

NEW QUESTION 12
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 13
How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?

• A. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.
• B. Using partition pruning can force the optimizer to use that method instead of Smart Sca
• C. Partitioning in Exadata should be used wisely,
• D. Partition pruning is not a supported option in the 11gR2 database code that runs on an Exadata Machine, due to issues with Cost Based Optimizer plans.
• E. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.
• F. Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.

Answer: A

Explanation: Partition pruning allows you to reduce a 5TB I/O operation to a much smaller I/O operation and therefore much faster return of the information.

NEW QUESTION 14
Which two attributes describe key benefits of the InfiniBand network?

• A. All Exadata database servers have a direct path link to each Exadata Storage Server.
• B. Cell-to-cell communication uses Reliable Datagram Sockets (RDS) over InfiniBand to achieve low latency.
• C. Expanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.
• D. Each InfiniBand link provides 10 Gigabits of bandwidth.
• E. Oracle's interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.

Answer: CE

Explanation: C: Oracle Exadata is architected to scale-out to any level of performance. To achieve higher performance and greater storage capacity, additional database servers and Exadata cells are added to the configuration – e.g., Half Rack to Full Rack upgrade. As more Exadata cells are added to the configuration, storage capacity and I/O performance increases near linearly.
E: Oracle's interconnect protocol uses direct data placement (DMA – direct memory access) to ensure very low CPU overhead by directly moving data from the wire to database buffers with no extra data copies being made. The InfiniBand network has the flexibility of a LAN network, with the efficiency of a SAN.
Incorrect:
Not A: The architecture of the Exadata solution includes components on the database server and in the Exadata cell. The software architecture for a Quarter Rack configuration is shown below.


Not B: No cell-to-cell communication is ever done or required in an Exadata configuration. Not D: Each InfiniBand link provides 40 Gigabits of bandwidth –

NEW QUESTION 15
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 16
Whicr the following software changes that are performed manually on a Linuatches?

• A. owner's guide
• B. Patch database in MyOracle Support
• C. MyOracle Support note 888828.1
• D. MyOracle Support for database patches, ULN for OS patches, and Sun Support for Server and InfiniBand patches.

Answer: B

Explanation: Before starting, we would like to share and note here two documents from My Oracle Support, aka metalink. These notes must be the first place that you need to go to review before patching the Exadata environment.
* (B) Database Machine and Exadata Storage Server 11g Release 2 (11.2) Supported Versions (Doc ID. 888828.1)
- This is for the second and third generation (V2 and X2) for Oracle Exadata, using Sun hardware.
* Database Machine and Exadata Storage Server 11g Release 1 (11.1) Supported Versions (Doc ID. 835032.1)
* - This is for the first generation (V1) for Oracle Exadata, using HP hardware.

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

Answer: C

Explanation: Exadata storage cells include Oracle Hardware Assisted Resilient Data (HARD) to provide a
unique level of validation for Oracle block data structures such as data block address, checksum.
and magic numbers prior to allowing a write to physical disks. HARD validation with Exadata is
automatic (setting DB_BLOCK_CHECKSUM is required to enable checksum validation). The
HARD checks transparently handle all cases including Oracle ASM disk rebalance operations and disk failures.
Incorrect:
Not A: The checksum is used to validate that a block is not physically corrupt, detecting corruptions caused by underlying disks, storage systems, or I/O systems. Checksums do not ensure logical consistency of the block contents.
Not B: MAA recommends that you set DB_BLOCK_CHECKING=MEDIUM or FULL on the physical standby as a minimum practice to prevent the standby from various logical block corruptions.
Not D: The recommendation is:
On the primary database: DB_LOST_WRITE_PROTECT=TYPICAL (default TYPICAL on Exadata) On the Data Guard Physical Standby Database: DB_LOST_WRITE_PROTECT=TYPICAL Not E: Protection from a broad range of, but not all disasters
While not a full disaster recovery (DR) solution, an Extended Distance
Oracle RAC or Oracle RAC One Node deployment will provide protection from a broad range of
disasters. For a full DR protection Oracle recommends deploying an Oracle RAC together with a local and a remote Oracle Data Guard setup as described in the Maximum Availability Architecture (MAA).