1Z0-338 Online Practice Questions and Answers

There are many different ways to load data into database tables.

Which method does Oracle strongly recommend?

A. generic connectivity via ODBC or JDBC

B. database gateways to open systems and mainframes

C. Oracle GoldenGate

D. Oracle Data Pump

E. SQL*Loader import

F. data loading via external tables

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.

To patch an Exadata cloud instance, you need to run the exadbcpatchmulti command as root from the compute node. exadbcpatchmulti uses the exadbcpatch.cfg file to provide information about the location of files related to patching operations as well as additional parameters related to these operations.

What is the purpose of the sw_bkup_needed=1 parameter that can be set in the exadbcpatch.cfg file?

A. creates a backup of the patch in case of an error in the patching routine

B. performs a backup of each Oracle home directory before a patch is applied

C. forces the software to create a backup of the exadbpatch.cfg file

D. adds a dialog box that prompts for a backup before the patch can be applied

E. creates a backup of the Oracle database data files

Which statement is true about the patching features provided in Platinum Services?

A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

B. Patching support includes Exadata, Exalogic, and Database Appliance.

C. Patching services are available for the full software stack up to twice per year.

D. The rolling window and complete down time approaches are two options to patching.

Identify four significant changes when a backup of Exadata compute nodes must be performed. (Choose four.)

A. addition of an Exadata storage expansion rack

B. storage server rebalancing

C. installation or reconfiguration of significant non-Oracle software

D. application of Oracle patches

E. before shutdown to preserve storage indexes

F. application of operating system patches

G. reconfiguration of significant operating system parameters

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

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

A. EM Agents are installed on each database and storage node.

B. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.

C. EM Agents can communicate to storage cells via SSH.

D. The Exadata Plug-In for monitoring switches is installed in each EM Agent.

E. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.

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 user can create administrator accounts and change the administrator password in Oracle Exadata Cloud Service?

A. system

B. Account Administrator

C. Identity Domain Administrator

D. sys

E. Service Instance Administrator

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

A. operating system components

B. software assets

C. hardware assets

D. data entry errors

E. backup and restore failures