2023 Best 1z1-902 Exam Preparation Material with New Dumps Questions
Free 1z1-902 Exam Files Verified & Correct Answers Downloaded Instantly
What are the objectives of the Oracle 1Z0-902 Exam?
The objectives of the Oracle 1Z0-902 Exam are to test the candidates' abilities in designing and developing Oracle databases and most importantly, the Oracle1Z0-902 Exam is designed to evaluate the candidate's skills in understanding and applying the Oracle Database Architecture.
This Oracle 1Z0-902 Exam is the most challenging certification for the Oracle Database developers. In addition, the Oracle 1Z0-902 Exam contains the highest demand and the most competitive market among other certifications. Oracle 1Z0-902 exam dumps are only way to pass the exam.
NEW QUESTION 36
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- B. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- C. Oracle Exadata Rack may only be installed on raised floor environments.
- D. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- 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.
Answer: C
Explanation:
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)
NEW QUESTION 37
Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?
- A. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
- B. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
- C. It is required to install OEDA on the first new database server.
- D. In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.
- E. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
Answer: A,B
NEW QUESTION 38
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 7.5
- B. Oracle Linux 8.0
- C. Oracle Linux 7.7
- D. Oracle Linux 7.9
Answer: B
Explanation:
RoCE, or Remote Direct Memory Access over Converged Ethernet, is a high-speed networking technology that allows data to be transferred between servers, storage, and other devices over Ethernet. Persistent Memory is a form of non-volatile memory that can be used to store data without losing it when power is lost.
Oracle Linux 8.0 supports both RoCE and Persistent Memory, allowing Exadata systems to leverage the benefits of both technologies. For more information on Oracle Linux 8.0 and its features, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
NEW QUESTION 39
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?
- A. the failure of physical disk 0 and 11
- B. corruption in a normal or high redundancy ASM diskgroup
- C. the failure of both physical M.2 disks
- D. the failure of physical disk 1
- E. moving all disks from one cell to another as part of a chassis-level component failure
- F. corruption in the / (root) filesystem
- G. accidental loss of all data from all griddisks in a storage server
Answer: F,G
Explanation:
Reason B, corruption in the / (root) filesystem, is a valid reason for executing a storage server rescue procedure. If the root filesystem is corrupted, the storage server will no longer be able to boot and will need to be rescued.
Reason F, accidental loss of all data from all griddisks in a storage server, is also a valid reason for executing a storage server rescue procedure. If all data is accidentally lost from the griddisks in a storage server, the server will need to be rescued in order to recover the data.
For more information about the Exadata X9M-2 storage server rescue procedure, 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] Oracle Exadata Database Machine X9M-2 Storage Server Rescue Procedure - Oracle Docs [3] Oracle Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs [4] Oracle Exadata Database Machine X8M-2 Storage Server Rescue Procedure - Oracle Docs [5] Oracle Exadata Database Machine X9M-2 Storage Server Update Procedure - Oracle Docs [6] Oracle Exadata Database Machine X8M-2 Storage Server Update Procedure - Oracle Docs
NEW QUESTION 40
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 devices attributes name, deviceName, diskType, physicalFirmware
- B. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
- C. list cell attributes name, deviceName, diskType, physicalFirmware
- D. list celldisk attributes name, deviceName, diskType, physicalFirmware
Answer: B
NEW QUESTION 41
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- B. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- C. Run the appropriate patchmgr preqequisite check step for each component being updated.
- D. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- E. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- F. Run exachk and resolve only WARNINGS that you have not seen before.
Answer: A,B,C,D
NEW QUESTION 42
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 devices attributes name, deviceName, diskType, physicalFirmware
- B. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
- C. list cell attributes name, deviceName, diskType, physicalFirmware
- D. list celldisk attributes name, deviceName, diskType, physicalFirmware
Answer: B
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).
NEW QUESTION 43
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. alert logs for Enterprise Manager
- B. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- C. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- D. alert logs for the ASM instances
- E. alert logs for the prod database instances
Answer: D,E
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not.
NEW QUESTION 44
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. RoCE network interface cards in the database servers
- B. power distribution units
- C. Cisco management switch
- D. RoCE network interface cards in the storage servers
- E. power supplies in the database servers
- F. Cisco RDMA over Converged Ethernet (RoCE) switches
- G. fans in the storage servers
Answer: C,D,E,F
NEW QUESTION 45
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 7.5
- B. Oracle Linux 7.7
- C. Oracle Linux 6.9
- D. Oracle Linux 8.0
Answer: A
NEW QUESTION 46
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Database Quarantine
- B. Cell Offload Quarantine
- C. Manually created Quarantine
- D. Disk Region Quarantine
- E. SQL Plan Quarantine
Answer: A,C
NEW QUESTION 47
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. alert logs for Enterprise Manager
- B. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- C. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- D. alert logs for the ASM instances
- E. alert logs for the prod database instances
Answer: B,C
NEW QUESTION 48
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. Cisco RDMA over Converged Ethernet (RoCE) switches
- B. RoCE network interface cards in the database servers
- C. power distribution units
- D. fans in the storage servers
- E. RoCE network interface cards in the storage servers
- F. power supplies in the database servers
- G. Cisco management switch
Answer: C,D,E,F
NEW QUESTION 49
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Database Quarantine
- B. SQL Plan Quarantine
- C. Manually created Quarantine
- D. Cell Offload Quarantine
- E. Disk Region Quarantine
Answer: A,B
NEW QUESTION 50
You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:
After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?
- A. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
- B. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
- C. # resize2fs +20G /dev/VGExaDb/LVDbOral
- D. # xfs_growfs /uOl +20G
Answer: A
NEW QUESTION 51
You are updating your Exadata X9M-2 Elastic Database Machine with 6 database servers and 12 High Capacity Storage Servers. You will be using patchmgr to apply updates across the entire machine while still maintaining database availability.
Assuming you are driving patchmgr from an external server, which statement is true about the execution phase?
- A. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
- B. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
- C. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- D. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
Answer: A
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], patchmgr can be used to apply updates in a rolling manner while still maintaining database availability. It will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption. This is done by invoking patchmgr with the -rolling argument and specifying the component groups in the input file.
NEW QUESTION 52
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?
- A. 0
- B. 10, 8, 2, 5
- C. 10, 8, 9, 11
- D. 4,1, 6, 9
- E. 7,6,9,11
Answer: D
NEW QUESTION 53
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.
NEW QUESTION 54
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?
- A. 4,1, 6, 9
- B. 0
- C. 10, 8, 2, 5
- D. 7,6,9,11
- E. 10, 8, 9, 11
Answer: E
Explanation:
The correct order of steps is 10, 8, 9, 11. The 10th step is to use the drop down to add Exadata X9M Database Servers, the 8th step is to use the drop down to add Exadata X9M EF Storage Servers, the 9th step is to use "Add Equipment" to add the ZFS Storage Controllers, and the 11th step is to use "Add Equipment" to add the ZFS Storage Trays. These steps are referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html.
NEW QUESTION 55
......
Instant Download 1z1-902 Dumps Q&As Provide PDF&Test Engine: https://dumpstorrent.prep4surereview.com/1z1-902-latest-braindumps.html
