oracle 1z0-338 practice test

When a customer use Enterprise Manager to monitor and maintain their Exadata machine, which
protocol does enterprise manager uses to send and receive information about component failure
event and status.

• A. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and InfiniBand patches.
• A. ILOM
• B. The Exadata owner’s guide.
• B. ICMP
• C. The patch database in my Oracle support.
• C. RPC
• D. My Oracle Support note 888828.1.
• D. IPMI
• E. The database machine in Exadata storage server 11g release 1 (11.1) Supported Versions (Doc ID: 835032.1).
• E. SNMP

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

• A. iDB – Intelligent Database Protocol
• A. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and InfiniBand patches.
• B. InfiniBand protocol
• B. The Exadata owner guide.
• C. Ethernet protocol
• C. The patch database in my Oracle support.
• D. Secure Shell protocol
• D. My Oracle Support note 888828.1.
• E. Fibre Channel protocol
• E. The database machine in Exadata storage server 11g release 1 (11.1) supported version (Doc ID: 835032.1).

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. Flash Cache
• A. Inactivate all physical disks on the cell.
• B. database views
• B. Shutdown the cellsrv services on the cell.
• C. InfiniBand networking
• C. Disable the storage indexes on the cell.
• D. high performance SAS2 disk drives
• D. Inactivate the grid disks on the cell.
• E. cell offloading
• E. Create a new flash cache on the cell.
• F. Drop the existing flash cache on the cell.

Which characteristics of DBFS on Exadata would you suggest as being a key benefit?

• A. Use the ILOM Web GUI.
• A. When using DBFS customers will not need to use FUSE or any client software to administer the file system.
• B. Use the dcli command at the root prompt on a database node.
• B. DBFS offers tremendous I/O bandwidth.
• C. Attach a terminal device to the back panel of the server with a serial cable.
• C. Tens of thousands of files are the perfect use case for DBFS on Exadata.
• D. Connect by using SQL*Plus.
• D. DBFS in an Exadata environment is faster than an NFS mount system because of smart scan performance gain.
• E. Log in as root on the database node by using the Net1 IP address.
• E. DBFS allow customer to store LOB and CLOB files external to database for more flexibility.

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

• A. using the UNIX-based telnet command
• 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. using SQL *Net from clients that are running on a compute cloud service
• B. Before write-back-flash-cache is enabled you need to drop the flash cache first.
• C. using SSH for administrative purposes
• C. Write back flash cache requires a minimum required software version.
• D. using Oracle Net from on-premise applications
• D. When enabling write-back-flash-cache in a non-rolling manners it is important to ensure that asmdeactivationoutcome is set to yes andasmmodestatus is set to online for all grid disks.
• E. using the Remote Desktop client and the RDP protocol
• E. flashcachemode should be set to write back by updating cellinit.ora and restarting cellsrv.

The ipmi tool command is most commonly used to perform which two tasks?

• A. secure access for lights out management of the database and storage servers
• A. To configure base networking and bonds within the Exadata server.
• B. web-based, secure shell, IPMI, and SNMP access for out-of-band management
• B. To power on a chassis from another system in Exadata machine.
• C. role-based security access to limit functions to individual user administration tasks
• C. To show the ILOM SP server event logs in details for a listing of components status on a particular machine.
• D. storage cell monitoring through the CellCLI interface
• D. To manage and maintain the Exadata storage servers and related cell commands.
• E. listener access through the back-end management interface for MySQL and SQL Developer
• E. To manage cluster components.

Which two statements appropriately describe the backup and recovery procedures on Exadata?
(Choose two.)

• A. IORM and DBRM
• A. The data that is stored in a database is backed up and restored by using CellCLI commands.
• B. DBRM on the CC database
• B. The cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.
• C. DBRM on all the databases
• C. The database server software backup is automatic and recovery is accomplished by using a rescue procedure.
• D. Disable IORM by setting its objective directive to OFF
• D. The data that is stored in a database is backed up and restored by using RMAN commands.
• E. IORM, because DBRM cannot be changed for an existing session
• E. The cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.

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

• A. The Enterprise Manager agent software is installed only on the Enterprise Manager repository.
• A. asmadmin
• B. The Enterprise Manager agent software is not a supported version for the storage cell.
• B. oracle
• C. Additional software should not be installed on the Exadata storage cell.
• C. asruser
• D. The Enterprise Manager agent software should be installed by using the YUM repository.
• D. celladmin
• E. root
• F. asradmin

