2023 1Z0-902 dumps review – Professional Quiz Study Materials [Q32-Q51]

Rate this post

2023 1Z0-902 dumps review – Professional Quiz Study Materials

1Z0-902 Test Prep Training Practice Exam Questions Practice Tests

Oracle Exadata Database Machine X8M is an engineered system that enables organizations to run their mission-critical database workloads faster and more efficiently. It combines the latest hardware and software technologies to provide high-performance computing, storage, and networking capabilities. With the Oracle Exadata Database Machine X8M, organizations can achieve significant improvements in performance, scalability, and reliability.

Oracle 1z1-902 exam consists of 60 multiple-choice questions that must be completed within 105 minutes. 1Z0-902 exam covers a range of topics, including the architecture and components of Oracle Exadata database machines, the installation and configuration of Exadata software and hardware, database administration and performance tuning, and backup and recovery techniques. Candidates who pass 1Z0-902 exam will become Oracle certified professionals in Oracle Exadata database machine X8M implementation essentials.

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

Q33. Which dbmcli command is NOT valid on Exadata X9M?

dbmcli -e “LIST METRICHISTORY WHERE name LIKE ‘DS_.*'”

dbmcli -e “LIST METRICCURRENT WHERE name = ‘DS_TEMP’ “

dbmcli -e “LIST IBPORT DETAIL”

dbmcli -e “LIST ALERTHISTORY WHERE agelnMinutes < 15”

Q34. Which statement is true about the patching features provided in Platinum Services?

Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

Patching services are available for the full software stack up to twice per year.

The rolling and complete down time approaches are two options to patching.

Patching is done automatically during business hours.

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…

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

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

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

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

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

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

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

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

Q43. Which dbmcli command is NOT valid on Exadata X9M?

dbmcli -e “LIST METRICHISTORY WHERE name LIKE ‘DS_.*'”

dbmcli -e “LIST METRICCURRENT WHERE name = ‘DS_TEMP’ “

dbmcli -e “LIST IBPORT DETAIL”

dbmcli -e “LIST ALERTHISTORY WHERE agelnMinutes < 15”

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

Q45. You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?

4,3,2,6,1,7,5

3,2,6,4,1,7,5

2,3,4,6,1,7,5

3,2,6,1,4,7,5

2,6,1,4,3,7,5

Q46. You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?

on at least two storage servers in both racks

on only one database server in both racks

on all database servers in the first rack

on all storage servers in both racks

on all database servers and at least two storage servers in both racks

on all database servers in the second rack

on all database servers in both racks and one storage server in each rack

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

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

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

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