1z0-338 by Oracle Valid Free Exam Practice Test

Question 1

Which statement is true about Exadata Storage Servers?

A. Exadata uses network affinity to determine which storage server data is written. B. Redundancy for the user data that is stored in a database that is running on Exadata is achieved with RAID5. C. Exadata requires a running database instance on all storage servers and database servers. D. Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet. E. Exadata Storage Servers automatically delete old diagnostic and metric files.

Correct Answer: E

Question 2

When backing up a storage cell, what is actually being backed up?

A. the contents of the CELLBOT USB flash drive B. the Linux RPM that is used to deploy the storage cell software C. the first two disks in a storage cell that contain the Linux operating system D. all the disk headers and storage indexes in the storage cell

Correct Answer: D

Question 3

Which statement is true about Enterprise Manager 12c for Exadata?

A. EM Agents should not be installed on Exadata. Remote monitoring is the best practice. B. EM Agents can communicate to storage cells via SSH. C. EM Agents are installed on each database and storage node. D. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP. E. The Exadata Plug-In for monitoring switches is installed in each EM Agent.

Correct Answer: B

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

Question 4

In which three cases would RMAN backup and recovery be a good strategy for migrating to the cloud? (Choose three.)

A. when you are concerned about the endian nature of the database and want to perform conversions from different formats B. when moving an Oracle Data Guard physical standby database to the cloud C. when the source platform is little endian, character set is AL32UTF8, and the architecture is multitenant D. when a physical migration approach is feasible and physical database reorganization is no necessary E. when you are migrating a database from a different database version and it might have a different character set

Correct Answer: B,D,E

Question 5

Which three mandatory tasks must be performed when configuring the Auto Service Request (ASR) Manager? (Choose three.)

A. verifying the ASR configuration B. installing the ASR software on each database server C. activating a node on the ASR Manager D. registering the ASR Manager E. setting up ASR SNMP traps in Enterprise Manager

Correct Answer: A,C,D

Question 6

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, 5, 1, 7, 6, 2 and 4 C. 3. 6, 1, 7, 2, 5, and 4 D. 3, 7, 5, 2, 1, 6, and 4 E. 3, 5, 2, 1, 6, 7, and 4

Correct Answer: E

Question 7

Oracle ILOM is an embedded service processor in many Oracle Exadata Database Machine components.
What are three features provided by Oracle ILOM? (Choose three.)

A. web-based, secure shell, IPMI, and SNMP access for out-of-band management B. storage cell monitoring through the CeIICLI interface C. listener access through the back-end management interface for MySQL and SQL Developer D. role-based security access to limit functions to individual user administration tasks E. secure access for lights out management of the database and storage servers

Correct Answer: A,D,E

Question 8

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

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

Correct Answer: B,C

Question 9

Which statement is true about instance caging setup?

A. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected. B. Instance caging is the right approach to make sure that database instances are not stealin memory from one another. C. For a system with 16 threads, the sum ofcpu_countfor all databases should not be higher than 32 to prevent oversubscribing. D. The initialization parameterresource_manager_planshould be set. E. Database instances need to be restarted to make changes tocpu_counteffective.

Correct Answer: D

Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials - 1z0-338 Exam Practice Test