[Dec-2023] Updated Oracle 1Z0-902 Dumps - PDF & Online Engine [Q19-Q42]

[Dec-2023] Updated Oracle 1Z0-902 Dumps – PDF & Online Engine

1Z0-902.pdf - Questions Answers PDF Sample Questions Reliable

Oracle 1Z0-902 certification exam is a prerequisite for the Oracle Certified Expert, Oracle Exadata X8M Solutions certification. This advanced certification validates the candidate's ability to design, implement, and maintain Oracle Exadata X8M solutions. The Oracle Exadata X8M Solutions certification is ideal for professionals who have extensive experience in implementing and managing Oracle Exadata Database Machine X8M solutions.

 

NEW QUESTION # 19
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. 3,2,6,1,4,7,5
• B. 2,3,4,6,1,7,5
• C. 4,3,2,6,1,7,5
• D. 2,6,1,4,3,7,5
• E. 3,2,6,4,1,7,5

Answer: A

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

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

Answer: A,D,E

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

Answer: A,B,C,D

NEW QUESTION # 22
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 Pool cache Read Hits in the Cache Sizes portion of the Report Summary
• C. PMEM Cache section within Memory Statistics
• D. PMEM Cache section within Exadata Smart Statistics
• E. PMEM Pool Misses in the Exadata Outlier Summary

Answer: A,C

Explanation:
The "cell PMEM cache Read Hits" in the "Database IOs" portion of the "Performance Summary" will show the number of reads that have been satisfied from the Persistent Memory Cache. The "PMEM Cache" section within "Memory Statistics" will give detailed information about the usage of the Persistent Memory Cache, such as cache size, used size, hit rate, etc. This information can help to identify if the Persistent Memory Cache is being used effectively and if there are any issues with it.

NEW QUESTION # 23
Which dbmcli command is NOT valid on Exadata X9M?

• A. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
• B. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
• C. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
• D. dbmcli -e "LIST IBPORT DETAIL"

Answer: D

Explanation:
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.

NEW QUESTION # 24
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. 1, 8, 7, 3 and 6
• C. 5, 8, 7, and 6
• D. 2, 8, 7, 3, and 6
• E. 2, 7, 8, and 6

Answer: C

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 # 25
Which two statements are true about enabling write-back flash cache?

• A. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
• B. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
• C. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
• D. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
• E. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.

Answer: A,D

Explanation:
According to the Oracle documentation1, two statements that are true about enabling write-back flash cache are:
Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations (A). This is because write-back flash cache provides better performance and reliability for data file writes than write-through flash cache.
Before write-back flash cache is enabled, you need to drop the Flash Cache first (D). This is because changing the flash cache mode requires recreating the flash cache with a different configuration.

NEW QUESTION # 26
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. A splitter cable can be used to provide power to all PDU cables.
• B. The installation can go ahead, no change is required.
• C. The installation cannot proceed until two power feeds are available per PDU.
• D. 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.

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

NEW QUESTION # 27
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?

• A. External
• B. High
• C. Extended
• D. Sparse
• E. Normal

Answer: B

Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf

NEW QUESTION # 28
Which two activities are supported on the storage servers in an Exadata Database Machine?

• A. installing an alternative package manager
• B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
• C. configuring secure shell user equivalency for the cellmonitor user
• D. upgrading the Storage Server software package using rpm
• E. changing the root password

Answer: C,E

Explanation:
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
A) changing the root password
E) configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html

NEW QUESTION # 29
What are two recommended configuration best practices for backup and recovery on Exadata?

• A. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
• B. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
• C. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
• D. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.

Answer: B,C

NEW QUESTION # 30
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Install on Oracle Database Appliance.
• B. Provide individual x86 64-Bit gateway hardware.
• C. Install on Exadata Engineered System.
• D. Install in Oracle Virtual Machine with required hardware.
• E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Answer: A,D,E

NEW QUESTION # 31
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?

• A. Copy and execute the script on all storage servers using the dcli command.
• B. Copy and execute the script on all storage servers using the EXACLI command.
• C. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
• D. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
• E. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.

Answer: E

Explanation:
This can be done by using the 'cellcli -e' command, which allows you to execute commands in parallel on all storage servers. For more information about executing CELLCLI commands in parallel, please refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

NEW QUESTION # 32
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. 1, 8, 7, 3 and 6
• C. 2, 8, 7, 3, and 6
• D. 5, 8, 7, and 6
• E. 2, 7, 8, and 6

Answer: B

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 # 33
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. It is required to install OEDA on the first new database server.
• B. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
• C. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
• D. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
• E. 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.

