Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials v1.0 (1z0-338)

Page:    1 / 6   
Total 81 questions

Which three statements are true about the Enterprise Manager setup in Exadata? (Choose three.)

  • A. The Exadata Plug-In is automatically installed with EM Agent 12cR1.
  • B. When installing Enterprise Manager after a Platinum Services installation, you should reuse the existing EM Agent.
  • C. InfiniBand Switches are monitored remotely.
  • D. Enterprise Manager creates a schematic of all servers and their health in the Exadata rack.
  • E. Enterprise Manager shows the health of individual ports on the InfiniBand Switches.


Answer : CDE

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


Answer : B

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

  • A. upgrades one or more Exadata Storage Servers simultaneously
  • B. upgrades one or more Exadata Storage Servers listed in the dm01 file
  • C. upgrades one or more Exadata Storage Servers, one at a time
  • D. rolls back one or more Exadata Storage Servers to the previous release
  • E. upgrades one or more Exadata Storage Servers and InfiniBand Switches
  • F. upgrades an Exadata Storage Server named dm01


Answer : AF

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


Answer : E

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. only 3
  • B. 1, 2, 3, and 4
  • C. none
  • D. only 2
  • E. only 1 and 2
  • F. only 2 and 3


Answer : E

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


Answer : ABC

Reference:
https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50469/features.htm#DBMSQ21287

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.


Answer : BC

Reference:
http://www.oracle.com/technetwork/articles/database/exadata-write-back-flash-2179184.html

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.


Answer : ABC

Reference:
https://books.google.com.pk/books?id=iY8Mt8SbWicC&pg=PA619&lpg=PA619&dq=Oracle%27s+Auto+DOP+algorithms+calculate+the+Degree+of+Parallelism
+based+on+a+table%27s+block+counts&source=bl&ots=2WytrJ-
Ojq&sig=wR8LwE3H4NgaDEZ8rQP8uVs2I1M&hl=en&sa=X&ved=0ahUKEwjb_8iSy_jXAhUGzRQKHdeCAg0Q6AEIJzAA#v=onepage&q=Oracle's%20Auto%
20DOP%20algorithms%20calculate%20the%20Degree%20of%20Parallelism%20based%20on%20a%20table's%20block%20counts&f=false
.

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.


Answer : A

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


Answer : E

Reference:
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm#ASXQI103

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.


Answer : DE

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

  • A. To configure base networking and bonds within the Exadata server.
  • B. To power on a chassis from another system in Exadata machine.
  • C. To show the ILOM SP server event logs in details for a listing of components status on a particular machine.
  • D. To manage and maintain the Exadata storage servers and related cell commands.
  • E. To manage cluster components.


Answer : BC

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.


Answer : BC

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.


Answer : C

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.


Answer : BDF

Page:    1 / 6   
Total 81 questions