1Z0-338 Online Practice Questions and Answers

The Exadata architecture is divided into two specific tiers: the database tier and the storage tier. What protocol do these tiers use to communicate with each other?

A. iDB - Intelligent Database Protocol

B. InfiniBand protocol

C. Ethernet protocol

D. Secure Shell protocol

E. Fibre Channel protocol

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

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

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

A customer has received an email notification about a temperature alert on one of the storage servers on their Exadata system.

What action can the customer take to further investigate the alert?

A. Log in to the Oracle database and query v$temperature.

B. SSH to the storage server and use the CeIICLI sensor_check command to get information about the storage server's health.

C. Log in to the ILOM service processor and view the current status of the sensors and indicators on the system.

D. Enter the data center and immediately power off the storage server.

E. Run exachk to find the system component that might be having a problem.

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 three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata? (Choose three.)

A. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.

B. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.

C. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features.

D. Auto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement and run it in parallel without special hints.

E. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features.

F. The SQL statements that take advantage of Auto DOP can be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.

When preparing to install ASR on your customer's Exadata Database Machine, which user account will you use first to configure the Exadata Database Server?

A. asmadmin

B. oracle

C. asruser

D. celladmin

E. root

F. asradmin

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 characteristics of DBFS on Exadata would you suggest as being a key benefit?

A. When using DBFS customers will not need to use FUSE or any client software to administer the file system.

B. DBFS offers tremendous I/O bandwidth.

C. Tens of thousands of files are the perfect use case for DBFS on Exadata.

D. DBFS in an Exadata environment is faster than an NFS mount system because of smart scan performance gain.

E. DBFS allow customer to store LOB and CLOB files external to database for more flexibility.

Which three statements describe the memory capabilities of the X6-2 Exadata system?

A. The database server come with 256GB memory default.

B. The database server can contain 768GB memory.

C. The HC and EF storage servers contain 128GB memory.

D. The database server come with 512GB memory by default.

E. The HC and EF server come with 512GB memory default.

How do ASM failure group provide redundancy?

A. For external redundancy ASM disk groups are placed in a Raid 1+0 configuration to ensure the no blocks are lost during an outage.

B. They ensure that the ASM disks are accessed via ADB protocol and not physically mounted on the database server.

C. They assign ASM disks to failure groups to ensure that the mirror copies of a block are not in the same failure group.

D. They ensure that the cell disks are sliced into grid disks by using cellsrv processes.

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