GET Real Oracle 1Z0-902 Exam Questions With 100% Refund Guarantee Mar 06, 2024 [Q35-Q49]

Rate this post

GET Real Oracle 1Z0-902 Exam Questions With 100% Refund Guarantee Mar 06, 2024

Get Special Discount Offer on 1Z0-902 Dumps PDF

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

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

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

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

Ask the system administrator to replace the broken disk with a spare.

Check the database to see if any rebalance operations are active.

Call Oracle Support and make an appointment so that the drive can be replaced.

Wait for the email of the failure that Exadata or Enterprise Manager will send.

Download and run the latest exadiag tool.

Wait for a blue light to appear on the disk if the rebalance operation is running.

NEW QUESTION 39
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

1536GB

512GB

2048GB

768GB

1024GB

384GB

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

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

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

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

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

Oracle KVM Guest: This is a virtual machine that runs on top of Oracle Linux KVM hypervisor. It can be used to run Oracle Database or other applications on Exadata Database Machine2. Therefore, it runs on the Database Servers.
Oracle Enterprise Manager Agent (OMA): This is a software agent that communicates with Oracle Enterprise Manager Cloud Control and provides monitoring and management capabilities for Exadata Database Machine2. Therefore, it runs on both Database Servers and Storage Servers.
ASM instance: This is an instance of Oracle Automatic Storage Management (ASM), which is a volume manager and a file system for Oracle Database files. It manages disk groups that span across multiple Storage Servers2. Therefore, it runs on the Database Servers.
RDBMS instance: This is an instance of Oracle Database that processes SQL statements and executes transactions. It uses ASM disk groups to store data files, control files, redo log files, etc2. Therefore, it runs on the Database Servers.
Automatic Diagnostic Repository Command Interpreter (ADRCI): This is a command-line tool that enables you to view diagnostic data stored in the Automatic Diagnostic Repository (ADR). ADR is a file-based repository for database diagnostic data such as trace files, alert logs, etc2. Therefore, ADRCI runs on both Database Servers and Storage Servers, depending on where the ADR is located.
CELLCLI: This is a command-line interface that enables you to configure and manage Exadata Storage Server Software. It allows you to perform tasks such as creating disk groups, monitoring cell health, applying patches, etc2. Therefore, it runs on the Storage Servers.
Cell Server(CELLSRV): This is a process that runs on each Storage Server and handles I/O requests from the Database Servers. It implements Exadata Smart Scan , which offloads data-intensive SQL operations from the Database Servers to the Storage Servers2. Therefore, it runs on the Storage Servers.
diskmon: This is a process that monitors the status of disks and flash devices on each Storage Server. It reports disk failures and performs automatic disk reclamation2. Therefore, it runs on the Storage Servers.
Restart Server (RS): This is a process that manages automatic restarts of critical processes such as CELLSRV , MS , or OMA in case of failures. It also handles graceful shutdowns and startups of all processes on each server2. Therefore, it runs on both Database Servers and Storage Servers.
Management Server (MS): This is a process that provides management services for each server such as collecting metrics , logging events , executing commands from CELLCLI , etc2. Therefore, it runs on both Database Servers and Storage Servers

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

Failed storage server updates are automatically rolled back to a previous release.

To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.

Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.

For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.

Failed database server updates are rolled back to a working state on a previous release automatically.

When running a “yum update” for a new Exadata release, all other repositories should be disabled.

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

NEW QUESTION 48
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.

There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.

OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.

OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.

NEW QUESTION 49
An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical disk?

Replace the failed physical disk.

Add the griddisks back into the ASM diskgroup they used to be a member of.

Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.

Rebalance the data on the effected griddisks before performing a manual drop command.

Create a new celldisk and new griddisks on the replaced physical disk.

Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

Oracle 1Z0-902 exam, also known as the Oracle Exadata Database Machine X8M Implementation Essentials Exam, is designed for IT professionals who want to demonstrate their knowledge and skills in implementing and managing Oracle Exadata Database Machine X8M systems. 1Z0-902 exam is part of the Oracle Certified Specialist (OCS) certification and is recommended for professionals who have experience with Oracle Exadata Database Machine X8M and want to validate their expertise in this area.

PDF Download Oracle Test To Gain Brilliante Result!: https://www.real4dumps.com/1Z0-902_examcollection.html

GET Real Oracle 1Z0-902 Exam Questions With 100% Refund Guarantee Mar 06, 2024 [Q35-Q49]

Leave a Reply Cancel reply

Related Posts

Ace Oracle 1Z0-060 Certification with Actual Questions Oct 26, 2022 Updated [Q68-Q87]

Latest [Jul 13, 2022] Oracle 1Z0-1034-21 Real Exam Dumps PDF [Q16-Q30]

Oracle 1z0-1032-22 Exam Preparation Guide and PDF Download [Q41-Q56]