Latest [Dec 12, 2023] Oracle 1Z0-902 Exam Practice Test To Gain Brilliante Result [Q26-Q49]

Latest [Dec 12, 2023] Oracle 1Z0-902 Exam Practice Test To Gain Brilliante Result

Take a Leap Forward in Your Career by Earning Oracle 1Z0-902

Oracle Exadata database machine X8M is an integrated platform that combines Oracle database software with hardware components. This machine is designed to deliver high performance, scalability, and reliability, making it an ideal solution for mission-critical applications. The Oracle 1z1-902 exam is designed to test the skills and knowledge required to implement and manage Oracle Exadata database machines, ensuring that IT professionals can effectively deploy and maintain these machines in real-world scenarios.

Oracle Exadata Database Machine X8M is a high-performance database appliance designed to deliver extreme performance, scalability, and reliability for mission-critical workloads. It is a complete system that includes hardware, software, and networking components, all optimized to work together seamlessly. The Oracle 1z1-902 exam covers a wide range of topics, including Exadata architecture, networking, software installation and configuration, backup and recovery, and performance tuning. By mastering these topics, you will be able to deploy and manage the Oracle Exadata Database Machine X8M effectively.

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

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

Answer: C,E

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 # 27
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

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

Answer: A

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

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

Answer: A,B

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 # 29
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. 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
B. OS I/O metrics using OS tools such as iostat on the database 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 storage servers
E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

Answer: B,E

NEW QUESTION # 30
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, 1, 2, 7, 5, 8
B. 6, 2, 1, 8, 4, 5
C. 6, 3, 1, 9, 7, 8
D. 6, 8, 3, 4, 2, 1

Answer: B

Explanation:
The steps and the order in which they should be executed to create an ACFS Filesystem for use as a staging area for data loads are:
asmcrad volcreate -G data -s 1024G acfs_dataload_vol : This command creates a new volume in the data diskgroup, with a size of 1024 GB, and named acfs_dataload_vol.
asmcmd vol info -G data acfs_dataload_vol | grep Device: This command will show the device name of the newly created volume
/usr/sbin/mkfs -t acfs /dev/asm/ac:fs_dataload_vol-123: This command creates a new ACFS filesystem on the volume created in step 1 sudo /u01/app/19.0.0.0/grid/bin/srvctl start filesystem -device /dev/asn/acfs_dataload_vol-123: This command starts the filesystem created in step 3 sudo chovn -R oracle:dba /mnt/acfs_dataload_vol: This command changes the ownership of the /mnt/acfs_dataload_vol to the oracle:dba user.
/sbin/acfsutil snap create -v data_load /mnt/acfs_dataload_vol: This command creates a snapshot of the filesystem to be used as a staging area.
acfsutil size +2S0G -d /dev/asm/acfs_dataload_vol-123 /mnt/acfs_dataload_vol/ : This command increases the size of the filesystem by 2GB
/u01/app/19-G.O-Q7grid/bin/srvctl add filesystem -device /dev/asm/acfs_dataload_vol-

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

Answer: B,C,D,E

NEW QUESTION # 32
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 Virtual Machine clusters supporting a single database for greatest resource isolation
C. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
D. A single database with one or more schema per application
E. Bare Metal deployment with one database per database server
F. Multiple Databases on a cluster

Answer: A,D,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 # 33
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

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

Answer: A

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)

NEW QUESTION # 34
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 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup 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 25Gb ports on eth5 and eth6 using SFP28 transceivers and OM4 fiber cable for client network
D. 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

Answer: A,D

Explanation:
Statement D is true as the Exadata X9M-2 Database Server has two 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and two 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network, as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 24).
Statement B is also true as the Exadata X9M-2 Database Server has two 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network [1][2], and two 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network, as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 24).

NEW QUESTION # 35
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. shutdown -h now' 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. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
E. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
F. CellCLI alter GRIDDISK all inactive on the affected storage server

Answer: A,F

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 # 36
Which three statements are true about the CELLCLI command?

A. It can execute commands on multiple storage servers in parallel.
B. It requires root privileges to create CELLDISKS and GRIDDISKS.
C. It can be executed using the DCLI utility.
D. It can be executed on storage servers.
E. It has command-line history.

Answer: C,D,E

Explanation:
The statements that are true about the CellCLI command are:
It has command-line history . According to 1, you can use the up and down arrow keys to scroll through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a previous command by entering part of it .
It can be executed on storage servers . According to 1, you can invoke CellCLI by logging in to the Exadata cell as cellmonitor , celladmin , or root user and typing "cellcli" . Within CellCLI , you can perform various management and monitoring tasks for the cell134.
It can be executed using the DCLI utility . According to 5, DCLI (distributed CLI) is another utility that can be used to execute scripts and commands across multiple storage cells from a single interface. You can use DCLI to run CellCLI commands on multiple cells at once54.

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

