Latest Oracle 1Z0-902 PDF and Dumps (2024) Free Exam Questions Answers [Q11-Q30]

Latest Oracle 1Z0-902 PDF and Dumps (2024) Free Exam Questions Answers

Pass Your Oracle Engineered Systems 1Z0-902 Exam on Apr 13, 2024 with 60 Questions

The Oracle 1Z0-902 exam consists of 70 multiple-choice questions that need to be completed within a time limit of 105 minutes. The questions are designed to test the candidate’s understanding of the Oracle Exadata Database Machine X8M and its various components. Candidates who pass the exam will receive the Oracle Certified Specialist (OCS) certification, which is recognized worldwide by the IT industry.

Oracle Exadata Database Machine X8M Implementation Essentials exam (1Z0-902) is designed for professionals who want to validate their skills in implementing and maintaining Oracle Exadata Database Machine X8M systems. 1Z0-902 exam measures the candidate's knowledge of the Exadata architecture, software, hardware components, and best practices in configuration and administration.

 

NEW QUESTION # 11
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. You must be physically present in the data center to start an Exadata Storage Server.
• B. -> start /SYS/power
• C. -> start /SYSTEM/power
• D. -> start /System
• E. -> start /SP/console
• F. -> set /SYS power_state=ON

Answer: B

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 # 12
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 physicaldisk attributes name, deviceName, diskType, physicalFirmware
• B. list cell attributes name, deviceName, diskType, physicalFirmware
• C. list celldisk attributes name, deviceName, diskType, physicalFirmware
• D. list devices attributes name, deviceName, diskType, physicalFirmware

Answer: C

NEW QUESTION # 13
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Install in Oracle Virtual Machine with required hardware.
• B. Provide individual x86 64-Bit gateway hardware.
• C. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
• D. Install on Oracle Database Appliance.
• E. Install on Exadata Engineered System.

Answer: B,C,E

Explanation:
These options are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources. The customer can choose to either provide their own x86 64-Bit gateway hardware or purchase the recommended hardware from Oracle, or they can install the gateway on an Exadata Engineered System.

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

• A. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
• B. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
• 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 on a cluster

Answer: A,E,F

NEW QUESTION # 15
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

• A. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.
• B. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
• C. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
• D. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.

Answer: D

Explanation:
Exadata Secure RDMA Fabric isolation is a feature that allows you to use virtualization on the X9M-2 platform while maintaining security and isolation between multiple tenants or VM clusters. Secure Fabric isolation works by creating a dedicated network partition and VLAN ID for each Database VM cluster, which is used for cluster networking between the database servers in the VM Cluster. This ensures that the network traffic of each VM cluster is isolated from the others, and it prevents unauthorized access to the data or resources of other VM clusters. Secure Fabric isolation can also be used for other purposes such as client networking, Data Guard traffic, but it's mainly used to provide security and isolation between multiple tenants or VM clusters.

NEW QUESTION # 16
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

• A. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.
• B. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
• C. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
• D. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.

Answer: D

NEW QUESTION # 17
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. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
• C. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
• D. 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.

Answer: A

Explanation:
In an Automatic Storage Management (ASM) environment, failure groups are used to provide redundancy for the storage disks. Failure groups are used to group together a set of disks and ensure that no two copies of the same data are stored on the same physical disk or storage server. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
For example, if the disks in a failure group are mirrored, one copy of the data is stored on one set of disks, and the other copy is stored on another set of disks. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
ASM failure groups also provide the option to spread the data across different storage servers, this way, even if a storage server fails, data can still be accessed from the other storage servers in the group. This will improve the availability of the data.

NEW QUESTION # 18
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. The sparse_<DBM_NAME> diskgroup is created automatically.
• B. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
• C. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
• D. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
• E. 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.

Answer: C,D

Explanation:
According to the Oracle Exadata Database Machine Technical Architecture1, the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers includes two ASM disk groups: DATA_<DBM_Name> and RECO_<DBM_NAME>. These disk groups are built on hard disks and flash disks inside the Exadata Storage Servers1.
The correct statements about this configuration are:
Option D: There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes. Storage indexes are a feature of Exadata Storage Software that can improve query performance by avoiding unnecessary I/O operations. Storage indexes use a small amount of flash memory to store metadata about data blocks stored on disk1.
Option E: There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs. Exadata Smart Flash Logs are another feature of Exadata Storage Software that can improve database performance by using flash memory as an extension of the database redo log buffer. This can reduce latency and increase throughput for redo log writes1.

NEW QUESTION # 19
Which three statements are true about the CELLCLI command?

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

Answer: A,D,E

