Best Oracle 1z1-902 Exam Practice Material Updated on Oct 21, 2023 [Q34-Q56]

Best Oracle 1z1-902 Exam Practice Material Updated on Oct 21, 2023

New 1z1-902 Actual Exam Dumps,  Oracle Practice Test

NEW QUESTION # 34
Which three statements are true about the CELLCLI command?

• A. It can be executed using the DCLI utility.
• B. It has command-line history.
• C. It requires root privileges to create CELLDISKS and GRIDDISKS.
• D. It can execute commands on multiple storage servers in parallel.
• E. It can be executed on storage servers.

Answer: A,B,D

Explanation:
The CELLCLI utility is a command line interface to Exadata that enables the execution of commands across multiple storage servers in parallel. It also has command-line history, so users can easily recall previously entered commands. Furthermore, the CELLCLI utility can be executed using the DCLI utility, which provides a convenient way to execute commands on multiple storage servers simultaneously.
However, CELLCLI does not require root privileges to create CELLDISKS and GRIDDISKS, and it cannot be executed on storage servers. This is because CELLCLI is used to manage the Exadata database machine from the database server [1]. For more information about CELLCLI, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

NEW QUESTION # 35
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 "alert metriccurrent ds_temp where metricValue > 30" on each database server
• B. dbmcli -e "set threshold ds_temp comparison=' >', critical=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

Answer: C

NEW QUESTION # 36
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?

• A. -> set /SYS power_state=ON
• B. -> start /SYS/power
• C. -> start /SYSTEM/power
• D. -> start /SP/console
• E. -> start /System
• F. You must be physically present in the data center to start an Exadata Storage Server.

Answer: B

Explanation:
ILOM (Integrated Lights Out Manager) is a remote management system that allows you to control and monitor Exadata Database Machine components, such as storage servers and database servers, from a remote location. The command "start /SYS/power" is used to power on the storage server in the Exadata Database Machine after hardware maintenance. This command can be executed remotely via ILOM.

NEW QUESTION # 37
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?

• A. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
• B. list cell attributes name, deviceName, diskType, physicalFirmware
• C. list celldisk attributes name, deviceName, diskType, physicalFirmware
• D. list devices attributes name, deviceName, diskType, physicalFirmware

Answer: A

Explanation:
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html

NEW QUESTION # 38
An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU. Which statement is correct?

• A. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
• B. A splitter cable can be used to provide power to all PDU cables.
• C. The installation cannot proceed until two power feeds are available per PDU.
• D. The installation can go ahead, no change is required.

Answer: C

Explanation:
In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack, and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will be able to provide sufficient power for the system. Therefore, the installation cannot proceed until two power feeds are available per PDU.
For more information about power requirements for Exadata X9M-2 Elastic Racks, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs

NEW QUESTION # 39
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 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.
• B. 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'.
• C. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
• D. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

Answer: C,D

Explanation:
A) YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
C) You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/

NEW QUESTION # 40
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

• A. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
• B. ASR communicates with Oracle support services using HTTPS.
• C. ASR can upload configuration metadata to support problem resolution.
• D. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• E. ASR Manager must be installed and configured on one of the database servers.
• F. Configuring ASR is mandatory for all Database Machine assets.

Answer: A,D

NEW QUESTION # 41
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?

• A. -> start /SYS/power
• B. -> set /SYS power_state=ON
• C. -> start /SYSTEM/power
• D. -> start /SP/console
• E. -> start /System
• F. You must be physically present in the data center to start an Exadata Storage Server.

Answer: B

Explanation:
This command is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. This command sets the power state of the system to ON and starts the storage server. It is the only command that is able to start the storage server remotely. All the other commands are incorrect or require the user to be physically present in the data center.

NEW QUESTION # 42
You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?

• A. 2,3,4,6,1,7,5
• B. 2,6,1,4,3,7,5
• C. 3,2,6,4,1,7,5
• D. 4,3,2,6,1,7,5
• E. 3,2,6,1,4,7,5

Answer: E

NEW QUESTION # 43
An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical disk?

