Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials - 1z1-338 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which statement is true about Oracle compression?

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

Discussion 0

Correct Answer: C Vote an answer

Question 2

Your customer has encountered some system disk issues and has been told that a
"storage cell rescue procedure" must be implemented.
What will this procedure accomplish?

A. It will perform a database server disk replacement. B. It will perform a predictive disk failure replacement for cell disks. C. It will perform a complete storage server hardware replacement. D. It will perform cell flash cache failure replacement. E. It will recover the Exadata system volumes by using the internal USB flash disk.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 3

Storage indexes are unique to Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:
1 . The Exadata cell services software conducts I/O requests on 1 MB storage regions.
2 . cellsrv checks the high and low values, and determines that the storage region does not contain any values that meet the predicate.
3. The database is started.
4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.
5. A query is issued against the MYOBJ_CTRL table that has a predicate
OBJECT_ID=1500.
6. A subsequent query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.
7. The MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the l/O request.

A. 3, 7, 1, 5, 6, 2, and 4 B. 3, 7, 5, 2, 1, 6, and 4 C. 3, 5, 2, 1, 6, 7, and 4 D. 3, 5, 1, 7, 6, 2 and 4 E. 3. 6, 1, 7, 2, 5, and 4

Discussion 0

Correct Answer: C Vote an answer

Question 4

Your customer needs to ensure that their data is available on the Exadata machine during patches. The customer wants to be able to patch one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?

A. Standard B. Extreme C. High D. Normal E. External

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B.
Which architecture would you suggest to solve this deployment issue?

A. Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B. B. Define the split by setting up database services that are specific to department A and department B. C. Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest. D. Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.

Discussion 0

Correct Answer: B Vote an answer

Question 6

What type of SRs does the ASR Manager generate for Exadata?

A. hardware assets B. backup and restore failures C. data entry errors D. software assets E. operating system components

Discussion 0

Correct Answer: D Vote an answer

Question 7

Which two statements are true about troubleshooting failed patching activities? (Choose two.)

A. Failed storage cell patches are rolled back to the previous release automatically. B. Dependency issues found duringyumupdates should be ignored by using theforceoption. C. Bundle patches applied by usingopatch autocannot roll back only the database or the grid infrastructure home. D. Dependency issues that are found duringyumupdates require rolling back to a previous release before retrying. E. Failed OS patches on database servers can be rolled back. F. Database server OS updates can be rolled back by usingopatch auto -rollback.

Discussion 0

Correct Answer: B,F Vote an answer

Question 8

What happens in an Exadata Database Machine when the DUPLICATE sub-clause of the INMEMORY attribute is specified?

A. The In-Memory Compression Unit will have a mirrored copy placed on every other node in the RAC cluster. B. Each In-Memory Compression Unit in the IM column store will have a mirrored copy placed on another node in the RAC cluster. C. The command creates an in-memory snapshot for write_only access. D. The command allows the current instance to exceed DRAM limits and expand across memory, flash, and disk. E. The DUPLICATE sub-clause enables parallel execution NUMA support.

Discussion 0

Correct Answer: B Vote an answer

Question 9

The Exadata architecture is divided into two specific tiers: the database tier and the storage tier.
What protocol do these tiers use to communicate with each other?

A. InfiniBand protocol B. Secure Shell protocol C. Fibre Channel protocol D. Ethernet protocol E. iDB - Intelligent Database Protocol

Discussion 0

Correct Answer: E Vote an answer