Oracle 1z0-485 Exam Practice Questions (P. 3)
- Full Access (71 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #11
Which two attributes describe key benefits of the InfiniBand network?
- AAll Exadata database servers have a direct path link to each Exadata Storage Server.
- BCell-to-cell communication uses Reliable Datagram Sockets (RDS) over InfiniBand to achieve low latency.
- CExpanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.
- DEach InfiniBand link provides 10 Gigabits of bandwidth.
- EOracle's interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.
Correct Answer:
CE
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
CE
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
send
light_mode
delete
Question #12
Identify three Exadata Storage Server software processes and their purpose?
- ACELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing offload.
- BCELLSRV: The Cell Server is responsible for balancing workload to other storage servers.
- CMS: The Management Server is responsible for storage cell management and configuration.
- DMS: The Management Server is responsible for starting a local Enterprise Manager agent.
- ERS: The Restart Server is responsible for Automatic Storage Management (ASM) instance restart.
- FRS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.
Correct Answer:
ACF
References:
ACF
References:
send
light_mode
delete
Question #13
Which two statements are true about troubleshooting failed patching activities?
- ADependency issues found during yum updates require rolling back to a previous release before retrying.
- BBundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.
- CFailed OS patches on database servers can be rolled back.
- DFailed storage cell patches are rolled back to the previous release automatically.
- EDatabase server OS updates can be rolled back using opatch auto -rollback.
- FDependency issues found during yum updates should be ignored using the force option.
Correct Answer:
AD
AD
send
light_mode
delete
Question #14
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?
- AINSERT
- Binsert with an append hint
- CUPDATE
- DCREATE TABLE AS SELECT
Correct Answer:
BD
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.
BD
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.
send
light_mode
delete
Question #15
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?
- Aadding a High Capacity Storage expansion rack
- Bexpanding the Exadata rack from a Half Rack to a Full Rack
- Cmoving underutilized grid disks from the RECO diskgroup to DATA
- Dadding a ZFS storage appliance
- Eadding a High Performance Storage expansion rack
Correct Answer:
BE
BE
send
light_mode
delete
All Pages