100% Pass Guaranteed Free 1z1-902 Exam Dumps Mar 03, 2024 [Q21-Q39]

100% Pass Guaranteed Free 1z1-902 Exam Dumps Mar 03, 2024

Verified & Latest 1z1-902 Dump Q&As with Correct Answers

The 1Z0-902 exam covers a wide range of topics, including Exadata architecture, software installation and configuration, database migration, backup and recovery, performance tuning, and troubleshooting. Candidates are expected to have a deep understanding of Oracle databases and Exadata technology, as well as hands-on experience with installation, configuration, and maintenance of Exadata systems. Passing 1z1-902 exam will demonstrate their ability to implement and manage Exadata systems, and will help them advance their careers in the field of database administration.

 

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

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

Answer: B,D

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

NEW QUESTION # 22
Which statement is true about the Persistent Memory Commit Accelerator?

• A. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
• B. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
• C. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
• D. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
• E. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.

Answer: C

NEW QUESTION # 23
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 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
• B. 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
• 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: A,C

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

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

Answer: B,E,F

Explanation:
Options A, D, and F are available for database consolidation on Exadata. Option A refers to the use of multiple pluggable databases in one or more container databases on either a Virtual Machine or Bare Metal cluster. Option D refers to the use of multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently. And finally, Option F refers to the use of multiple Virtual Machine clusters supporting a single database for greatest resource isolation. This is 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 # 25
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. 1, 8, 7, 3 and 6
• B. 5, 8, 7, and 6
• C. 2, 8, 7, 3, and 6
• D. 2, 7, 8, and 6
• E. 4, 7, 8, 3, and 6

Answer: D

NEW QUESTION # 26
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 celldisk attributes name, deviceName, diskType, physicalFirmware
• B. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
• C. list devices attributes name, deviceName, diskType, physicalFirmware
• D. list cell 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).
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html

NEW QUESTION # 27
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 6.9

Answer: A

NEW QUESTION # 28
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

• A. Add 16x 64GB DIMMs.
• B. Add 12x 32GB DIMMs.
• C. Remove existing memory modules.
• D. Add 32x 64GB DIMMs.
• E. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• F. Add 24x 32GB DIMMs.
• G. Add 16x 32GB DIMMs.
• H. Shutdown the Database Server if running.
• I. Add 12x 64GB DIMMs.

Answer: A,C,G

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

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

Answer: A,E

Explanation:
The AWR report has two sections that show statistics for X9M Persistent Memory Cache: the PMEM Cache section within Memory Statistics and the PMEM Cache section within Exadata Smart Statistics. Both of these sections provide detailed information about the read and write hits and misses, as well as the total capacity and utilization of the PMEM cache. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 515)

NEW QUESTION # 30
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 will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
• 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

NEW QUESTION # 31
Which statement is true about the Persistent Memory Commit Accelerator?

• A. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
• B. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
• C. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
• D. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
• E. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.

Answer: E

Explanation:
Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk. This helps to further reduce redo log write latency by utilizing the speed and low latency of Persistent Memory, along with the Remote Direct Memory Access (RDMA) protocol, to commit changes to disk faster. This allows the system to quickly commit changes to disk, resulting in improved performance and reduced latency.

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

Answer: A,B

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

Answer: D

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 # 34
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

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

Answer: C,D

Explanation:
B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.
References for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.
Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Add Equipment: This input option allows you to allocate RU slots for ... [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Power Selection [1][2]: This input option allows you to select PDU power initially ... [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ...

NEW QUESTION # 35
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. 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.
• B. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
• C. It is required to install OEDA on the first new database server.
• D. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
• 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,D

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/21/ladbi/db-on-exadata.html

NEW QUESTION # 36
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

• A. CellCLI alter GRIDDISK all inactive on the affected storage server
• B. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
• C. 'crsct1 stop cluster -all' on one of the database servers
• D. shutdown -h now' on the affected storage server
• E. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
• F. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server

Answer: A,D

Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB The two commands that must be executed to safely power off the storage server in an Exadata X9M Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage server is completely powered off and no data is lost.
For more information on how to properly power off an Exadata Storage Server, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1188080_1.html

NEW QUESTION # 37
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
• D. You must be physically present in the data center to start an Exadata Storage Server.
• E. -> start /SYSTEM/power
• F. -> start /SP/console

Answer: C

NEW QUESTION # 38
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. OS I/O metrics using OS tools such as iostat on the storage servers
• C. OS I/O metrics using Enterprise Manager host pages for the storage servers
• D. OS I/O metrics using OS tools such as iostat on the database servers
• E. 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

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 # 39
......

Latest 1z1-902 dumps - Instant Download PDF: https://actualtests.crampdf.com/1z1-902-exam-prep-dumps.html