New Oracle 1Z0-902 Dumps & Questions Updated on 2024
Dumps to Pass your 1Z0-902 Exam with 100% Real Questions and Answers
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. Bare Metal deployment with one database per database server
- C. Multiple Databases on a cluster
- D. A single database with one or more schema per application
- E. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- F. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
Answer: A,C,D
Explanation:
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
A) Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
C) A single database with one or more schema per application12.
E) Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how
NEW QUESTION # 33
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 cell attributes name, deviceName, diskType, physicalFirmware
- B. list celldisk attributes name, deviceName, diskType, physicalFirmware
- C. list devices attributes name, deviceName, diskType, physicalFirmware
- D. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
Answer: D
Explanation:
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html
NEW QUESTION # 34
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 v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
- B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- 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,B
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 # 35
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. Oracle Exadata Rack may only be installed on raised floor environments.
- 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. 914mm of space required above the rack height is required for maintenance access.
- F. The incline of any access route ramp must be less than or equal to 6 degrees.
Answer: B
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)
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/index.html
NEW QUESTION # 36
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 Power Distribution Units (PDUs)
- B. the RDMA over Converged Ethernet (RoCE) switches
- C. Oracle clusterware on the database server
- D. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- E. ASM instances
- F. the storage server ILOM
Answer: C,D,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 # 37
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. Add 12x 32GB DIMMs.
- B. Shutdown the Database Server if running.
- C. Add 24x 32GB DIMMs.
- D. Add 32x 64GB DIMMs.
- E. Add 16x 64GB DIMMs.
- F. Add 16x 32GB DIMMs.
- G. Remove existing memory modules.
- H. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- I. Add 12x 64GB DIMMs.
Answer: B,E,G
Explanation:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
NEW QUESTION # 38
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. 3,2,6,4,1,7,5
- B. 2,6,1,4,3,7,5
- C. 4,3,2,6,1,7,5
- D. 3,2,6,1,4,7,5
- E. 2,3,4,6,1,7,5
Answer: E
NEW QUESTION # 39
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?
- A. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
- B. OECA allows one XT storage server in the configuration.
- C. OECA extends the hardware for the elastic configuration only.
- D. OECA reconfigures the size of disk groups and recreates grid disks.
- E. OECA facilitates PDU power selection initially and after equipment addition.
Answer: C,E
Explanation:
B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.
Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Add Equipment: This input option allows you to allocate RU slots for ... [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Power Selection [1][2]: This input option allows you to select PDU power initially ... [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ...
NEW QUESTION # 40
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. Collected configuration information can be uploaded automatically to Oracle.
- B. It collects configuration information on demand.
- C. It is mandatory to install OCM on at least one database server.
- D. It is mandatory to install OCM on all database servers.
- E. It collects configuration information automatically.
- F. Collected configuration information can be uploaded manually to Oracle.
Answer: C,E,F
NEW QUESTION # 41
An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA 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 can go ahead, no change is required.
- C. The installation cannot proceed until two power feeds are available per PDU.
- 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: C
Explanation:
In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack, and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will be able to provide sufficient power for the system. Therefore, the installation cannot proceed until two power feeds are available per PDU.
For more information about power requirements for Exadata X9M-2 Elastic Racks, 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] Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/exadata-site-requirements.html
NEW QUESTION # 42
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. # xfs_growfs /uOl +20G
- B. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
- C. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
- D. # resize2fs +20G /dev/VGExaDb/LVDbOral
Answer: B
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 # 43
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. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- C. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
- D. 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.
Answer: C
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).
NEW QUESTION # 44
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. 12 consisting of seven griddisks each
- C. 96 consisting of one griddisk each
- D. 7 consisting of 12 griddisks each
- E. 0 because the new griddisks will be added to the existing faiigroups
Answer: B
NEW QUESTION # 45
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 7.5
- B. Oracle Linux 7.9
- C. Oracle Linux 7.7
- D. Oracle Linux 8.0
Answer: D
Explanation:
RoCE, or Remote Direct Memory Access over Converged Ethernet, is a high-speed networking technology that allows data to be transferred between servers, storage, and other devices over Ethernet. Persistent Memory is a form of non-volatile memory that can be used to store data without losing it when power is lost.
Oracle Linux 8.0 supports both RoCE and Persistent Memory, allowing Exadata systems to leverage the benefits of both technologies. For more information on Oracle Linux 8.0 and its features, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
NEW QUESTION # 46
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?
- A. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- B. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- C. alert logs for the prod database instances
- D. alert logs for the ASM instances
- E. alert logs for Enterprise Manager
Answer: C,D
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html
NEW QUESTION # 47
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 v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
- B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- 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: B,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 # 48
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?
- A. alert logs for the ASM instances
- B. alert logs for the prod database instances
- C. alert logs for Enterprise Manager
- D. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- E. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
Answer: D,E
NEW QUESTION # 49
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. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
- C. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
- D. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
Answer: A,C
Explanation:
Oracle Exadata Deployment Assistant (OEDA) enables customers to deploy Oracle Exadata Database Machine in virtualized environments and it support both bare metal and virtual machine deployment in an Exadata X9M Quarter Rack.
OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack, and it sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], OEDA deployment steps include setup, configure, deploy, and manage. The number of VMs in an Exadata rack is limited by the available resources in the rack, such as CPU, Memory, and Storage.
NEW QUESTION # 50
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 7.9
- B. Oracle Linux 7.5
- C. Oracle Linux 7.7
- D. Oracle Linux 8.0
Answer: A
Explanation:
RoCE (RDMA over Converged Ethernet) and Persistent Memory are features that are supported by Oracle Linux. The minimum version of Oracle Linux required to support RoCE and Persistent Memory is Oracle Linux 7.9.
RoCE is a low-latency, high-bandwidth networking technology that enables fast data transfer between servers using converged Ethernet networks. It is supported by Oracle Linux 7.9 and later versions, which includes the necessary kernel modules and user-space libraries to enable RoCE.
Persistent Memory is a technology that allows data to be stored in non-volatile memory (NVM) devices, such as NVDIMMs (Non-Volatile Dual In-line Memory Modules), which can be accessed at near-DRAM speeds. Oracle Linux 7.9 and later versions include support for Persistent Memory, which includes kernel modules and user-space libraries to enable Persistent Memory.
NEW QUESTION # 51
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- B. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " - C. dbmcli -e "LIST IBPORT DETAIL"
Answer: A
NEW QUESTION # 52
......
Updated Exam 1Z0-902 Dumps with New Questions: https://www.dumpsvalid.com/1Z0-902-still-valid-exam.html
Today Updated 1Z0-902 Exam Dumps Actual Questions: https://drive.google.com/open?id=1EaMbQolDnz5SbzSBXVmJEG5Q1KdyOeo8