Explanation:
The CELLCLI utility is a command line interface to Exadata that enables the execution of commands across multiple storage servers in parallel. It also has command-line history, so users can easily recall previously entered commands. Furthermore, the CELLCLI utility can be executed using the DCLI utility, which provides a convenient way to execute commands on multiple storage servers simultaneously.
However, CELLCLI does not require root privileges to create CELLDISKS and GRIDDISKS, and it cannot be executed on storage servers. This is because CELLCLI is used to manage the Exadata database machine from the database server [1]. For more information about CELLCLI, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

NEW QUESTION # 20
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: A

NEW QUESTION # 21
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU.
Which statement is correct?

• A. A splitter cable can be used to provide power to all PDU cables.
• B. The installation cannot proceed until two power feeds are available per PDU.
• C. The installation can go ahead, no change is required.
• D. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.

Answer: B

Explanation:
An Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs would typically require two power feeds per PDU, one for each of the two power distribution units (PDUs) in the rack. A single power feed per PDU is not sufficient to provide the necessary power to the servers and storage in the rack.

NEW QUESTION # 22
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. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
• B. It is required to install OEDA on the first new database server.
• C. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
• D. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
• E. 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.

Answer: A,C

Explanation:
It is not necessary to execute /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server, nor is it required to install OEDA on the first new database server. 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.
Search results: [1] Refer to the Oracle Exadata Database Machine X9M Implementation Essentials documentation for more information on adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA). [2] Oracle Exadata Deployment Assistant (OEDA) is a graphical user interface (GUI) tool used to configure the Oracle Exadata Database Machine X9M. [3] This article provides the step-by-step instructions to add an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA). [4] It is important to run the OEDA Validate Configuration File step prior to adding the new server to ensure the configuration file is valid and that all required files exist. [5] When adding a new database server with OEDA [1], the configuration file must contain the existing nodes and the new server information must be entered in OEDA. [6] The applyElasticConfig.sh script must be executed to configure the new servers, after which the new servers will be restarted.

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

Answer: C

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 # 24
Which two statements are true in regards to starting the Exadata Virtual Machine?

• A. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
• B. Use vm_maker -start-domain to start a virtual machine manually.
• C. Use vm_maker boot-from-iso command to boot a virtual machine.
• D. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
• E. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.

Answer: A,C

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

Answer: D

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 # 26
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?

• A. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
• B. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
• C. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
• D. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
• E. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.

Answer: C

NEW QUESTION # 27
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

• A. the failure of both physical M.2 disks
• B. the failure of physical disk 1
• C. the failure of physical disk 0 and 11
• D. corruption in the / (root) filesystem
• E. accidental loss of all data from all griddisks in a storage server
• F. corruption in a normal or high redundancy ASM diskgroup
• G. moving all disks from one cell to another as part of a chassis-level component failure

Answer: D,E

Explanation:
Reason B, corruption in the / (root) filesystem, is a valid reason for executing a storage server rescue procedure. If the root filesystem is corrupted, the storage server will no longer be able to boot and will need to be rescued.
Reason F, accidental loss of all data from all griddisks in a storage server, is also a valid reason for executing a storage server rescue procedure. If all data is accidentally lost from the griddisks in a storage server, the server will need to be rescued in order to recover the data.
For more information about the Exadata X9M-2 storage server rescue procedure, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Oracle Exadata Database Machine X9M-2 Storage Server Rescue Procedure - Oracle Docs [3] Oracle Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs [4] Oracle Exadata Database Machine X8M-2 Storage Server Rescue Procedure - Oracle Docs [5] Oracle Exadata Database Machine X9M-2 Storage Server Update Procedure - Oracle Docs [6] Oracle Exadata Database Machine X8M-2 Storage Server Update Procedure - Oracle Docs

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

• A. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
• 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 copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
• D. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
• E. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.

Answer: A

NEW QUESTION # 29
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. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• B. Add 24x 32GB DIMMs.
• C. Add 12x 64GB DIMMs.
• D. Add 16x 32GB DIMMs.
• E. Add 16x 64GB DIMMs.
• F. Add 32x 64GB DIMMs.
• G. Shutdown the Database Server if running.
• H. Remove existing memory modules.
• I. Add 12x 32GB DIMMs.

Answer: F,G,H

Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
https://chriscraftoracle.wordpress.com/2022/11/09/what-makes-exadata-faster/

NEW QUESTION # 30
......

1Z0-902 Dumps for Oracle Engineered Systems Certified Exam Questions and Answer: https://www.exam4labs.com/1Z0-902-practice-torrent.html

1Z0-902 Free Exam Study Guide! (Updated 60 Questions): https://drive.google.com/open?id=1MOvkmheUhUU84_wmfeYd1m-TerheR-Ho