Quality 1z1-902 PDF Dumps - 1z1-902 Exam Questions [Q22-Q41]

Quality 1z1-902 PDF Dumps - 1z1-902 Exam Questions

Most UptoDate Oracle 1z1-902 Exam Dumps PDF 2024

NEW QUESTION # 22
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. 2, 8, 7, 3, and 6
• B. 1, 8, 7, 3 and 6
• C. 5, 8, 7, and 6
• D. 2, 7, 8, and 6
• E. 4, 7, 8, 3, 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 # 23
Which two activities are supported on the storage servers in an Exadata Database Machine?

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

Answer: A,B

Explanation:
Exadata Database Machine is a preconfigured and optimized for database workloads. The storage servers in an Exadata Database Machine are used to store database data, and support activities such as upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure and upgrading the Storage Server software package using rpm. These activities are related to maintain the storage servers performance and security. Changing the root password, installing an alternative package manager, and configuring secure shell user equivalency for the cellmonitor user are activities that can be performed on any Linux machine, but they are not specific to Exadata Database Machine.

NEW QUESTION # 24
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: C

NEW QUESTION # 25
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

• A. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
• B. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
• C. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
• D. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.

Answer: B,C

Explanation:
1. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine2.
2. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA2.

NEW QUESTION # 26
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. Sparse
• B. Extended
• C. External
• D. Normal
• E. High

Answer: D

Explanation:
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. This means that they need a redundancy level that can tolerate at least one disk failure without losing data availability or performance. Therefore, the best option for them is normal redundancy . Normal redundancy provides two-way mirroring by default, which means that each data extent has a primary copy and a mirror copy on different disks in different failure groups1. A failure group is a subset of disks within a disk group that are likely to fail at the same time due to common dependencies2. On Exadata Database Machine , each Storage Server is considered as a failure group by default2. This means that if one Storage Server fails or needs to be updated , the data on its disks can still be accessed from another Storage Server that has the mirror copies of the same data extents2. Therefore, normal redundancy ensures data availability and performance during updates or single-node server failures.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html

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

Explanation:
According to Oracle documentation12, patchmgr is the utility used to update software for Exadata infrastructure components. It can apply patches in a rolling or non-rolling manner depending on the argument and input file provided.

NEW QUESTION # 28
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?

• A. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
• B. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
• C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
• D. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.

Answer: A,C

Explanation:
1. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
2. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/

NEW QUESTION # 29
Which two statements are true about applying updates on Exadata systems?

• A. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
• B. Failed storage server updates are automatically rolled back to a previous release.
• C. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
• D. Failed database server updates are rolled back to a working state on a previous release automatically.
• E. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
• F. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.

Answer: B,D

Explanation:
When applying updates on Exadata systems, database server updates are automatically rolled back to a working state on a previous release if the update fails. This ensures that the system can be restored to a working state in the event of a failed update. Additionally, storage server updates are also automatically rolled back to a previous release in the event of a failed update.
This is documented in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and more information can be found on the Oracle support website [1][2].

NEW QUESTION # 30
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. Check the database to see if any rebalance operations are active.
• B. Call Oracle Support and make an appointment so that the drive can be replaced.
• C. Wait for the email of the failure that Exadata or Enterprise Manager will send.
• D. Download and run the latest exadiag tool.
• E. Ask the system administrator to replace the broken disk with a spare.
• F. Wait for a blue light to appear on the disk if the rebalance operation is running.

Answer: B

Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], before doing anything else you should call Oracle Support and make an appointment so that the drive can be replaced. If Platinum Support is enabled, then you can call Oracle Support and they will arrange for the disk to be replaced. If Platinum Support is not enabled, then you can arrange for the disk to be replaced through Enterprise Manager Cloud Control.

NEW QUESTION # 31
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?

• A. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
• B. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
• C. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
• D. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.

Answer: A,C

Explanation:
The two actions that are not appropriate for monitoring how a large production table is accessed in order to leverage the benefits of the Exadata Platform are A) querying VSSYSTEMEVENTS and filtering for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table; and B) querying v$segmentstatistics and filtering for the Object ID of your table from dbaobjects and the the column STATISTICNAME='optimized physical reads'. Instead, you should query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table (C), or run the CellCli-command list activerequest, filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS (D). These two methods are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Monitoring the Exadata Database Machine).

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

• A. 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.
• B. 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.
• 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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

Answer: A,C

Explanation:
According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
1. 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.
2. 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.

NEW QUESTION # 33
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?

• A. netstat -rn
• B. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
• C. ifconfig -a legrep "re0| re1"
• D. cat /proc/net/bonding/bondeth0

Answer: B

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

• A. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• B. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• C. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• D. Run exachk and resolve only WARNINGS that you have not seen before.
• 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 the appropriate patchmgr preqequisite check step for each component being updated.

Answer: A,D,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:
A) Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
B) Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
C) Run exachk and resolve only WARNINGS that you have not seen before3.
D) Run the appropriate patchmgr preqequisite check step for each component being updated3.

NEW QUESTION # 35
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 list LUN DETAIL command as the celladmin user
• C. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
• D. hardware monitoring using the storage server ILOM

Answer: B,D

NEW QUESTION # 36
Which two statements are true about applying updates on Exadata systems?

• A. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
• B. Failed database server updates are rolled back to a working state on a previous release automatically.
• C. Failed storage server updates are automatically rolled back to a previous release.
• D. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
• E. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
• F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.

Answer: C,E

Explanation:
1. Exadata updates have a rollback feature in case the update fails, this means that the system will roll back to a previous release automatically, this applies to storage servers updates. D. Yum, the package manager used in Exadata, automatically installs a non-UEK kernel when running a regular update, this kernel can be selected to boot from grub.

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

Answer: E

NEW QUESTION # 38
Which are two correct statements about backing up Exadata Database Machine?

• A. For high availability, system area can be on the first two disks and M.2 devices.
• B. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
• C. Backing up Exadata Storage Server Software is critical for restoration.
• D. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
• E. The M.2 disk is hot pluggable and can be replaced when the power is on, but you will have to restore the system data manually.

Answer: B,C

Explanation:
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 4: Oracle Clusterware [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 8: Oracle Exadata Storage Server Software [3] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 9: Oracle Exadata Storage Server Infrastructure
https://www.oracle.com/technetwork/database/availability/exadata-backup-recovery-bp-3633870.pdf

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

• A. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
• B. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
• C. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
• 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 non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.

Answer: A,E

Explanation:
When enabling write-back flash cache in a rolling manner, it is important to use DBCLI to inactivate the grid disks on all cells first so that all the cells are in the same state before the process is started. In a non-rolling manner, you must drop the Persistent Memory Commit Accelerator (PMEMLog) first. Write-back flash cache is not on by default for High Capacity Storage Servers in High Redundancy configurations and can be used on Extreme Flash Storage Servers. It's also important to check if it's necessary to drop the flash cache before enabling write-back flash cache.

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

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

Answer: B,D

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

Oracle Exadata Database Machine X8M is a next-generation database appliance that provides a high-performance and scalable platform for database operations. The Oracle 1Z0-902 certification exam is designed for professionals who want to demonstrate their expertise in implementing and managing the Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification is ideal for database administrators, system administrators, and IT professionals who are responsible for managing and maintaining Oracle databases.

 

100% Free Oracle Engineered Systems 1z1-902 Dumps PDF Demo Cert Guide Cover: https://pdfvce.trainingdumps.com/1z1-902-valid-vce-dumps.html