• Home
  • Articles
  • 100% Pass Top-selling 1z1-902 Exams - New 2023 Oracle Pratice Exam [Q23-Q41]

100% Pass Top-selling 1z1-902 Exams - New 2023 Oracle Pratice Exam [Q23-Q41]

Share

100% Pass Top-selling 1z1-902 Exams - New 2023 Oracle Pratice Exam

Oracle Engineered Systems Dumps 1z1-902 Exam for Full Questions - Exam Study Guide


Oracle Exadata Database Machine X8M is a high-performance database machine that is designed to deliver the best-in-class performance, scalability, and reliability for enterprise workloads. It is an ideal solution for organizations that require fast and efficient processing of large amounts of data. The Oracle Exadata Database Machine X8M is built on a powerful combination of hardware and software technologies that work together to deliver exceptional performance.

 

NEW QUESTION # 23
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?

  • A. Extended
  • B. Normal
  • C. High
  • D. External
  • E. Sparse

Answer: C

Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the customer should use the High redundancy level for their ASM storage in order to ensure that their data is available on the Exadata machine during updates. The High redundancy level provides the most protection against single-node server failure, as it stores three copies of each data file on separate nodes. This is the same redundancy level used for the Oracle Database's Control Files and Redo Logs. Instructions for configuring the ASM redundancy level can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_asm_overview.html.


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

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

Answer: B,C,D

Explanation:
The statements that are true about the CellCLI command are:
It has command-line history . According to 1, you can use the up and down arrow keys to scroll through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a previous command by entering part of it .
It can be executed on storage servers . According to 1, you can invoke CellCLI by logging in to the Exadata cell as cellmonitor , celladmin , or root user and typing "cellcli" . Within CellCLI , you can perform various management and monitoring tasks for the cell134.
It can be executed using the DCLI utility . According to 5, DCLI (distributed CLI) is another utility that can be used to execute scripts and commands across multiple storage cells from a single interface. You can use DCLI to run CellCLI commands on multiple cells at once54.


NEW QUESTION # 25
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

  • A. It collects configuration information automatically.
  • B. Collected configuration information can be uploaded manually to Oracle.
  • C. It collects configuration information on demand.
  • D. It is mandatory to install OCM on all database servers.
  • E. It is mandatory to install OCM on at least one database server.
  • F. Collected configuration information can be uploaded automatically to Oracle.

Answer: A,C,F

Explanation:
It collects configuration information automatically (B). OCM gathers detailed configuration information about a variety of designated Oracle products and components across an enterprise on a regular basis2.
It collects configuration information on demand . OCM can also collect configuration information manually when requested by the user or by Oracle Support2.
Collected configuration information can be uploaded automatically to Oracle (E). OCM can upload the collected configuration information to My Oracle Support automatically for analysis and support purposes3.


NEW QUESTION # 26
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

  • A. OECA facilitates PDU power selection initially and after equipment addition.
  • B. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
  • C. OECA reconfigures the size of disk groups and recreates grid disks.
  • D. OECA allows one XT storage server in the configuration.
  • E. OECA extends the hardware for the elastic configuration only.

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

Answer: E

Explanation:
This command is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. This command sets the power state of the system to ON and starts the storage server. It is the only command that is able to start the storage server remotely. All the other commands are incorrect or require the user to be physically present in the data center.


NEW QUESTION # 28
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. Check the database to see if any rebalance operations are active.
  • B. Ask the system administrator to replace the broken disk with a spare.
  • C. Wait for the email of the failure that Exadata or Enterprise Manager will send.
    E Download and run the latest exadiag tool.
  • D. Call Oracle Support and make an appointment so that the drive can be replaced.
  • E. Wait for a blue light to appear on the disk if the rebalance operation is running.

Answer: B


NEW QUESTION # 29
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

  • A. File permissions on the griddisks in each database server
  • B. Exadata storage realms using database-scoped security mode
  • C. Using EXADCLI instead of CELLCLI to create the griddisks
  • D. File permissions on the griddisks in each storage server
  • E. Exadata storage realms using ASM-scoped security mode

