
Pass Oracle 1z1-902 Exam With Practice Test Questions Dumps Bundle
2023 Valid 1z1-902 test answers & Oracle Exam PDF
Oracle: How to Prepare and Pass the Oracle 1Z0-902 Exam
Study Tips For Completing The Oracle Exadata Database Machine X9M Implementation Essentials
How To Score High on Oracle 1Z0-902 Exam: A guide about how to succeed in the Oracle 1Z0-902 Exam
Are you planning to get the certification of Oracle 1Z0-902 from the leading IT provider, Certifications Pass? If yes, then this question is for you.
To begin with, the certification of Oracle 1Z0-902 is one of the most highly demanded certifications around. So if you want to get a high-paying job and a comfortable career in this competitive field, then you need to go for this certification.
As we have seen in this article, the preparation process for the Oracle 1Z0-902 certification exam is not a walk in the park. But if you do everything right during this period, it is pretty sure that you can achieve success with ease. Certification-Question Oracle 1Z0-902 exam dumps are the best.
We understand that the certification of Oracle 1Z0-902 is not easy, and it requires a lot of dedication and hard work. However, in this article, we are going to discuss the preparation process in detail and teach you how to prepare for this exam without any stress.
NEW QUESTION 32
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?
- A. the failure of physical disk 0 and 11
- B. corruption in the / (root) filesystem
- C. the failure of physical disk 1
- D. the failure of both physical M.2 disks
- E. moving all disks from one cell to another as part of a chassis-level component failure
- F. accidental loss of all data from all griddisks in a storage server
- G. corruption in a normal or high redundancy ASM diskgroup
Answer: A,B
Explanation:
The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.
NEW QUESTION 33
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. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- 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: 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).
NEW QUESTION 34
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. 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.
- D. 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.
Answer: B,C
Explanation:
A recommended configuration best practice for backup and recovery on Exadata is to place the backup network on dedicated switches installed in the top of the rack (ToR). This provides a greater level of control and isolates the backup network from other workloads. Additionally, even if the backup is limited to writing to four tape drives, it is recommended to specify eight channels to expedite the restore process.
Another best practice is to set the RMAN FILESPERSET parameter to 1 for the level 1 incremental backup set. This will optimize the internal Recovery Appliance backup and restore processing. Finally, if off-site long-term backup retention is needed, Oracle Database Backup Cloud Service should be used as a low-cost, offsite scalable storage solution for a disaster recovery solution.
NEW QUESTION 35
Which statement is true about the Persistent Memory Commit Accelerator?
- A. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
- B. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
- 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 tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
- E. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
Answer: B
NEW QUESTION 36
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 1536GB
- B. 512GB
- C. 2048GB
- D. 768GB
- E. 1024GB
- F. 384GB
Answer: C
Explanation:
The Exadata X9M-2 Database Machine uses powerful database servers, each with two 32-core x86 processors and 512 GB of memory (expandable up to 2 TB).
NEW QUESTION 37
Which statement is true about the patching features provided in Platinum Services?
- A. Patching is done automatically during business hours.
- B. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
- C. Patching services are available for the full software stack up to twice per year.
- D. The rolling and complete down time approaches are two options to patching.
Answer: C
Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
NEW QUESTION 38
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. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- C. Oracle Exadata Rack may only be installed on raised floor environments.
- D. 914mm of space required above the rack height is required for maintenance access.
- E. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- F. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
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
NEW QUESTION 39
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. 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.
- B. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
- C. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
- D. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
- E. It is required to install OEDA on the first new database server.
Answer: B,D
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 40
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR Manager must be installed and configured on one of the database servers.
- B. Configuring ASR is mandatory for all Database Machine assets.
- C. ASR communicates with Oracle support services using HTTPS.
- D. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- E. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- F. ASR can upload configuration metadata to support problem resolution.
Answer: D,E
NEW QUESTION 41
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. 4,3,2,6,1,7,5
- B. 2,3,4,6,1,7,5
- C. 3,2,6,1,4,7,5
- D. 2,6,1,4,3,7,5
- E. 3,2,6,4,1,7,5
Answer: B
NEW QUESTION 42
Which statement is true about the patching features provided in Platinum Services?
- A. Patching is done automatically during business hours.
- B. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
- C. Patching services are available for the full software stack up to twice per year.
- D. The rolling and complete down time approaches are two options to patching.
Answer: C
Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
The correct statement about the patching features provided in Platinum Services is that patching services are available for the full software stack up to twice per year. Oracle Platinum Service covers Exadata storage software and firmware patching, and customers must also perform the database patching. The rolling and complete down time approaches are two options for patching, and patching should be scheduled for times when the system is not being heavily used. Patching is not done automatically during business hours. This is covered in section 4.13 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf Search results: [1] Oracle Exadata Storage Server Patching [1][2]. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest Oracle... [2] Patching and Upgrades. Oracle Database Machine provides automated patching and upgrades for the full Exadata software stack, up to twice a year, with... [3] Virtualized Exadata. Oracle Database Machine X9M-2 comes with a choice of two patching approaches to accommodate different customer needs: Rolling... [4] Jan 10, 2017 ... Exadata Patching Process. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest...
NEW QUESTION 43
Which are two correct statements about backing up Exadata Database Machine?
- A. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
- 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. For high availability, system area can be on the first two disks and M.2 devices.
- D. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
- E. Backing up Exadata Storage Server Software is critical for restoration.
Answer: A,B
NEW QUESTION 44
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?
- A. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- B. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- C. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- D. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
Answer: D
Explanation:
Exachk is an Oracle-provided diagnostic tool that allows you to check various components of an Exadata Database Server, including the client network. The tool is located in the /opt/oracle.SupportTools/exachk/ directory and can be run with the command: exachk. This command can be run with the option -from <Fridays_Date>_17:00:00 and -to <Sundays_Date>_23:59:00 to specify a time range of interest, this way you can check the client network status between the specified time range. The tool checks the status of various components such as network interfaces, InfiniBand fabric, and storage servers. It also analyzes log files, configuration files, and system settings to detect any issues. The tool generates a report, which can be used to identify the root cause of the issue and provide recommendations for resolution.
Tfact1 is a tool to collect diagnostic information from Exadata and non-Exadata systems and it is not related to client network status.
Netcheck and GetExaWatcherResults.sh are not tools provided with the Exadata Database Server and they are not related to client network status.
NEW QUESTION 45
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, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
- D. 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.
- E. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
Answer: C
Explanation:
Oracle KVM Guest, Oracle Enterprise Manager Agent (OMA), RDBMS instance, Automatic Diagnostic Repository Command Interpreter (ADRCI), CELLCLI, diskmon, and Restart Server (RS) can all run on the database servers. The Cell Server (CELLSRV) and Management Server (MS) can both run on the Exadata storage servers. Specific instructions for installing and configuring these software components can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_software_components.html.
NEW QUESTION 46
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 first rack
- B. on at least two storage servers in both racks
- C. on all storage servers in both racks
- D. on all database servers in the second rack
- E. on only one database server in both racks
- F. on all database servers in both racks and one storage server in each rack
- G. on all database servers and at least two storage servers in both racks
Answer: F,G
NEW QUESTION 47
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Cache section within Memory Statistics
- B. PMEM Pool Misses in the Exadata Outlier Summary
- C. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- D. PMEM Cache section within Exadata Smart Statistics
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
Answer: A,D
Explanation:
The AWR report has two sections that show statistics for X9M Persistent Memory Cache: the PMEM Cache section within Memory Statistics and the PMEM Cache section within Exadata Smart Statistics. Both of these sections provide detailed information about the read and write hits and misses, as well as the total capacity and utilization of the PMEM cache. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 515)
NEW QUESTION 48
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?
- A. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
- 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 allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
Answer: C,D
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.
NEW QUESTION 49
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. ASM instances
- C. the storage server ILOM
- D. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- E. the Power Distribution Units (PDUs)
- F. Oracle clusterware on the database server
Answer: B,D,F
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 50
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Provide individual x86 64-Bit gateway hardware.
- B. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- C. Install in Oracle Virtual Machine with required hardware.
- D. Install on Oracle Database Appliance.
- E. Install on Exadata Engineered System.
Answer: B,C,D
NEW QUESTION 51
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- B. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- C. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- D. Run the appropriate patchmgr preqequisite check step for each component being updated.
- E. Run exachk and resolve only WARNINGS that you have not seen before.
- F. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
Answer: A,C,D,F
NEW QUESTION 52
Which three statements are true about the CELLCLI command?
- A. It can be executed using the DCLI utility.
- B. It can execute commands on multiple storage servers in parallel.
- C. It requires root privileges to create CELLDISKS and GRIDDISKS.
- D. It can be executed on storage servers.
- E. It has command-line history.
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.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm
NEW QUESTION 53
......
Top Oracle 1z1-902 Courses Online: https://www.free4torrent.com/1z1-902-braindumps-torrent.html
Free Oracle 1z1-902 Exam Questions and Answer from Training Expert Free4Torrent: https://drive.google.com/open?id=1o6I3q_tWS7kcQLmN2B5GP6HOvVrLwuSY