1Z0-338 Online Practice Questions and Answers

Which statement is true about Exadata Storage Servers?

A. Exadata Storage Servers automatically delete old diagnostic and metric files.

B. Exadata requires a running database instance on all storage servers and database servers.

C. Redundancy for the user data that is 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.

Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)

A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

B. Install in Oracle Virtual Machine with required hardware.

C. Install on Exadata Engineered System.

D. Provide individual x86 64-Bit gateway hardware.

E. Install on Oracle Database Appliance.

Which statement explains the difference between Normal and High redundancy ASM failure groups?

A. Normal redundancy protects the DATA diskgroup, whereas High redundancy protects the RECO diskgroup.

B. Normal redundancy (best practice) provides protection against two simultaneous disk failures, whereas High redundancy provides protection against a single disk failure or an entire storage server failure.

C. High redundancy gives more usable storage, whereas Normal redundancy provides better I/O performance.

D. Normal redundancy protects from disk failure when a cell is offline or being updated, whereas High redundancy protects the system when all the cells are offline.

E. Normal redundancy tolerates a single cell failure, whereas High redundancy tolerates a two-cell failure.

Identify the two choices a customer must make that impact diskgroup creation when the customer wants to have only a DATA diskgroup and a RECO diskgroup? (Choose two.)

A. the number of databases that will run on the cluster

B. the OS that will be run

C. the level of redundancy required

D. the ratio to use to split the available and usable storage between DATA and RECO

What are three Oracle recommended methods for migrating to Exadata with the least amount of down time? (Choose three.)

A. CTAS over a database link

B. Expdp and Impdp

C. Cross Platform Incremental Backup and Restore

D. logical migration by using RMAN and GoldenGate

E. physical migration by using Data Guard

Which three features are unique to Exadata Storage? (Choose three.)

A. grid disks with default AU allocation sizes of 1 MB

B. usage of flash technology to cache recently used data

C. prioritization of disk I/Os based on the database

D. prioritization of OLTP I/Os over scan I/Os

E. database storage flash cache space allocation guarantees and limits

When provisioning Oracle Exadata Cloud Service, the wizard requests information about backup and restore options.

Which two options are provided to customers? (Choose two.)

A. backup directly to a Storage Cloud Software Appliance

B. backup to Oracle Replication Cloud

C. backup to Exadata storage (if this option was chosen during configuration)

D. cloud storage through Oracle Database Backup Cloud Service E. backup to Oracle Tape Library Cloud

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, 5, 1, 7, 6, 2 and 4

B. 3, 7, 1, 5, 6, 2, and 4

C. 3, 7, 5, 2, 1, 6, and 4

D. 3. 6, 1, 7, 2, 5, and 4

E. 3, 5, 2, 1, 6, 7, and 4

Identify three default ways to connect to Oracle Exadata Cloud Service that is running on Oracle Public Cloud.

A. using the UNIX-based telnet command

B. using SQL *Net from clients that are running on a compute cloud service

C. using SSH for administrative purposes

D. using Oracle Net from on-premise applications

E. using the Remote Desktop client and the RDP protocol

Put the full backup and the correct order, if your customer wants to migrate to Exadata.

A) On Exadata, start the database in nonmount mode.

B) Restore the control file.

C) Restrict user and application access to the database.

D) Make the backup files accessible from the Exadata system.

E) Restore the database.

F) Mount the database.

G) Recover the database.

H) Take a full database backup.

A. C, H, D, A, B, F, E, G

B. C, H, D, A, B, F, G, E

C. C, H, D, A, E, F, B, G

D. A, B, C, D, E, F, G, H