Real Oracle 1Z0-902 Exam Questions Study Guide [Q42-Q64]

Real Oracle 1Z0-902 Exam Questions Study Guide

Updated and Accurate 1Z0-902 Questions for passing the exam Quickly

Oracle 1Z0-902 certification exam is an important step for IT professionals who want to validate their skills and knowledge in implementing and managing Oracle Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification exam covers various topics related to Oracle Exadata Database Machine X8M and is designed to validate the skills required to implement and manage Oracle Exadata Database Machine X8M in a production environment.

Oracle Exadata Database Machine X8M is a powerful database machine that is designed to deliver high performance, scalability, and availability for mission-critical databases. It is a complete system that includes hardware, software, and storage components that are optimized to work together. The Oracle 1Z0-902 exam is a critical certification for IT professionals who are responsible for implementing and managing Oracle Exadata Database Machine X8M systems, as it validates their expertise in this area and demonstrates their ability to handle complex database systems.

 

NEW QUESTION # 42
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A. Exadata storage realms using database-scoped security mode
• B. File permissions on the griddisks in each database server
• C. Exadata storage realms using ASM-scoped security mode
• D. File permissions on the griddisks in each storage server
• E. Using EXADCLI instead of CELLCLI to create the griddisks

Answer: C,D

Explanation:
When multiple databases share space on the storage servers in an unpartitioned storage grid, two Exadata security features can be configured to control which databases can access which griddisks.
Exadata storage realms using ASM-scoped security mode: This feature allows you to create storage realms and assign them to specific databases. This allows you to control which databases have access to which griddisks. The ASM-scoped security mode applies to all griddisks within an ASM disk group, which means that all griddisks in a disk group will be accessible only to the databases that belong to the assigned storage realm.
File permissions on the griddisks in each storage server: This feature allows you to configure file permissions on the griddisks at the storage server level. You can assign specific permissions to specific users or groups, allowing you to control which databases can access which griddisks.

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

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

Answer: B,C,E,F

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 # 44
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

• A. moving all disks from one cell to another as part of a chassis-level component failure
• B. the failure of physical disk 1
• C. corruption in a normal or high redundancy ASM diskgroup
• D. the failure of both physical M.2 disks
• E. accidental loss of all data from all griddisks in a storage server
• F. the failure of physical disk 0 and 11
• G. corruption in the / (root) filesystem

Answer: E,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 # 45
What is the minimum Exadata System Software version required for Exadata X9M?

• A. 21.3.0.0.0
• B. 19.2.1 0.0
• C. 21.2.0.0.0
• D. 18.1.3.0.0
• E. 19.3.0.0.0
• F. 20.1.1.0.0

Answer: C

Explanation:
The minimum Exadata System Software version required to support Oracle Exadata X9M is 21.2.0.0.0. This version introduced various enhancements and capabilities tailored for the X9M series, including optimizations for the RoCE network fabric and support for new hardware components .

NEW QUESTION # 46
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

• A. OECA extends the hardware for the elastic configuration only.
• B. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
• C. OECA facilitates PDU power selection initially and after equipment addition.
• D. OECA reconfigures the size of disk groups and recreates grid disks.
• E. OECA allows one XT storage server in the configuration.

Answer: B,D

Explanation:
The correct answers are Options A and D. Option A is correct because OECA reconfigures the size of disk groups and recreates grid disks. Option D is correct because OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.

NEW QUESTION # 47
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

• A. Cell Offload Quarantine
• B. Database Quarantine
• C. Disk Region Quarantine
• D. Manually created Quarantine
• E. SQL Plan Quarantine

Answer: A,E

Explanation:
A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-software-introduction.html

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. alert logs for the prod database instances
• B. alert logs for the ASM instances
• C. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
• D. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
• E. alert logs for Enterprise Manager

Answer: C,D

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

• A. 914mm of space required above the rack height is required for maintenance access.
• B. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
• C. The incline of any access route ramp must be less than or equal to 6 degrees.
• D. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
• E. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
• F. Oracle Exadata Rack may only be installed on raised floor environments.

Answer: F

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)
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/index.html

NEW QUESTION # 50
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 must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
• B. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
• C. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
• D. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

Answer: B

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 # 51
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?

• A. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• B. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• C. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• D. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

Answer: B

Explanation:
AccordingtoOraclesdocumentationoneoftheutilitiesfordiagnosticsand
Explanation:
repair of Oracle Exadata Storage Server is ExaWatcher, which collects operating system and network metrics on database servers and storage servers. The utility is located in the /opt/oracle.ExaWatcher directory1.
To investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend, you can use the GetExaWatcherResults.sh script to collect and analyze ExaWatcher data for a specified time range1.
Therefore, the command that you should use to investigate this is:
/opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

NEW QUESTION # 52
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 "create 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 "set threshold ds_temp comparison=' >', critical=30" on each database server

Answer: A

