Oracle 1z0-485 Free Practice Questions

NEW QUESTION 1
Exadata Database Machine offers an Intelligent Platform Management Interface for the various components in the Exadata product. Which option is true?

• A. IPMI can be used to remotely start and stop servers.
• B. IPMI can be used to remotely log in to the operating system.
• C. IPMI commands can be executed by using SNMP traps.
• D. IPMI settings can be secured by backing up the Oracle Linux installation on the storage system.

Answer: A

Explanation:
IPMI – short for Intelligent Platform Management Interface - is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It’s not an Exadata command but rather a general Linux one.
To power on a cell or database server, issue this from another server:
# ipmitool -H prolcel01-ilom -U root chassis power on
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now

NEW QUESTION 2
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 3
Which statement is true about the patching features provided in Platinum Services?

• A. Patching services are available for the full software stack up to twice per year.
• B. Patching support includes Exadata, Exalogic, and Database Appliance.
• C. Rolling window and complete down time approaches are two options to patching.
• D. Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

Answer: D

Explanation:
* Patch Deployment: Oracle Platinum Services also includes patching services in which Oracle
applies patches to covered systems four times (not A) per year via the Oracle Advanced Support
Gateway. We work collaboratively with customers to assess, analyze, plan and deploy updates
and patches to mitigate risks and complications. Through this continuous improvement, customers can experience greater system performance, availability, and security.
* not B: 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 4
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 5
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.

NEW QUESTION 6
Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.

• A. DBFS in an Exadata environment is faster than an NFS mount system because of the Smart Scan performance gains.
• B. Tens of thousands of files are the perfect use case for DBFS on Exadata.
• C. DBFS offers tremendous I/O bandwidth.

Answer: B

NEW QUESTION 7
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 8
Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata?

• A. Auto DOP is an exclusive feature in Exadata, which allows the database optimizer to evaluate each statement and run it in parallel without special hints.
• B. Auto DOP is disabled by default and must be enabled before SQL statements can take advantage of its features.
• C. Auto DOP is enabled by default on Oracle 11gR2, allowing full use of its features.
• D. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on the table's block counts.
• E. SQL statements that take advantage of Auto DOP am be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.

Answer: BDE

Explanation:
B (not c): To enable the features in 11g Release 2, use the parallel_degree_policy parameter (by default this stuff is off - parameter is set to manual). For Auto DOP, setting this to limited is sufficient. If you want more functionality (in-memory parallel processing and parallel statement queuing parallel_degree_policy should be set to auto).
Incorrect: Not A:
* What if you don’t have Exadata? Chances are that if your system is large enough to warrant Auto DOP, it is similar enough to Exadata to behave nicely with this number.
* Auto DOP is only useful in systems with enough CPUs and disks to make concurrent parallel processing feasible. It was designed mostly for Exadata, or for systems of similar size. 48 CPUs and 84 disks sound like a nice start

NEW QUESTION 9
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 10
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 11
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 12
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 13
You are conceh is the best location to point your customer to, for finding the latest Exadata prned about how recovery from a failed Exadata Storage Server would work. Which statement is true about the Exadata CELLBOOT USB?

• A. Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.
• B. Regular Exadata Storage Server patches make sure that the internal USB is updated so that it can be used for recovery.
• C. Changes to network configuration files are possible without using ipconf.pl as long as all relevant files are updated.
• D. Some space from the CELLBOOT USB is used for cache metadata when write back flash cache is enabled.
• E. Each patch that is performed on Exadata storage servers requires manual resync of the CELLBOOT USB.

Answer: AC

Explanation:
A (not B, not E): Oracle automatically performs backups of the operating system and cell software on each Exadata Storage Server. The contents of the system volumes are automatically backed up and require no Oracle DMA intervention or operational processes. Oracle assumes responsibility for backing up the critical files of the storage cells to an internal USB drive called the CELLBOOT USB Flash Drive.
C:
Note: The ipconf utility is installed in /opt/oracle.cellos on both the Exadata Storage Servers and Compute Nodes and is symbolically linked to /usr/local/bin/ipconf. ipconf is called at system startup time to set and validate your Exadata server network information.

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

Answer: AC

Explanation:
In addition to gaining shell access via SSH to manage your Exadata servers, you can also access them from the Integrated Lights Out Management (ILOM) console or KVM console.
and should typically not require modifications unless you have changed network information inside your database
machine.
Note: A KVM switch (with KVM being an abbreviation for "keyboard, video and mouse") is a hardware device that allows a user to control multiple computers from one or more[1] keyboard, video monitor and mouse. Although multiple computers are connected to the KVM, typically a smaller number of computers can be controlled at any given time

NEW QUESTION 16
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 17
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 18
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 19
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 20
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 21
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 22
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 23
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 24
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.

Answer: BD

Explanation:
B:
* Making a grid disk inactive effectively offlines its associated ASM disk.
CellCLI> alter griddisk PRORECO_CD_11_cell01 inactive GridDisk PRORECO_CD_11_cell01 successfully altered
* The command will wait until the ASM disk becomes offline. If you want the prompt to come back immediately without waiting, you can use nowait clause.
CellCLI> alter griddisk PRORECO_CD_11_cell01 inactive nowait You can make it active again:
CellCLI> alter griddisk PRORECO_CD_11_cell01 active GridDisk PRORECO_CD_11_cell01 successfully altered Incorrect:
not E: CellCLI> list physicaldisk detail output include:
physicalSerial: XXXXXX

NEW QUESTION 25
......