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

Which two statements are true about migrating your database to Exadata? (Choose two.)

A. Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.

B. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.

C. ASM and the database best practice configuration that is supplied during Exadata deployment should be retained during and after migration.

D. The logical migration methods allow more flexibility in changing the database structure for best performance than the physical methods.

E. All indexes should be dropped when migrating to Exadata.

You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line.

Identify two other ways that you can connect. (Choose two.)

A. Use the ILOM Web GUI.

B. Use the dcli command at the root prompt on a database node.

C. Attach a terminal device to the back panel of the server with a serial cable.

D. Connect by using SQL*Plus.

E. Log in as root on the database node by using the Net1 IP address.

Identify two ways that Smart Flash Cache can be enabled on an Exadata Database Machine. (Choose

two.)

A. It is enabled through OEDA by selecting the Enable FlashCache check box in the hardware configuration section.

B. It can be enabled with the ‘cellcli - I alter flashCache=on’command.

C. It can be enabled manually with the CREATE FLASHCACHEcommand from CellCLI.

D. It can be enabled by default during installation.

E. It can be enabled by using the cellCLI DROP FLASHCACHEcommand.

Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

A. Flash Cache

B. database views

C. InfiniBand networking

D. high performance SAS2 disk drives

E. cell offloading

Which three options describe the flash memory capabilities of the Exadata X6-2 database and storage servers? (Choose three.)

A. no flash storage on the database server

B. 4 x 3.2 TB NVMe flash cards on the HC storage server

C. 8 x 3.2 TB NVMe flash cards on the EF storage server

D. 4 x 3.2 TB NVMe flash cards on the database server

E. 8 x 3.2 TB NVMe flash cards on the HC storage server

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. secure access for lights out management of the database and storage servers

B. web-based, secure shell, IPMI, and SNMP access for out-of-band management

C. role-based security access to limit functions to individual user administration tasks

D. storage cell monitoring through the CeIICLI interface

E. listener access through the back-end management interface for MySQL and SQL Developer

Which two statement are true about enabling the write-back flash cache?

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

B. Before write-back-flash-cache is enabled you need to drop the flash cache first.

C. Write back flash cache requires a minimum required software version.

D. When enabling write-back-flash-cache in a non-rolling manners it is important to ensure that asmdeactivationoutcome is set to yes and asmmodestatus is set to online for all grid disks.

E. flashcachemode should be set to write back by updating cellinit.ora and restarting cellsrv.

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).