1z1-902 Dumps 2023 New Oracle 1z1-902 Exam Questions [Q10-Q28]

1z1-902 Dumps 2023 - New Oracle 1z1-902 Exam Questions

Free 1z1-902 braindumps download (1z1-902 exam dumps Free Updated)

Oracle 1z1-902 certification exam is an excellent opportunity for professionals to validate their skills and knowledge in implementing and managing Oracle Exadata Database Machine X8M systems. Passing 1z1-902 exam can lead to new career opportunities and increased earning potential. Professionals who are interested in taking 1z1-902 exam should have a strong background in database administration, database design, and Oracle technologies, and they should be prepared to study a wide range of topics related to Oracle Exadata Database Machine X8M.

 

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

• A. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
• B. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
• C. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
• D. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
• E. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.

Answer: C

Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/new-features-exadata-system-software-release-23.html

NEW QUESTION # 11
Which dbmcli command is NOT valid on Exadata X9M?

• A. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
• B. dbmcli -e "LIST IBPORT DETAIL"
• C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
  B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "

Answer: A

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

• A. changing the root password
• B. configuring secure shell user equivalency for the cellmonitor user
• C. upgrading the Storage Server software package using rpm
• 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: A,B

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 # 13
Which statement is true about the patching features provided in Platinum Services?

• A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
• B. The rolling and complete down time approaches are two options to patching.
• C. Patching is done automatically during business hours.
• D. Patching services are available for the full software stack up to twice per year.

Answer: D

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 # 14
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. Download and run the latest exadiag tool.
• C. Ask the system administrator to replace the broken disk with a spare.
• 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.
• F. Wait for the email of the failure that Exadata or Enterprise Manager will send.

Answer: C

NEW QUESTION # 15
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 # 16
Which two statements are true about applying updates on Exadata systems?

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

Answer: C,D

Explanation:
1. Exadata updates have a rollback feature in case the update fails, this means that the system will roll back to a previous release automatically, this applies to storage servers updates. D. Yum, the package manager used in Exadata, automatically installs a non-UEK kernel when running a regular update, this kernel can be selected to boot from grub.

NEW QUESTION # 17
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.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• C. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• D. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

Answer: C

Explanation:
AccordingtoOraclesdocumentationoneoftheutilitiesfordiagnosticsand
Explanation:
repair of Oracle Exadata Storage Server is ExaWatcher, which collects operating system and network metrics on database servers and storage servers. The utility is located in the /opt/oracle.ExaWatcher directory1.
To investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend, you can use the GetExaWatcherResults.sh script to collect and analyze ExaWatcher data for a specified time range1.
Therefore, the command that you should use to investigate this is:
/opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

NEW QUESTION # 18
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. Multiple Databases on a cluster
• C. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
• D. A single database with one or more schema per application
• E. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
• F. Bare Metal deployment with one database per database server

Answer: A,B,D

Explanation:
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
1. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
2. A single database with one or more schema per application12.
3. Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how

NEW QUESTION # 19
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?

• A. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
• B. to the CELLMONITOR account using cellcli interactively on each storage server
• C. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
• D. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
• E. to the CELLADMIN account using cellcli interactively on each storage server
• F. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli

Answer: A,C,E

Explanation:
To drop all celldisks on all the storage servers in an X9M-2 quarter rack, you should use the CELLADMIN account, which has the necessary privileges to perform this task. You can use the CELLCLI command-line interface to drop the celldisks. The best way to do this is by calling CELLCLI on all cells using DCLI (Oracle Database Command Line Interface) which allows you to run commands on multiple servers at once. Alternatively, you can use an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli. It is not recommended to use the CELLMONITOR account, as it has a more limited set of privileges. It is also important to note that EXACLI is not a valid tool for this task
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html

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

Answer: A,E,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 # 21
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

• A. Disk Region Quarantine
• B. Database Quarantine
• C. SQL Plan Quarantine
• D. Cell Offload Quarantine
• E. Manually created Quarantine

Answer: B,E

NEW QUESTION # 22
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

• A. ASR communicates with Oracle support services using HTTPS.
• B. ASR can upload configuration metadata to support problem resolution.
• C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• D. ASR Manager must be installed and configured on one of the database servers.
• E. Configuring ASR is mandatory for all Database Machine assets.
• F. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.

Answer: D,F

NEW QUESTION # 23
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 will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
• C. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
• 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 # 24
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. Shutdown the Database Server if running.
• B. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• C. Add 12x 64GB DIMMs.
• D. Add 16x 32GB DIMMs.
• E. Add 16x 64GB DIMMs.
• F. Remove existing memory modules.
• G. Add 12x 32GB DIMMs.
• H. Add 32x 64GB DIMMs.
• I. Add 24x 32GB DIMMs.

Answer: A,F,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 # 25
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 VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
• C. 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'.
• D. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

Answer: B,D

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 # 26
Which three statements are true about the CELLCLI command?

• A. It can be executed on storage servers.
• 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 using the DCLI utility.
• 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.

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

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

Answer: B,D

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 # 28
......

Oracle Exadata Database Machine X8M system is a high-performance database machine that is designed to deliver extreme performance for data-intensive workloads. It combines hardware and software technologies to provide fast and efficient processing of large volumes of data. The Oracle 1z1-902 exam covers a range of topics related to this system, including installation and configuration, administration, backup and recovery, and performance tuning.

 

Verified 1z1-902 dumps Q&As - Pass Guarantee Exam Dumps Test Engine: https://www.realexamfree.com/1z1-902-real-exam-dumps.html

1z1-902 Dumps for Pass Guaranteed - Pass 1z1-902 Exam: https://drive.google.com/open?id=1f9cUXUbHD8T8wU69Lwjf-Se4DXBvHI2v