Answer: C,D

Explanation:
It is not necessary to execute /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server, nor is it required to install OEDA on the first new database server. 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.
Search results: [1] Refer to the Oracle Exadata Database Machine X9M Implementation Essentials documentation for more information on adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA). [2] Oracle Exadata Deployment Assistant (OEDA) is a graphical user interface (GUI) tool used to configure the Oracle Exadata Database Machine X9M. [3] This article provides the step-by-step instructions to add an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA). [4] It is important to run the OEDA Validate Configuration File step prior to adding the new server to ensure the configuration file is valid and that all required files exist. [5] When adding a new database server with OEDA [1], the configuration file must contain the existing nodes and the new server information must be entered in OEDA. [6] The applyElasticConfig.sh script must be executed to configure the new servers, after which the new servers will be restarted.

NEW QUESTION # 34
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

• A. power distribution units
• B. Cisco RDMA over Converged Ethernet (RoCE) switches
• C. Cisco management switch
• D. fans in the storage servers
• E. power supplies in the database servers
• F. RoCE network interface cards in the storage servers
• G. RoCE network interface cards in the database servers

Answer: A,D,E,F

NEW QUESTION # 35
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 database servers in the first rack
• B. on all database servers in both racks and one storage server in each rack
• C. on at least two storage servers in both racks
• D. on only one database server in both racks
• E. on all storage servers in both racks
• F. on all database servers in the second rack
• G. on all database servers and at least two storage servers in both racks

Answer: B,G

NEW QUESTION # 36
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 must be installed and configured on a dedicated server external to the Database Machine.
• C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• D. ASR communicates with Oracle support services using HTTPS.
• 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,C

Explanation:
1. ASR can upload configuration metadata to support problem resolution1.
2. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm

NEW QUESTION # 37
How do ASM failure groups provide redundancy?

• A. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
• B. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
• C. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
• D. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

Answer: B

Explanation:
In an Automatic Storage Management (ASM) environment, failure groups are used to provide redundancy for the storage disks. Failure groups are used to group together a set of disks and ensure that no two copies of the same data are stored on the same physical disk or storage server. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
For example, if the disks in a failure group are mirrored, one copy of the data is stored on one set of disks, and the other copy is stored on another set of disks. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
ASM failure groups also provide the option to spread the data across different storage servers, this way, even if a storage server fails, data can still be accessed from the other storage servers in the group. This will improve the availability of the data.

NEW QUESTION # 38
Which two statements are true about enabling write-back flash cache?

• A. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
• B. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
• C. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
• D. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
• E. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

Answer: B,E

Explanation:
The two statements that are true about enabling write-back flash cache are:
When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
Before write-back flash cache is enabled, you need to drop the Flash Cache first.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "when enabling write-back flash cache in a rolling manner [1], grid disks need to be inactivated on all cells before enabling write-back flash cache". It also states that "before write-back flash cache can be enabled, the existing flash cache must be dropped".

NEW QUESTION # 39
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. A splitter cable can be used to provide power to all PDU cables.
• B. The installation can go ahead, no change is required.
• C. The installation cannot proceed until two power feeds are available per PDU.
• D. 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.

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 # 40
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.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• C. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -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:
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 # 41
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. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
• B. 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
• C. OS I/O metrics using OS tools such as iostat on the storage servers
• D. OS I/O metrics using OS tools such as iostat on the database servers
• E. OS I/O metrics using Enterprise Manager host pages for the storage servers

Answer: A,D

Explanation:
The two monitoring tools that might be useful in examining I/O performance for the prod database are:
OS I/O metrics using OS tools such as iostat on the database servers.
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "I/O metrics can be collected from the database server using OS tools such as iostat [1], as well as from the storage servers using cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk". It also suggests using Enterprise Manager host pages for the storage servers to view OS I/O metrics.

NEW QUESTION # 42
......

Oracle Exadata Database Machine X8M is a powerful and efficient platform for running mission-critical database workloads. It is designed to provide high performance, scalability, and reliability for Oracle databases. The Exadata Database Machine X8M is a complete database platform that includes hardware, software, and storage components. It is designed to provide a high-performance, scalable, and reliable platform for running database workloads.

 

Oracle 1Z0-902 Dumps PDF Are going to be The Best Score: https://www.actual4dump.com/Oracle/1Z0-902-actualtests-dumps.html

Oracle Engineered Systems 1Z0-902 Exam and Certification Test Engine: https://drive.google.com/open?id=1RIoNtcheSoCvu-hNJL3s1b-557mInxyK