Jan-2024 Oracle 1Z0-902 Certification Real 2024 Mock Exam
1Z0-902 Exam Questions and Valid PMP Dumps PDF
Oracle 1Z0-902 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
Oracle 1z1-902: Oracle Exadata Database Machine X8M Implementation Essentials is an exam that tests the knowledge and skills of IT professionals in implementing and managing Oracle Exadata Database Machine X8M. 1Z0-902 exam is designed to validate the candidate's ability to install, configure, and optimize the Exadata Database Machine, which is a high-performance database machine that combines hardware and software to deliver unmatched performance, availability, and scalability for mission-critical databases.
NEW QUESTION # 27
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 /System
- C. -> start /SP/console
- D. -> start /SYSTEM/power
- E. -> start /SYS/power
- F. You must be physically present in the data center to start an Exadata Storage Server.
Answer: E
Explanation:
ILOM (Integrated Lights Out Manager) is a remote management system that allows you to control and monitor Exadata Database Machine components, such as storage servers and database servers, from a remote location. The command "start /SYS/power" is used to power on the storage server in the Exadata Database Machine after hardware maintenance. This command can be executed remotely via ILOM.
NEW QUESTION # 28
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. configuring secure shell user equivalency for the cellmonitor user
- B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- C. upgrading the Storage Server software package using rpm
- D. changing the root password
- E. installing an alternative package manager
Answer: A,D
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
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?
- A. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
- B. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
- C. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.
- D. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
Answer: B
Explanation:
To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e "ALTER CELL ENABLE REST" and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).
https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/access-rest-api.html
NEW QUESTION # 30
How do ASM failure groups provide redundancy?
- A. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- B. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- C. 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.
- D. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
Answer: C
Explanation:
Failure groups provide redundancy in Oracle Exadata Database Machine X9M by ensuring that mirror copies of the data are written to different storage servers [1][2]. This prevents the potential for mirror copies to be written to the same server, which would cause a data loss if that server were to experience a physical disk failure. Furthermore, failure groups help to ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster, providing an extra layer of data protection. Additionally, Extended Redundancy mirrors data across data centers, providing the highest levels of data protection. Reference: Oracle Exadata Database Machine X9M Implementation Essentials [1][2], Chapter 5: Configuring Oracle ASM.
NEW QUESTION # 31
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 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 Manager must be installed and configured on one of the database servers.
- E. ASR can upload configuration metadata to support problem resolution.
- F. Configuring ASR is mandatory for all Database Machine assets.
Answer: B,D
NEW QUESTION # 32
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. OS I/O metrics using OS tools such as iostat on the database servers
- B. OS I/O metrics using Enterprise Manager host pages for the storage servers
- C. OS I/O metrics using OS tools such as iostat on the storage servers
- D. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
- 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: B,D
Explanation:
1. OS I/O metrics using Enterprise Manager host pages for the storage servers: Enterprise Manager provides a detailed view of the storage server's performance including I/O metrics and statistics. You can use these metrics to analyze I/O performance and identify any bottlenecks.
2. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk: These commands are used to gather information about storage server performance, including I/O statistics, disk usage, and resource allocation.
NEW QUESTION # 33
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. Cisco management switch
- B. RoCE network interface cards in the storage servers
- C. fans in the storage servers
- D. power supplies in the database servers
- E. Cisco RDMA over Converged Ethernet (RoCE) switches
- F. power distribution units
- G. RoCE network interface cards in the database servers
Answer: B,D,E,F
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 # 34
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- B. dbmcli -e "LIST IBPORT DETAIL"
- C. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
Answer: C
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 # 35
Which two statements are true in regards to starting the Exadata Virtual Machine?
- A. Use vm_maker -start-domain to start a virtual machine manually.
- B. Use vm_maker boot-from-iso command to boot a virtual machine.
- C. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
- D. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
- E. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
Answer: A,E
NEW QUESTION # 36
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 512GB
- B. 1024GB
- C. 384GB
- D. 768GB
- E. 1536GB
- F. 2048GB
Answer: E
Explanation:
According to 1, Exadata X9M-2 Database Servers are based on Intel Xeon Platinum 8368Y processors with 32 cores and 768 GB of DRAM memory per server. This memory can be expanded up to 1.5 TB per server by adding 24 x 32 GB DIMMs. The DRAM memory is used for buffer cache, PGA, and other database purposes1. Exadata X9M-2 Database Servers also have 25.6 TB of Persistent Memory Acceleration (PMEM) per server, which is used for log writes and columnar data caching1. PMEM is a new type of memory that combines the speed of DRAM with the persistence of flash2. Exadata X9M-2 Database Servers are designed to run Oracle Database workloads with high performance, scalability, and reliability2
NEW QUESTION # 37
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. cat /proc/net/bonding/bondeth0
- B. netstat -rn
- C. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
- D. ifconfig -a legrep "re0| re1"
Answer: A
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 # 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. 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.
- C. Backing up Exadata Storage Server Software is critical for restoration.
- D. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
- E. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
Answer: C,D
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
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. ifconfig -a legrep "re0| re1"
- 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 # 40
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 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client 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 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network
Answer: A,B
NEW QUESTION # 41
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 # 42
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 7.9
- B. Oracle Linux 8.0
- C. Oracle Linux 7.7
- D. Oracle Linux 7.5
Answer: A
Explanation:
Oracle Linux 7.9 is the minimum version required to support RoCE and Persistent Memory. This is because Oracle Linux 7.9 includes kernel enhancements that enable RDMA over Converged Ethernet (RoCE) networking and Intel Optane DC Persistent Memory Modules (DCPMM) for Exadata X8M systems3. These features allow faster access latency and higher throughput for database workloads2.
NEW QUESTION # 43
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:
How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?
- A. 1 consisting of all 96 griddisks
- B. 96 consisting of one griddisk each
- C. 0 because the new griddisks will be added to the existing faiigroups
- D. 7 consisting of 12 griddisks each
- E. 12 consisting of seven griddisks each
Answer: A
Explanation:
This SQL statement is adding the new griddisks to the existing diskgroup "DATA" and creating one new failgroup, consisting of all 96 griddisks. The "REBALANCE POWER 512" option tells the system to perform a rebalance operation with a power of 512. It means the system distributes the data evenly across all the disks in the diskgroup using a power of 512.
NEW QUESTION # 44
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Run exachk and resolve only WARNINGS that you have not seen before.
- B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- C. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- D. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- E. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- F. Run the appropriate patchmgr preqequisite check step for each component being updated.
Answer: C,D,E,F
NEW QUESTION # 45
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 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
- B. 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
- 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 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
Answer: B,C
Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
NEW QUESTION # 46
......
Oracle Exadata Database Machine is a high-performance engineered system that is designed to provide faster, more efficient, and more secure data processing capabilities. The X8M is the latest version of this machine that is equipped with advanced hardware and software features. Oracle 1z1-902 exam is specifically designed to test the knowledge and skills of IT professionals who want to implement and manage this cutting-edge technology.
1Z0-902 Question Bank: Free PDF Download Recently Updated Questions: https://actualtests.vceengine.com/1Z0-902-vce-test-engine.html