Explanation:
The correct command to generate alerts for an event when the temperature of the database servers in an Exadata Full Rack exceeds 30C is "dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server". The dbmcli is the command-line interface for the Oracle Database Management Agent (DMA), which allows you to perform various management tasks on the Exadata servers. This command creates a threshold for the ds_temp metric with a comparison operator of ">" (greater than), and a critical value of 30. The threshold is set on all database servers in the Exadata Full Rack, so when the server temperature exceeds 30C, an alert will be generated.

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. 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: D

Explanation:
In order to completely power off an Exadata Database Machine in an orderly fashion, it's important to properly shut down the cluster first. The command "crscti stop cluster" as root should be executed from one of the database servers.
Once the cluster has been stopped, the next step is to shut down the database servers by executing the command "shutdown -h now" on all database servers.
Next, shut down the Exadata storage servers by executing the command "shutdown -h now" on all Exadata storage servers.
Finally, power off the rack using the power switches on the PDUs.

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

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

Answer: C,E

NEW QUESTION # 55
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 must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
• 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 will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

Answer: B

NEW QUESTION # 56
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

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

Answer: B

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

• A. PMEM Cache section within Memory Statistics
• B. PMEM Pool Misses in the Exadata Outlier Summary
• C. cell PMEM cache Read Hits in the Database IOs portion of the Performance 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: C,D

Explanation:
Option C shows the number of read hits from PMEM cache on storage servers which indicates how much data was served from PMEM instead of flash or disk1.
Option E shows detailed information about PMEM cache such as size, utilization, hit ratio, read latency and write latency2.

NEW QUESTION # 58
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. power distribution units
• C. RoCE network interface cards in the storage servers
• D. fans in the storage servers
• E. RoCE network interface cards in the database servers
• F. Cisco management switch
• G. power supplies in the database servers

Answer: A,C,F,G

NEW QUESTION # 59
Which three of the following options are available for database consolidation on Exadata?

• A. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
• B. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
• C. Multiple Databases on a cluster
• D. Bare Metal deployment with one database per database server
• E. A single database with one or more schema per application
• F. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

Answer: B,C,F

NEW QUESTION # 60
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

• A. Oracle Linux 7.7
• B. Oracle Linux 7.5
• C. Oracle Linux 8.0
• D. Oracle Linux 7.9

Answer: D

Explanation:
RoCE (RDMA over Converged Ethernet) and Persistent Memory are features that are supported by Oracle Linux. The minimum version of Oracle Linux required to support RoCE and Persistent Memory is Oracle Linux 7.9.
RoCE is a low-latency, high-bandwidth networking technology that enables fast data transfer between servers using converged Ethernet networks. It is supported by Oracle Linux 7.9 and later versions, which includes the necessary kernel modules and user-space libraries to enable RoCE.
Persistent Memory is a technology that allows data to be stored in non-volatile memory (NVM) devices, such as NVDIMMs (Non-Volatile Dual In-line Memory Modules), which can be accessed at near-DRAM speeds. Oracle Linux 7.9 and later versions include support for Persistent Memory, which includes kernel modules and user-space libraries to enable Persistent Memory.

NEW QUESTION # 61
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?

• A. using the CELLCLI list LUN DETAIL command as the celladmin user
• B. hardware monitoring using the storage server ILOM
• C. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
• D. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

Answer: B,D

Explanation:
The CELLCLI CALIBRATE command can be used to check the health of all flash cards in the storage server, and it should be run after logging in as the celladmin user. The hardware monitoring using the storage server ILOM should also be used to check for errors and other potential issues with the flash cards. The CELLCLI list LUN DETAIL command should not be used to identify a damaged or failing flash card, since it will not provide any information about the health of the flash card.

NEW QUESTION # 62
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 can monitor and manage a Database Machine storage Expansion rack.
• B. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
• 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. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
• E. Compute nodes forward their SNMP traps to the Management Server process on the same compute node.
• F. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage node.

Answer: A,C,F

Explanation:
Oracle Enterprise Manager (EM) Cloud Control provides comprehensive monitoring and management for Exadata Database Machines, including:
Support for Database Machine Storage Expansion Racks: EM Cloud Control seamlessly integrates with the Storage Expansion Rack, allowing administrators to monitor both primary and expansion storage environments together, which is essential for large-scale deployments.
Minimal Agent Installation: Cloud Control needs only one Oracle Management Agent on one compute node to monitor the entire Database Machine cluster, covering all compute and storage nodes. This is due to Exadata's interconnect and resource-sharing capabilities, enabling centralized monitoring with minimal setup requirements.

NEW QUESTION # 63
Which three of the following options are available for database consolidation on Exadata?

• A. A single database with one or more schema per application
• B. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
• C. Multiple Databases on a cluster
• D. Bare Metal deployment with one database per database server
• E. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
• F. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

Answer: A,C,F

Explanation:
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
1. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
2. A single database with one or more schema per application12.
3. Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how

NEW QUESTION # 64
......

Prepare Important Exam with 1Z0-902 Exam Dumps: https://prep4sure.vcedumps.com/1Z0-902-examcollection.html