Free 1Z0-902 Exam Braindumps certification guide Q&A [Q12-Q31]

Rate this post

Free 1Z0-902 Exam Braindumps certification guide Q&A

1Z0-902 Certification Overview Latest 1Z0-902 PDF Dumps

Oracle 1z1-902 exam is a computer-based test that consists of 70 multiple-choice questions. Candidates have two hours to complete the exam and must score at least 65% to pass. 1Z0-902 exam can be taken at any Pearson VUE testing center worldwide.

Know about the Passing Score, Duration & Questions for the Oracle 1Z0-902 Exam

Time Duration: 90 Minutes
The passing score: 64%
Languages: English
Formate: Multiple Choice
Number of Questions: 60 Questions

NO.12 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?

patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.

patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.

NO.13 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.

NO.14 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.

NO.15 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

NO.16 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.

NO.17 Which three statements are true about the CELLCLI command?

It can execute commands on multiple storage servers in parallel.

It has command-line history.

It requires root privileges to create CELLDISKS and GRIDDISKS.

It can be executed on storage servers.

It can be executed using the DCLI utility.

NO.18 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.

NO.19 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?

Exadata storage realms using ASM-scoped security mode

File permissions on the griddisks in each database server

Using EXADCLI instead of CELLCLI to create the griddisks

File permissions on the griddisks in each storage server

Exadata storage realms using database-scoped security mode

NO.20 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.

NO.21 What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

Oracle Linux 7.5

Oracle Linux 7.9

Oracle Linux 8.0

Oracle Linux 7.7

NO.22 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

NO.23 You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?

Install Oracle Rest Data Services on each Database server and install the MS APEX application.

The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.

Install Oracle Rest Data Services on each Storage server and install the MS APEX application.

The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.

NO.24 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.

NO.25 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.

NO.26 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

NO.27 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.

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

NO.29 You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?

ASM instances

Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers

the storage server ILOM

the Power Distribution Units (PDUs)

Oracle clusterware on the database server

the RDMA over Converged Ethernet (RoCE) switches

NO.30 Which three of the following options are available for database consolidation on Exadata?

Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

Bare Metal deployment with one database per database server

A single database with one or more schema per application

Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently

Multiple Databases on a cluster

Multiple Virtual Machine clusters supporting a single database for greatest resource isolation

NO.31 Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

OECA reconfigures the size of disk groups and recreates grid disks.

OECA extends the hardware for the elastic configuration only.

OECA allows one XT storage server in the configuration.

OECA’s “Add Equipment” input option allows allocation of RU slots for customer equipment.

OECA facilitates PDU power selection initially and after equipment addition.

Oracle 1Z0-902: Oracle Exadata Database Machine X8M Implementation Essentials exam is designed to validate the skills and knowledge of professionals who are looking to implement Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification exam is intended to test the candidate’s ability to install, configure, and manage Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification is widely recognized in the IT industry and can help professionals advance their careers. The Exadata Database Machine X8M is a high-performance database machine designed for running Oracle Database workloads. The machine is designed to deliver extreme performance, scalability, and reliability.

The Best Oracle 1Z0-902 Study Guides and Dumps of 2024: https://www.trainingdump.com/Oracle/1Z0-902-practice-exam-dumps.html

Free 1Z0-902 Exam Braindumps certification guide Q&A [Q12-Q31]