Latest Oracle 1z1-902 Actual Free Exam Questions & Community Discussion, Page 4

Question #28

Which three statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?

A. Cloud Control cannot monitor partitioned Exadata Database Machine systems.

B. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.

C. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.

D. Cloud Control can monitor and manage a Database Machine storage Expansion rack.

E. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage node.

F. Compute nodes forward their SNMP traps to the Management Server process on the same compute node.

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #29

You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?

A. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server

B. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server

C. dbmcli -e "set alert ds_temp> 30" on each database server

D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #30

You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?

A. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

B. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

C. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.

D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #31

Which two statements are true about applying updates on Exadata systems?

A. Failed database server updates are rolled back to a working state on a previous release automatically.

B. When running a "yum update" for a new Exadata release, all other repositories should be disabled.

C. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.

D. Failed storage server updates are automatically rolled back to a previous release.

E. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.

F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #32

Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

A. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.

B. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.

C. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.

D. Oracle Exadata Rack may only be installed on raised floor environments.

E. 914mm of space required above the rack height is required for maintenance access.

F. The incline of any access route ramp must be less than or equal to 6 degrees.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #33

Which statement is true about the patching features provided in Platinum Services?

A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

B. Patching services are available for the full software stack up to twice per year.

C. Patching is done automatically during business hours.

D. The rolling and complete down time approaches are two options to patching.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #34

Assume that the RDBMS and ASM instances are up and you are enabling write-back flash cache in one cell server at a time.
Which step(s) should you perform before executing the following command you your Exadata X9M-8 Database Machine, which will set the cell flash cache mode to write-back?
#cellcli -e alter cell flashCacheMode=WriteBack

A. Shut down the CELL5RV service on the cell.

B. Disable the storage indexes on the cell.

C. Inactivate the grid disks on the cell.

D. Drop the existing flash cache on the cell.

E. Create a new flash cache on the cell.

F. Inactivate all the physical disks on the cell.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #35

Which are two correct statements about backing up Exadata Database Machine?

A. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.

B. The M.2 disk is hot pluggable and can be replaced when the power is on, but you will have to restore the system data manually.

C. For high availability, system area can be on the first two disks and M.2 devices.

D. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.

E. Backing up Exadata Storage Server Software is critical for restoration.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #36

What are the two benefits of using Oracle Exadata Deployment Assistant (OEDA)?

A. OEDA gathers configuration details and creates the Oracle Exadata Rack configuration file.

B. OEDA provides a CL1 which supports life cycle management tasks for Exadata systems only.

C. OEDA Web-based user interface cannot import OEDA XML configuration files created with the Java-based version of OEDA without conversion

D. OEDA facilitates abstracting hardware.

E. OEDA is used for Oracle Exadata Database Machine, Zero Data Loss Recovery Appliance, Private Cloud Appliance, and SuperCluster.

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1z1-902 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z1-902 Demo