Unique Top-selling 1Z0-902 Exams – New 2022 Oracle Pratice Exam [Q17-Q40]

Rate this post

Unique Top-selling 1Z0-902 Exams – New 2022 Oracle Pratice Exam

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

Prerequisites for Oracle 1Z0-902 Exam

Oracle 1Z0-902 Exam is the most important certification for the IT professionals. Therefore, it is very necessary for you to prepare well for the exam. In order to prepare for the Oracle 1Z0-902 Exam, you should have enough experience in the related fields. We recommend that you should master the concepts of the Java SE platform and the Oracle 1Z0-902 Exam, so that you could pass the Oracle 1Z0-902 Exam easily.

Q17. Which two activities are supported on the storage servers in an Exadata Database Machine?

changing the root password

upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

installing an alternative package manager

upgrading the Storage Server software package using rpm

configuring secure shell user equivalency for the cellmonitor user

Q18. Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?

using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

using the CELLCLI CALIBRATE command on the storage server after logging in as the root user

hardware monitoring using the storage server ILOM

using the CELLCLI list LUN DETAIL command as the celladmin user

Q19. Examine these commands:
1. Execute “crscti stop cluster -all” as the grid user from one database server.
2. Execute “crscti stop cluster -all” as root from one database server.
3. Power off all network switches.
4. Execute “crscti stop cluster” as root from one database server.
5. Execute “crscti stop cluster” as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute “shutdown -h now” on all database servers.
8. Execute “shutdown -h now” on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?

5, 8, 7, and 6

4, 7, 8, 3, and 6

2, 8, 7, 3, and 6

2, 7, 8, and 6

1, 8, 7, 3 and 6

Q20. Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.

Run exachk and resolve only WARNINGS that you have not seen before.

Run the appropriate patchmgr preqequisite check step for each component being updated.

Run patchmgr –all_comp -autofix -autobackup -upgrade -rolling.

For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.

Q21. 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?

-> start /System

-> start /SP/console

-> set /SYS power_state=ON

You must be physically present in the data center to start an Exadata Storage Server.

-> start /SYSTEM/power

-> start /SYS/power

Q22. Which two statements are true about enabling write-back flash cache?

Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.

Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.

When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

Before write-back flash cache is enabled, you need to drop the Flash Cache first.

When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.

Q23. You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?

Copy and execute the script on all storage servers using the EXACLI command.

Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.

Copy and execute the script on all storage servers using the dcli command.

Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.

Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.

Q24. What are two recommended configuration best practices for backup and recovery on Exadata?

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.

Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

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.

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.

Q25. You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?

dbmcli -e “set alert ds_temp> 30” on each database server

dbmcli -e “set threshold ds_temp comparison=’ >’, critical=30” on each database server

dbmcli -e “alert metriccurrent ds_temp where metricValue > 30” on each database server

dbmcli -e “create threshold ds_temp comparison=’>’, critical=30” on each database server

Q26. 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 splitter cable can be used to provide power to all PDU cables.

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.

The installation cannot proceed until two power feeds are available per PDU.

The installation can go ahead, no change is required.

Q27. Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

Install on Oracle Database Appliance.

Provide individual x86 64-Bit gateway hardware.

Install in Oracle Virtual Machine with required hardware.

Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Install on Exadata Engineered System.

Q28. You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

6, 2, 1, 8, 4, 5

6, 8, 3, 4, 2, 1

6, 3, 1, 9, 7, 8

6, 1, 2, 7, 5, 8

Q29. Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.

914mm of space required above the rack height is required for maintenance access.

The incline of any access route ramp must be less than or equal to 6 degrees.

All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.

Oracle Exadata Rack may only be installed on raised floor environments.

A conditioned space is required to remove the packaging material to reduce particles before entering the data center.

Q30. 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?

OS I/O metrics using Enterprise Manager host pages for the storage servers

OS I/O metrics using OS tools such as iostat on the database servers

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

cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

OS I/O metrics using OS tools such as iostat on the storage servers

Q31. Which two statements are true in regards to starting the Exadata Virtual Machine?

To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.

Use vm_maker -start-domain to start a virtual machine manually.

Use vm_maker boot-from-iso command to boot a virtual machine.

To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.

Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.

Q32. 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?

YOU query VSSYSTEM_EVENTS and filter for the event ‘cell physical IO interconnect bytes returned by smart scan’, associated to your table.

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’.

You query v$SYSTAT and filter for the statistic ‘cell smart table scan’, associated to your table.

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.

Q33. How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

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.

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.

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.

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.

Q34. 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?

The installation can go ahead, no change is required.

The installation cannot proceed until two power feeds are available per PDU.

A splitter cable can be used to provide power to all PDU cables.

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.

Q35. 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?

2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.

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.

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.

3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.

1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.

Q36. Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary

PMEM Pool Misses in the Exadata Outlier Summary

cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary

PMEM Cache section within Memory Statistics

PMEM Cache section within Exadata Smart Statistics

Q37. Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

Add 12x 32GB DIMMs.

Add 12x 64GB DIMMs.

Shutdown the Database Server if running.

Add 16x 32GB DIMMs.

Add 16x 64GB DIMMs.

Memory cannot be expanded on Exadata X9M-2 Database Servers.

Remove existing memory modules.

Add 32x 64GB DIMMs.

Add 24x 32GB DIMMs.

Q38. Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?

Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.

Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.

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.

The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.

It is required to install OEDA on the first new database server.

Q39. For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

RoCE network interface cards in the storage servers

fans in the storage servers

Cisco RDMA over Converged Ethernet (RoCE) switches

RoCE network interface cards in the database servers

power distribution units

Cisco management switch

power supplies in the database servers

Q40. How do ASM failure groups provide redundancy?

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.

Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

Best way to practice test for Oracle 1Z0-902: https://www.testsimulate.com/1Z0-902-study-materials.html

Prerequisites for Oracle 1Z0-902 Exam

Leave a Reply Cancel reply