Answer: C,D


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

Answer: A,D,F

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 # 31
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. 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.
  • B. The installation can go ahead, no change is required.
  • C. The installation cannot proceed until two power feeds are available per PDU.
  • D. A splitter cable can be used to provide power to all PDU cables.

Answer: C

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 # 32
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

  • A. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
  • B. ZFS Snapshots can provide rapid cloning of development and test environment.
  • C. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
  • D. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.

Answer: A,D


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

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

Answer: B,C,D

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 # 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 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.
  • 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 query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

Answer: C,D

Explanation:
A) YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
C) You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/


NEW QUESTION # 35
Which two statements are true about applying updates on Exadata systems?

  • A. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
  • B. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
  • C. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
  • D. Failed database server updates are rolled back to a working state on a previous release automatically.
  • E. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
  • F. Failed storage server updates are automatically rolled back to a previous release.

Answer: D,F

Explanation:
When applying updates on Exadata systems, database server updates are automatically rolled back to a working state on a previous release if the update fails. This ensures that the system can be restored to a working state in the event of a failed update. Additionally, storage server updates are also automatically rolled back to a previous release in the event of a failed update.
This is documented in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and more information can be found on the Oracle support website [1][2].


NEW QUESTION # 36
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 the Storage Server software package using rpm
  • C. changing the root password
  • D. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
  • E. installing an alternative package manager

Answer: A,C

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 # 37
What are two recommended configuration best practices for backup and recovery on Exadata?

  • A. 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.
  • 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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

Answer: A,B

Explanation:
According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
A) 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.
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.


NEW QUESTION # 38
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. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
  • E. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.

Answer: B,D


NEW QUESTION # 39
Which two activities are supported on the storage servers in an Exadata Database Machine?

  • A. changing the root password
  • B. upgrading the Storage Server software package using rpm
  • C. configuring secure shell user equivalency for the cellmonitor user
  • D. installing an alternative package manager
  • E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

Answer: B,E

Explanation:
Exadata Database Machine is a preconfigured and optimized for database workloads. The storage servers in an Exadata Database Machine are used to store database data, and support activities such as upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure and upgrading the Storage Server software package using rpm. These activities are related to maintain the storage servers performance and security. Changing the root password, installing an alternative package manager, and configuring secure shell user equivalency for the cellmonitor user are activities that can be performed on any Linux machine, but they are not specific to Exadata Database Machine.


NEW QUESTION # 40
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

  • A. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
  • B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
  • C. Run the appropriate patchmgr preqequisite check step for each component being updated.
  • D. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
  • E. Run exachk and resolve only WARNINGS that you have not seen before.
  • F. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.

Answer: A,B,C,D

Explanation:
For database servers, perform a server backup using patchmgr -dbnodes dblistfile -backup -rolling. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book . The other statement is false as exachk should not be used to resolve warnings or errors [1], but rather to identify them so that they can be addressed. Additionally, patchmgr should not be used with the --autofix, --autobackup, --upgrade, or --rolling flags as this could cause unexpected issues.


NEW QUESTION # 41
......


Oracle Exadata Database Machine X8M is a high-performance, integrated system that combines the power of Oracle Database with the latest hardware technology. This machine is designed to deliver extreme performance, scalability, and reliability, making it an ideal solution for large-scale data warehousing and transaction processing. The Oracle 1Z0-902 certification exam is designed to ensure that professionals who are responsible for the implementation and administration of Exadata Database Machine X8M solutions have the necessary skills and knowledge to maximize the benefits of this powerful system. By earning this certification, professionals can demonstrate their expertise and advance their careers in the field of database administration.

 

Authentic Best resources for 1z1-902 Online Practice Exam: https://www.testpdf.com/1z1-902-exam-braindumps.html

1z1-902 Test Engine Practice Exam: https://drive.google.com/open?id=1XpL5nt15Ao5f5ic6vq1U9jJu0yjEmZl1

Related Articles

more
Oracle 1z1-902 Certification Practice Exam