• A. Replace the failed physical disk.
• B. Rebalance the data on the effected griddisks before performing a manual drop command.
• C. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
• D. Add the griddisks back into the ASM diskgroup they used to be a member of.
• E. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
• F. Create a new celldisk and new griddisks on the replaced physical disk.

Answer: A,C

Explanation:
Once the physical disk has been replaced, you will need to create a new celldisk and griddisks on the replaced physical disk. After the griddisks have been dropped from the associated ASM diskgroups, you can then add the griddisks back into the ASM diskgroup they used to be a member of and rebalance the data on the effected griddisks. Finally, you should verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

NEW QUESTION # 44
Which two statements are true in regards to starting the Exadata Virtual Machine?

• A. Use vm_maker -start-domain to start a virtual machine manually.
• B. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
• C. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
• D. Use vm_maker boot-from-iso command to boot a virtual machine.
• E. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.

Answer: A,C

NEW QUESTION # 45
Which statement is true about the patching features provided in Platinum Services?

• A. Patching services are available for the full software stack up to twice per year.
• B. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
• C. The rolling and complete down time approaches are two options to patching.
• D. Patching is done automatically during business hours.

Answer: A

Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
The correct statement about the patching features provided in Platinum Services is that patching services are available for the full software stack up to twice per year. Oracle Platinum Service covers Exadata storage software and firmware patching, and customers must also perform the database patching. The rolling and complete down time approaches are two options for patching, and patching should be scheduled for times when the system is not being heavily used. Patching is not done automatically during business hours. This is covered in section 4.13 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf Search results: [1] Oracle Exadata Storage Server Patching [1][2]. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest Oracle... [2] Patching and Upgrades. Oracle Database Machine provides automated patching and upgrades for the full Exadata software stack, up to twice a year, with... [3] Virtualized Exadata. Oracle Database Machine X9M-2 comes with a choice of two patching approaches to accommodate different customer needs: Rolling... [4] Jan 10, 2017 ... Exadata Patching Process. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest...

NEW QUESTION # 46
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

• A. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
• B. PMEM Cache section within Memory Statistics
• C. PMEM Pool Misses in the Exadata Outlier Summary
• D. PMEM Cache section within Exadata Smart Statistics
• E. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary

Answer: B

NEW QUESTION # 47
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?

• A. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
• B. the RDMA over Converged Ethernet (RoCE) switches
• C. the Power Distribution Units (PDUs)
• D. Oracle clusterware on the database server
• E. the storage server ILOM
• F. ASM instances

Answer: D,E,F

Explanation:
1. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor ASM instances.
2. Additionally, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor the storage server ILOM.
3. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) also recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor Oracle clusterware on the database server.

NEW QUESTION # 48
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?

• A. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
• B. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
• C. alert logs for the ASM instances
• D. alert logs for the prod database instances
• E. alert logs for Enterprise Manager

Answer: A,B

NEW QUESTION # 49
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?

• A. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
• B. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
• C. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
• D. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.

Answer: A

Explanation:
To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e "ALTER CELL ENABLE REST" and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).

NEW QUESTION # 50
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

• A. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• C. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• D. Run the appropriate patchmgr preqequisite check step for each component being updated.
• E. Run exachk and resolve only WARNINGS that you have not seen before.
• F. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.

Answer: A,B,D,E

Explanation:
According to Oracle.com documents or resources, the four actions that you should take before proceeding with applying updates to your Exadata Database Machine are:
1. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
2. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
3. Run exachk and resolve only WARNINGS that you have not seen before3.
4. Run the appropriate patchmgr preqequisite check step for each component being updated3.

NEW QUESTION # 51
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?

• A. 5, 8, 7, and 6
• B. 4, 7, 8, 3, and 6
• C. 2, 8, 7, 3, and 6
• D. 2, 7, 8, and 6
• E. 1, 8, 7, 3 and 6

Answer: A

Explanation:
Option 5 stops the clusterware on all database servers as the grid user3.
Option 8 shuts down all Exadata storage servers using their ILOM interfaces1.
Option 7 shuts down all database servers using their ILOM interfaces1.
Option 6 powers off the rack using the power switches on the PDUs2.

