Pass Oracle 1Z0-902 Exam with Guarantee Updated 62 Questions
Latest 1Z0-902 Pass Guaranteed Exam Dumps Certification Sample Questions
Oracle 1Z0-902 (Oracle Exadata Database Machine X8M Implementation Essentials) Certification Exam is designed for professionals who are interested in validating their knowledge and skills in implementing and managing the Oracle Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification exam covers a wide range of topics, including hardware and software components, architecture, installation, configuration, tuning, backup and recovery, and maintenance of the Oracle Exadata Database Machine X8M.
NEW QUESTION # 17
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 1024GB
- B. 512GB
- C. 768GB
- D. 384GB
- E. 2048GB
- F. 1536GB
Answer: A
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the maximum DRAM capacity you can expand an X9M-2 DB Server is 1024GB. This is the maximum amount of DRAM that can be installed in the server. The specific steps for adding DRAM are outlined in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_hardware_memory.html.
NEW QUESTION # 18
Which two statements are true about applying updates on Exadata systems?
- A. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- B. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- C. Failed storage server updates are automatically rolled back to a previous release.
- 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. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
Answer: C,F
Explanation:
According to Oracle's documentation12, some of the statements that are true about applying updates on Exadata systems are:
Failed storage server updates are automatically rolled back to a previous release1.
When running a "yum update" for a new Exadata release, all other repositories should be disabled1.
NEW QUESTION # 19
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. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
- B. 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.
- C. It is required to install OEDA on the first new database server.
- D. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
- 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,B
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/21/ladbi/db-on-exadata.html
NEW QUESTION # 20
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
- D. dbmcli -e "LIST IBPORT DETAIL"
Answer: B
Explanation:
1. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'" is valid command and it is used to list the historical values for metrics where the name starts with "DS_."
2. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " is valid command and it is used to list the current value of the metric named "DS_TEMP"
3. dbmcli -e "LIST IBPORT DETAIL" is valid command and it is used to list the InfiniBand ports and details of the Exadata X9M.
"dbmcli" is a command-line tool that is used to manage and monitor the Exadata Database Machine. It allows you to perform various tasks such as managing the database, storage, and network components, and monitoring the performance and health of the machine. The command "dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15" is not a valid command, it is not supported on Exadata X9M.
NEW QUESTION # 21
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?
- A. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
- B. The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.
- C. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
- D. The sparse_<DBM_NAME> diskgroup is created automatically.
- E. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
Answer: C,E
NEW QUESTION # 22
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,3,4,6,1,7,5
- B. 3,2,6,4,1,7,5
- C. 3,2,6,1,4,7,5
- D. 2,6,1,4,3,7,5
- E. 4,3,2,6,1,7,5
Answer: A
Explanation:
This ordering is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. First, the Exadata should be stabilized and unpacked (Steps 2 and 3). Then, the safety guidelines should be reviewed (Step 4). The Exadata should then be allowed to acclimatize for 24 hours (Step 4). After that, the Exadata PDU A should be powered on (Step 6) and the Exadata should be placed in its allocated space (Step 6). Finally, the Exadata PDU B should be powered on (Step 7).
NEW QUESTION # 23
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Install in Oracle Virtual Machine with required hardware.
- B. Install on Oracle Database Appliance.
- C. Install on Exadata Engineered System.
- D. Provide individual x86 64-Bit gateway hardware.
- E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
Answer: A,B,C
Explanation:
The Platinum Services Advanced Support Gateway is a component of Oracle's Platinum Services offering that enables customers to access advanced support features and tools, such as automated problem diagnosis and resolution. Customers have the option to host the Advanced Support Gateway on an Oracle Database Appliance, Oracle Virtual Machine with required hardware, or an Exadata Engineered System. These options allow customers to leverage existing infrastructure and resources to host the gateway, rather than needing to purchase and install new hardware. Providing individual x86 64-Bit gateway hardware or purchase the recommended x86 64-Bit gateway hardware from Oracle are also options but it depends on the customer's infrastructure and resources.
NEW QUESTION # 24
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. Querying VSSYSTEM_EVENTS for the event 'cell physical IO interconnect bytes returned by smart scan' will not be appropriate for monitoring the access on a particular table. The V$SYSTEM_EVENT view is used to monitor system-wide performance statistics, not specific table access. C. Querying v$SYSTAT for the statistic 'cell smart table scan' will not be appropriate for monitoring the access on a particular table as well. The v$SYSTAT view contains system-wide performance statistics, not specific table access.
NEW QUESTION # 25
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?
- A. Ask the system administrator to replace the broken disk with a spare.
- B. Wait for a blue light to appear on the disk if the rebalance operation is running.
- 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 the email of the failure that Exadata or Enterprise Manager will send.
E Download and run the latest exadiag tool.
Answer: A
NEW QUESTION # 26
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: A,D
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. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- B. 914mm of space required above the rack height is required for maintenance access.
- C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- D. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- E. Oracle Exadata Rack may only be installed on raised floor environments.
- F. The incline of any access route ramp must be less than or equal to 6 degrees.
Answer: E
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 # 28
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?
- A. -> start /SYSTEM/power
- B. -> start /SP/console
- C. -> start /System
- D. -> set /SYS power_state=ON
- E. -> start /SYS/power
- F. You must be physically present in the data center to start an Exadata Storage Server.
Answer: C
NEW QUESTION # 29
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. It collects configuration information automatically.
- B. It collects configuration information on demand.
- C. Collected configuration information can be uploaded automatically to Oracle.
- D. It is mandatory to install OCM on at least one database server.
- E. Collected configuration information can be uploaded manually to Oracle.
- F. It is mandatory to install OCM on all database servers.
Answer: C,D,F
NEW QUESTION # 30
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. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
- B. cat /proc/net/bonding/bondeth0
- C. netstat -rn
- D. ifconfig -a legrep "re0| re1"
Answer: B
Explanation:
According to Oracle's documentation1, the client network on Exadata X9M-2 Database Server is used for client access to the database servers using Single Client Access Name (SCAN) and Oracle RAC Virtual IP (VIP) addresses. To verify that the client network is available via both client switches, you can use the command:
cat /proc/net/bonding/bondeth0
This command displays information about the bondeth0 interface, which is used for the client network on Exadata X9M-2 Database Server2. You can check if both interfaces (eth0 and eth1) are active and connected to different switches3.
NEW QUESTION # 31
Which three statements are true about the CELLCLI command?
- A. It has command-line history.
- B. It requires root privileges to create CELLDISKS and GRIDDISKS.
- C. It can execute commands on multiple storage servers in parallel.
- D. It can be executed using the DCLI utility.
- E. It can be executed on storage servers.
Answer: A,D,E
Explanation:
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.
NEW QUESTION # 32
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. SQL Plan Quarantine
- B. Cell Offload Quarantine
- C. Database Quarantine
- D. Disk Region Quarantine
- E. Manually created Quarantine
Answer: C,E
NEW QUESTION # 33
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. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
- D. # resize2fs +20G /dev/VGExaDb/LVDbOral
Answer: A
Explanation:
After running the commands above, the filesystem mounted on /u01 is on the logical volume /dev/mapper/VGExaDb-LVDbOral. So, to add 20G of space to the filesystem mounted on /u01, the command that needs to be run is:
lvextend -L +20G --verbose /dev/mapper/VGExaDb-LVDbOral
This command will extend the logical volume /dev/mapper/VGExaDb-LVDbOral by 20 GB of space. It is important to note that the option --verbose is used to display the progress of the operation.
NEW QUESTION # 34
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?
- A. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
- B. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
- C. hardware monitoring using the storage server ILOM
- D. using the CELLCLI list LUN DETAIL command as the celladmin user
Answer: B,C
Explanation:
The CELLCLI CALIBRATE command can be used to check the health of all flash cards in the storage server, and it should be run after logging in as the celladmin user. The hardware monitoring using the storage server ILOM should also be used to check for errors and other potential issues with the flash cards. The CELLCLI list LUN DETAIL command should not be used to identify a damaged or failing flash card, since it will not provide any information about the health of the flash card.
NEW QUESTION # 35
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 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 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
- 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
NEW QUESTION # 36
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 8.0
- B. Oracle Linux 7.7
- C. Oracle Linux 6.9
- D. Oracle Linux 7.5
Answer: D
NEW QUESTION # 37
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 second rack
- B. on all storage servers in both racks
- C. on all database servers in the first rack
- D. on all database servers and at least two storage servers in both racks
- E. on only one database server in both racks
- F. on at least two storage servers in both racks
- G. on all database servers in both racks and one storage server in each rack
Answer: D,F
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 # 38
......
Oracle 1Z0-902 certification exam is a valuable credential for individuals who work with the Oracle Exadata Database Machine X8M. It demonstrates that they have the skills and knowledge necessary to implement and manage this powerful database machine, and can be a valuable asset for organizations that rely on the Oracle Exadata Database Machine X8M for their mission-critical applications.
New 1Z0-902 Test Materials & Valid 1Z0-902 Test Engine: https://gocertify.topexamcollection.com/1Z0-902-vce-collection.html
