1Z0-338 Online Practice Questions and Answers

A cloud user is assigned the Service Administrator role. Which cloud actions can this user perform?

A. Perform all tasks in the My Services application, including user and role management tasks.

B. View, create, update, and delete Oracle Compute Cloud Service resources.

C. View only the Oracle Compute Cloud resources.

D. Work with one or more Oracle Cloud services only and use the My Services application to manage his or her own password and security challenge questions.

E. Perform cloud backups of a specific instance.

Which three tools can be used on a freshly re-imaged Exadata system to create, resize, or delete ACFS filesystems? (Choose three.)

A. SQL*Plus and ASMCMD

B. ASMCA

C. Enterprise Manager Express

D. Enterprise Manager Cloud Control

E. RMAN

F. OUI

Oracle Configuration Manager is the key to the proactive capabilities of MyOracle Support. Which three statements describe OCM? (Choose three.)

A. It is used to collect configuration details and upload them to the management repository.

B. Configuration collection happens once an hour.

C. A customer can associate an SR to their configuration data to reduce issue resolution time.

D. Oracle Base, ASM, and GRID home must have the same owner for installation to work.

E. Configuration collection occurs every 24 hours.

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

A. when the source platform is little endian, character set is AL32UTF8, and the architecture is multitenant

B. when moving an Oracle Data Guard physical standby database to the cloud

C. when you are migrating a database from a different database version and it might have a different character set

D. when you are concerned about the endian nature of the database and want to perform conversions from different formats

E. when a physical migration approach is feasible and physical database reorganization is no necessary

Which two steps are needed to set up instance caging on an Exadata system? (Choose two.)

A. Set the CPU_COUNT parameter to the maximum number of CPUs that the database instance should utilize at any time.

B. Enable a resource plan to manage the CPUs.

C. Specify the optimization objective as low_latency or high__throughput.

D. Set PGA_AGGREGATE_LIMIT to an acceptable level for the intended instances.

E. Change the initialization parameter THREADED_EXECUTION to TRUE and restart the instance.

Which two statements are true about enabling write-back flash cache? (Choose two.)

A. When enabling write-back flash cache in a non-rolling manner, it is important to ensure that asmdeactivationoutcome is set to YES and asmModeStatus is set to ONLINE for all grid disks.

B. Write-back flash cache requires a minimum required software version.

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 cellkey.ora and restarting cellsrv.

E. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

Which statement is true about Oracle compression?

A. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.

B. Hybrid Columnar Compression can be defined for a single column.

C. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.

D. A partitioned table can define the use of Advanced Compression Hybrid Columnar Compression for each partition.

Which three steps should you perform before executing the following command which will set the cell flash cache mode to write back? # cellcli -e alter cell flashcachemode=writeback

A. Inactivate all physical disks on the cell.

B. Shutdown the cellsrv services on the cell.

C. Disable the storage indexes on the cell.

D. Inactivate the grid disks on the cell.

E. Create a new flash cache on the cell.

F. Drop the existing flash cache on the cell.

Where would your customer go to find the latest Exadata patches?

A. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and InfiniBand patches.

B. The Exadata owner guide.

C. The patch database in my Oracle support.

D. My Oracle Support note 888828.1.

E. The database machine in Exadata storage server 11g release 1 (11.1) supported version (Doc ID: 835032.1).

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