NEW QUESTION # 52
You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?

• A. on all storage servers in both racks
• B. on all database servers in the second rack
• C. on all database servers and at least two storage servers in both racks
• D. on all database servers in both racks and one storage server in each rack
• E. on all database servers in the first rack
• F. on at least two storage servers in both racks
• G. on only one database server in both racks

Answer: C,F

Explanation:
In order to monitor all components of this multirack configuration, Enterprise Manager agents must be deployed on at least two storage servers in both racks and all database servers in both racks. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book [1], in which it states "To monitor all components of the multirack configuration, you must deploy agents on all database servers and at least two storage servers in each rack" (page 6-15).

NEW QUESTION # 53
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?

• A. 4, 7, 8, 3, and 6
• B. 2, 8, 7, 3, and 6
• C. 1, 8, 7, 3 and 6
• D. 2, 7, 8, and 6
• E. 5, 8, 7, and 6

Answer: C

Explanation:
In order to power off an Exadata Database Machine in an orderly fashion, the commands should be executed in the following order: 1) Execute "crscti stop cluster -all" as the grid user from one database server; 2) Execute "shutdown -h now" on all database servers; 3) Power off all network switches; 4) Execute "shutdown -h now" on all Exadata storage servers; and 5) Power off the rack using the power switches on the PDUs. This sequence of commands ensures that all services running on the Exadata Database Machine are in a clean state before powering off the system. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 543)

NEW QUESTION # 54
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

• A. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
• B. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
• C. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.
• D. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.

Answer: C

Explanation:
Exadata Secure RDMA Fabric isolation is a feature that allows you to use virtualization on the X9M-2 platform while maintaining security and isolation between multiple tenants or VM clusters. Secure Fabric isolation works by creating a dedicated network partition and VLAN ID for each Database VM cluster, which is used for cluster networking between the database servers in the VM Cluster. This ensures that the network traffic of each VM cluster is isolated from the others, and it prevents unauthorized access to the data or resources of other VM clusters. Secure Fabric isolation can also be used for other purposes such as client networking, Data Guard traffic, but it's mainly used to provide security and isolation between multiple tenants or VM clusters.
According to Oracle's documentation1, Exadata Secure RDMA Fabric Isolation is a feature that enables strict network isolation for Oracle Real Application Clusters (Oracle RAC) clusters on Exadata Database Machine systems that use RDMA over Converged Ethernet (RoCE). Exadata Secure RDMA Fabric Isolation uses RoCE VLANs to ensure that network packets from one VM cluster cannot be seen by another VM cluster. VLAN tag enforcement is done at the KVM host level, which means that security cannot be bypassed by any software exploits or misconfiguration on the database server VMs1.
Therefore, the statement that is true about how Exadata Secure RDMA Fabric isolation is used in X9M-2 with virtualization enabled is:
With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.

NEW QUESTION # 55
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

• A. Collected configuration information can be uploaded automatically to Oracle.
• B. It collects configuration information on demand.
• C. It is mandatory to install OCM on at least one database server.
• D. Collected configuration information can be uploaded manually to Oracle.
• E. It collects configuration information automatically.
• F. It is mandatory to install OCM on all database servers.

Answer: C,D,E

NEW QUESTION # 56
......

The Oracle 1z1-902 exam comprises of 60 questions that must be completed within 105 minutes. The questions are based on real-world case scenarios, requiring test takers to demonstrate their expertise in Exadata implementation while ensuring the highest security standards to protect the data. Candidates who successfully pass the exam will receive an Oracle Certification, confirming their Exadata implementation skills and expertise.

 

Study HIGH Quality 1z1-902 Free Study Guides and Exams Tutorials: https://www.real4dumps.com/1z1-902_examcollection.html

Download Oracle 1z1-902 Exam Dumps to Pass Exam Easily: https://drive.google.com/open?id=1s7sK4pIA9fSWNXgdzLNzmB5DbWwYiOWC