Oracle 1z1-902 Real Exam Questions Test Engine Dumps Training With 60 Questions
1z1-902 Actual Questions Answers PDF 100% Cover Real Exam Questions
Oracle Exadata Database Machine X8M is a high-performance database appliance that is designed to deliver extreme performance, scalability, and availability for mission-critical databases. It is designed to provide optimized performance for Oracle database workloads, including OLTP, data warehousing, and analytics. The appliance combines hardware and software components that are engineered to work together to deliver optimal performance and scalability.
Oracle 1Z0-902 exam, also known as the Oracle Exadata Database Machine X8M Implementation Essentials Exam, is designed for IT professionals who want to demonstrate their knowledge and skills in implementing and managing Oracle Exadata Database Machine X8M systems. 1z1-902 exam is part of the Oracle Certified Specialist (OCS) certification and is recommended for professionals who have experience with Oracle Exadata Database Machine X8M and want to validate their expertise in this area.
NEW QUESTION # 18
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: D
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 # 19
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR can upload configuration metadata to support problem resolution.
- B. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- C. ASR Manager must be installed and configured on one of the database servers.
- D. ASR communicates with Oracle support services using HTTPS.
- E. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- F. Configuring ASR is mandatory for all Database Machine assets.
Answer: B,E
NEW QUESTION # 20
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?
- A. OS I/O metrics using OS tools such as iostat on the storage servers
- B. OS I/O metrics using Enterprise Manager host pages for the storage servers
- C. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
- D. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod
database instances using SQL *p1us - E. OS I/O metrics using OS tools such as iostat on the database servers
Answer: C,E
NEW QUESTION # 21
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?
- A. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using
SFP28 transceivers and OM4 fiber cable for client network - B. 2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network
- C. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
- D. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network
Answer: B,C
NEW QUESTION # 22
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. -> start /SYSTEM/power
- C. -> set /SYS power_state=ON
- D. You must be physically present in the data center to start an Exadata Storage Server.
- E. -> start /System
- F. -> start /SP/console
Answer: A
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 # 23
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?
- A. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
- B. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
- C. to the CELLMONITOR account using cellcli interactively on each storage server
- D. to the CELLADMIN account using cellcli interactively on each storage server
- E. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
- F. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
Answer: A,B,C
NEW QUESTION # 24
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. the Power Distribution Units (PDUs)
- B. the storage server ILOM
- C. Oracle clusterware on the database server
- D. the RDMA over Converged Ethernet (RoCE) switches
- E. ASM instances
- F. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
Answer: B,C,E
NEW QUESTION # 25
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?
- A. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- B. Download and run the latest exadiag tool.
- C. Call Oracle Support and make an appointment so that the drive can be replaced.
- D. Ask the system administrator to replace the broken disk with a spare.
- E. Check the database to see if any rebalance operations are active.
- F. Wait for a blue light to appear on the disk if the rebalance operation is running.
Answer: D
NEW QUESTION # 26
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?
- A. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
- B. The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.
- C. The sparse_<DBM_NAME> diskgroup is created automatically.
- D. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
- E. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
Answer: B,C
Explanation:
This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1]. The other statements are false as there is no free space available on the hard disks inside the database servers for possible extension of the /uoi file system, and there is no free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes or to configure Exadata Smart Flash Logs [2][3].
NEW QUESTION # 27
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/ibdiagtools/netcheck/runDiagnostics.pm -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/exachk/exachk -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 # 28
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 /SYSTEM/power
- B. -> set /SYS power_state=ON
- C. You must be physically present in the data center to start an Exadata Storage Server.
- D. -> start /System
- E. -> start /SYS/power
- F. -> start /SP/console
Answer: D
NEW QUESTION # 29
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.
Answer: B
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 # 30
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 8.0
- D. Oracle Linux 7.9
Answer: C
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 # 31
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool Misses in the Exadata Outlier Summary
- B. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- C. PMEM Cache section within Exadata Smart Statistics
- D. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- E. PMEM Cache section within Memory Statistics
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 # 32
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.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- B. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- C. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- D. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
Answer: C
Explanation:
Exachk is an Oracle-provided diagnostic tool that allows you to check various components of an Exadata Database Server, including the client network. The tool is located in the /opt/oracle.SupportTools/exachk/ directory and can be run with the command: exachk. This command can be run with the option -from <Fridays_Date>_17:00:00 and -to <Sundays_Date>_23:59:00 to specify a time range of interest, this way you can check the client network status between the specified time range. The tool checks the status of various components such as network interfaces, InfiniBand fabric, and storage servers. It also analyzes log files, configuration files, and system settings to detect any issues. The tool generates a report, which can be used to identify the root cause of the issue and provide recommendations for resolution.
Tfact1 is a tool to collect diagnostic information from Exadata and non-Exadata systems and it is not related to client network status.
Netcheck and GetExaWatcherResults.sh are not tools provided with the Exadata Database Server and they are not related to client network status.
NEW QUESTION # 33
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool Misses in the Exadata Outlier Summary
- B. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- C. PMEM Cache section within Exadata Smart Statistics
- D. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- E. PMEM Cache section within Memory Statistics
Answer: E
NEW QUESTION # 34
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 CALIBRATE command on the storage server after logging in as the celladmin user
- B. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
- C. using the CELLCLI list LUN DETAIL command as the celladmin user
- D. hardware monitoring using the storage server ILOM
Answer: A,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.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/index.html
NEW QUESTION # 35
......
Free4Torrent 1z1-902 Exam Practice Test Questions: https://www.free4torrent.com/1z1-902-braindumps-torrent.html
1z1-902 Exam questions and answers: https://drive.google.com/open?id=1VXTs2nznlYNfY8IBASXOUGV-dNqTf8y2