1z1-902 PDF Dumps Real 2023 Recently Updated Questions [Q17-Q32]

ExamBoosts December 1, 2023 1z1-902 > Oracle 0

Rate this post

1z1-902 PDF Dumps Real 2023 Recently Updated Questions

Released Oracle 1z1-902 Updated Questions PDF

Oracle 1Z0-902 certification exam covers various topics related to Oracle Exadata Database Machine X8M, including hardware and software components, networking, storage, backup and recovery, performance tuning, and security. 1z1-902 exam is designed to validate the skills and knowledge required to implement and manage Oracle Exadata Database Machine X8M in a production environment.

Oracle 1Z0-902 exam is a multiple-choice exam consisting of 60 questions. 1z1-902 exam duration is 105 minutes, and candidates must score at least 63% to pass the exam. 1z1-902 exam can be taken online or at an authorized testing center. Candidates can register for the exam on the Oracle website and pay the exam fee.

NEW QUESTION 17
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?

list celldisk attributes name, deviceName, diskType, physicalFirmware

list cell attributes name, deviceName, diskType, physicalFirmware

list physicaldisk attributes name, deviceName, diskType, physicalFirmware

list devices attributes name, deviceName, diskType, physicalFirmware

NEW QUESTION 18
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?

alert logs for Enterprise Manager

alert logs for the ASM instances

Enterprise Manager Alerts on the Exadata Storage Server Grid home page

Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances

alert logs for the prod database instances

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.

NEW QUESTION 19
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?

ifconfig -a legrep “re0| re1”

/opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all

netstat -rn

cat /proc/net/bonding/bondeth0

According to Oracle’s documentation1, the client network on Exadata X9M-2 Database Server is used for client access to the database servers using Single Client Access Name (SCAN) and Oracle RAC Virtual IP (VIP) addresses. To verify that the client network is available via both client switches, you can use the command:
cat /proc/net/bonding/bondeth0
This command displays information about the bondeth0 interface, which is used for the client network on Exadata X9M-2 Database Server2. You can check if both interfaces (eth0 and eth1) are active and connected to different switches3.

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?

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.

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
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

1536GB

512GB

2048GB

768GB

1024GB

384GB

According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the maximum DRAM capacity you can expand an X9M-2 DB Server is 1024GB. This is the maximum amount of DRAM that can be installed in the server. The specific steps for adding DRAM are outlined in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_hardware_memory.html.

NEW QUESTION 22
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.

1. 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.
2. 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 23
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use “Add Equipment” to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use “Add Equipment” to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use “Add Equipment” to add the Exadata X9M Database Servers, starting from RU16.
7. Use “Add Equipment” to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use “Add Equipment” to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use “Add Equipment” to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?

10, 8, 2, 5

4,1, 6, 9

10, 8, 9, 11

7,6,9,11

The correct order of steps is 10, 8, 9, 11. The 10th step is to use the drop down to add Exadata X9M Database Servers, the 8th step is to use the drop down to add Exadata X9M EF Storage Servers, the 9th step is to use “Add Equipment” to add the ZFS Storage Controllers, and the 11th step is to use “Add Equipment” to add the ZFS Storage Trays. These steps are referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html.

NEW QUESTION 24
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

SQL Plan Quarantine

Manually created Quarantine

Database Quarantine

Disk Region Quarantine

Cell Offload Quarantine

A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-software-introduction.html

NEW QUESTION 25
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

NEW QUESTION 26
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?

to the CELLADMIN account by calling CELLCLI on all cells using DCLI

to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli

to the CELLMONITOR account using cellcli interactively on each storage server

to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli

to the CELLMONITOR account calling CELLCLI on all cells using DCLI

to the CELLADMIN account using cellcli interactively on each storage server

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

NEW QUESTION 27
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.

NEW QUESTION 28
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

In order to completely power off an Exadata Database Machine in an orderly fashion, it’s important to properly shut down the cluster first. The command “crscti stop cluster” as root should be executed from one of the database servers.
Once the cluster has been stopped, the next step is to shut down the database servers by executing the command “shutdown -h now” on all database servers.
Next, shut down the Exadata storage servers by executing the command “shutdown -h now” on all Exadata storage servers.
Finally, power off the rack using the power switches on the PDUs.

NEW QUESTION 29
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?

The sparse_<DBM_NAME> diskgroup is created automatically.

There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.

The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.

There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.

There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.

NEW QUESTION 30
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

1. OS I/O metrics using Enterprise Manager host pages for the storage servers: Enterprise Manager provides a detailed view of the storage server’s performance including I/O metrics and statistics. You can use these metrics to analyze I/O performance and identify any bottlenecks.
2. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk: These commands are used to gather information about storage server performance, including I/O statistics, disk usage, and resource allocation.

NEW QUESTION 31
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.

NEW QUESTION 32
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.

Loading …