Which statement is true about Oracle compression?

• A. Perform all tasks in the My Services application, including user and role management tasks.
• A. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.
• B. View, create, update, and delete Oracle Compute Cloud Service resources.
• B. Hybrid Columnar Compression can be defined for a single column.
• C. View only the Oracle Compute Cloud resources.
• C. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.
• 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.
• D. A partitioned table can define the use of Advanced Compression Hybrid Columnar Compression for each partition.
• E. Perform cloud backups of a specific instance.

Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata?
(Choose three.)

• A. asmadmin
• A. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.
• B. oracle
• B. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.
• C. asruser
• C. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features.
• D. celladmin
• 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. root
• E. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features.
• F. asradmin
• 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.

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

• A. no flash storage on the database server
• 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. 4 x 3.2 TB NVMe flash cards on the HC storage server
• B. Write-back flash cache requires a minimum required software version.
• C. 8 x 3.2 TB NVMe flash cards on the EF storage server
• C. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
• D. 4 x 3.2 TB NVMe flash cards on the database server
• D. The setting flashCacheMode should be set to Writeback by updating cellkey.ora and restarting cellsrv.
• E. 8 x 3.2 TB NVMe flash cards on the HC storage server
• E. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

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. Each patch that is performed on the Exadata storage servers requires manual resync of the CELLBOOT USB.
• A. secure access for lights out management of the database and storage servers
• B. Some space from the CELLBOOT USB is used for cache metadata when write-back flash cache is enabled.
• B. web-based, secure shell, IPMI, and SNMP access for out-of-band management
• C. Regular Exadata storage server patches make sure that the internal USB is updated so that it can be used for recovery.
• C. role-based security access to limit functions to individual user administration tasks
• D. Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.
• D. storage cell monitoring through the CeIICLI interface
• E. Changes to network configuration files are possible without using ipconf.pl as long as all the relevant files are updated.
• E. listener access through the back-end management interface for MySQL and SQL Developer

Consider the following software changes that are performed manually on a Linux server:
1. Changes for Linux kernel firewall configuration
2. Changes for custom performance monitoring tools
3. Changes for security scan tools
4. Changes for Linux system performance optimization
Which of the software changes listed are permitted on Exadata Storage Servers?

• A. ILOM CLI interface through the management network
• A. only 3
• B. ILOM Web interface through the management network
• B. 1, 2, 3, and 4
• C. remote KVM session to the ILOM
• C. none
• D. from the database server operating system tool "ilomcli"
• D. only 2
• E. from the storage server operating system tool "ilomcli"
• E. only 1 and 2
• F. only 2 and 3

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_STATES region index is populated with high and low values for the OBJECT_ID column
during the l/O request.

• A. creating the required environment by using Smart Scan parallelization
• A. 3, 5, 1, 7, 6, 2 and 4
• B. setting the initialization parameter PARALLEL_ENABLED to TRUE to enable parallel direct path loads
• B. 3, 7, 1, 5, 6, 2, and 4
• C. setting the PARALLEL clause on both the external table and the table where you are loading the data
• C. 3, 7, 5, 2, 1, 6, and 4
• D. adding the PARALLEL hint to the CTAS or IAS statement
• D. 3. 6, 1, 7, 2, 5, and 4
• E. setting the PARALLEL_FORCE_LOCAL parameter to TRUE
• E. 3, 5, 2, 1, 6, 7, and 4

Consider the following command:
./patchmgr -cells dm01 -patch -rolling
Which two actions does this command perform? (Choose two.)

• A. addition of an Exadata storage expansion rack
• A. upgrades one or more Exadata Storage Servers simultaneously
• B. storage server rebalancing
• B. upgrades one or more Exadata Storage Servers listed in the dm01 file
• C. installation or reconfiguration of significant non-Oracle software
• C. upgrades one or more Exadata Storage Servers, one at a time
• D. application of Oracle patches
• D. rolls back one or more Exadata Storage Servers to the previous release
• E. before shutdown to preserve storage indexes
• E. upgrades one or more Exadata Storage Servers and InfiniBand Switches
• F. application of operating system patches
• F. upgrades an Exadata Storage Server named dm01
• G. reconfiguration of significant operating system parameters