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 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).
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 statements appropriately describe the backup and recovery procedures on Exadata? (Choose two.)
A. The data that is stored in a database is backed up and restored by using CellCLI commands.
B. The cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.
C. The database server software backup is automatic and recovery is accomplished by using a rescue procedure.
D. The data that is stored in a database is backed up and restored by using RMAN commands.
E. The cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.
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.
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 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 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.
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
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1z0-338 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.