Answer: D

NEW QUESTION # 38
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 an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
B. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
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 CELLCLI on all cells using exadcli
F. to the CELLMONITOR account calling CELLCLI on all cells using DCLI

Answer: C,E,F

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

Answer: A,B,D,E

Explanation:
According to the Oracle Auto Service Request (ASR) documentation1, ASR raises service requests for qualified Oracle products that are detected with specific faults. The qualified Exadata products include2:
Database servers
Storage servers
InfiniBand switches
Cisco switches (X8M and later systems)
Power distribution units (PDUs)

NEW QUESTION # 40
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

A. ZFS Snapshots can provide rapid cloning of development and test environment.
B. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
D. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.

Answer: B,C

NEW QUESTION # 41
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 RDMA over Converged Ethernet (RoCE) switches
B. Oracle clusterware on the database server
C. ASM instances
D. the Power Distribution Units (PDUs)
E. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
F. the storage server ILOM

Answer: B,C,E

Explanation:
Exadata-specific Enterprise Manager Plug-Ins are used to monitor different components of the Exadata Database Machine.
1. ASM instances: The Automatic Storage Management (ASM) instances can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the storage space, disk usage, and performance of the ASM instances.
2. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers: The HCC ratios on Extended (XT) storage servers can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the compression ratios and performance of the storage servers.
3. Oracle clusterware on the database server: The Oracle clusterware on the database server can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the health and performance of the clusterware.

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

Answer: E

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 # 43
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. shutdown -h now' 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. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
E. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
F. CellCLI alter GRIDDISK all inactive on the affected storage server

Answer: A,F

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

A. ASR communicates with Oracle support services using HTTPS.
B. ASR can upload configuration metadata to support problem resolution.
C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
D. ASR Manager must be installed and configured on one of the database servers.
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: D,E

NEW QUESTION # 45
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. ifconfig -a legrep "re0| re1"
B. netstat -rn
C. cat /proc/net/bonding/bondeth0
D. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all

Answer: D

Explanation:
The checkbadlinks.pl script is a tool provided with the Exadata X9M-2 Database Server that allows you to verify the status of the InfiniBand links between the Database Server and the client switches. This script checks for bad links, and it can be used to identify any issues with the client network connectivity. To use the script, you can navigate to the directory where it is located, which is /opt/oracle.SupportTools/ibdiagtools/ and execute the command ./checkbadlinks.pl -all. This will give you a summary of the status of the links and it will indicate if there are any bad links. This command will check the client network on your Exadata X9M-2 Database Server is available via both client switches. Other commands like ifconfig, netstat and cat are not relevant to check the client network on Exadata X9M-2 Database Server

NEW QUESTION # 46
You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:

After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

A. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
B. # xfs_growfs /uOl +20G
C. # resize2fs +20G /dev/VGExaDb/LVDbOral
D. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral

Answer: A

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

Answer: E

Explanation:
According to Oracle documentation1, Exadata Storage software has a complete set of automated operations for hard disk maintenance, when a hard disk has failed or has been flagged as a problematic disk. It will initiate a rebalance operation to redistribute data across other disks and mark the failed disk with an amber light.

NEW QUESTION # 48
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 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.
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 query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

Answer: A,D

Explanation:
A) 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.
C) 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 # 49
......

Oracle 1z1-902 exam, also known as the Oracle Exadata Database Machine X8M Implementation Essentials exam, is designed for IT professionals who are responsible for implementing and maintaining the Oracle Exadata Database Machine X8M system. Oracle Exadata Database Machine X8M Implementation Essentials certification exam validates the skills and knowledge required to configure, deploy, and manage an Oracle Exadata Database Machine X8M system. 1Z0-902 exam tests the candidate's ability to perform tasks such as configuring database servers, storage servers, and network infrastructure, as well as managing database backups, performance tuning, and troubleshooting issues.

Authentic Best resources for 1Z0-902 Online Practice Exam: https://www.pass4sures.top/Oracle-Engineered-Systems/1Z0-902-testking-braindumps.html

Updates Up to 365 days On Developing 1Z0-902 Braindumps: https://drive.google.com/open?id=1D5CzzhEbO9_rySjcGYye6-9hFdfeR3EZ

Latest [Dec 12, 2023] Oracle 1Z0-902 Exam Practice Test To Gain Brilliante Result [Q26-Q49]

Oracle 1Z0-902 Certification Practice Exam

Latest [Dec 12, 2023] Oracle 1Z0-902 Exam Practice Test To Gain Brilliante Result [Q26-Q49]

Related Articles