2022 1z1-902 Question Bank: Free PDF Download Recently Updated Questions
1z1-902 Certification Exam Dumps with 62 Practice Test Questions
What is the exam cost of the Oracle 1Z0-902 Exam
Oracle 1Z0-902 Exam price varies greatly depending on the vendor. The average cost of a bundle is 244.09 USD, which includes the exam and all other materials.
How to prepare for Oracle 1Z0-902 Exam
Oracle is one of the leading companies which offers various IT certification exams. These exams are designed by the experts and they help you to secure the job in the top MNCs. The main aim of these exams is to make sure that the candidates can work in the top companies. These exams will help the candidates to get the best job in the IT sector.
As per my opinion, the first step to prepare for any exam is to understand the syllabus of that exam. If you have not studied the syllabus, then you cannot make up your mind to pass the exam. In this regard, it is very important for you to read the syllabus thoroughly before preparing for the exam. Oracle 1Z0-902 exam dumps will boost your skills.
The syllabus of any exam will teach you the topics that you will be tested on. So, before preparing for the exam you must read the syllabus of the exam. If you don't understand any topic, then it is better to study that topic in the class room. There is a good chance that you might fail in the exam if you don't understand the topics.
For more info read reference:
NEW QUESTION 26
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " - B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST IBPORT DETAIL"
Answer: B
NEW QUESTION 27
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?
- A. OECA extends the hardware for the elastic configuration only.
- B. OECA allows one XT storage server in the configuration.
- C. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
- D. OECA facilitates PDU power selection initially and after equipment addition.
- E. OECA reconfigures the size of disk groups and recreates grid disks.
Answer: B,C
NEW QUESTION 28
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?
- A. 3,2,6,4,1,7,5
- B. 2,6,1,4,3,7,5
- C. 3,2,6,1,4,7,5
- D. 4,3,2,6,1,7,5
- E. 2,3,4,6,1,7,5
Answer: E
NEW QUESTION 29
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:
What steps and in which order should they be executed?
- A. 6, 2, 1, 8, 4, 5
- B. 6, 1, 2, 7, 5, 8
- C. 6, 3, 1, 9, 7, 8
- D. 6, 8, 3, 4, 2, 1
Answer: C
NEW QUESTION 30
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?
- A. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- B. alert logs for Enterprise Manager
- C. alert logs for the prod database instances
- D. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
- E. alert logs for the ASM instances
Answer: A,D
NEW QUESTION 31
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. Cisco RDMA over Converged Ethernet (RoCE) switches
- B. power distribution units
- C. power supplies in the database servers
- D. Cisco management switch
- E. RoCE network interface cards in the storage servers
- F. RoCE network interface cards in the database servers
- G. fans in the storage servers
Answer: A,C,D,E
NEW QUESTION 32
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- B. configuring secure shell user equivalency for the cellmonitor user
- C. changing the root password
- D. upgrading the Storage Server software package using rpm
- E. installing an alternative package manager
Answer: C,E
NEW QUESTION 33
Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?
- A. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
- B. It is required to install OEDA on the first new database server.
- C. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
- D. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
- E. In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.
Answer: A,D
NEW QUESTION 34
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. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- C. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- D. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- E. Failed storage server updates are automatically rolled back to a previous release.
- F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
Answer: A,C
NEW QUESTION 35
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?
- A. Copy and execute the script on all storage servers using the dcli command.
- B. Copy and execute the script on all storage servers using the EXACLI command.
- C. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
- D. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- E. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
Answer: B
NEW QUESTION 36
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 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'.
- B. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- C. 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.
- D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
Answer: A,D
NEW QUESTION 37
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?
- A. list devices attributes name, deviceName, diskType, physicalFirmware
- B. list celldisk attributes name, deviceName, diskType, physicalFirmware
- C. list cell attributes name, deviceName, diskType, physicalFirmware
- D. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
Answer: B
NEW QUESTION 38
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 6.9
- B. Oracle Linux 7.7
- C. Oracle Linux 7.5
- D. Oracle Linux 8.0
Answer: C
NEW QUESTION 39
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- B. Bare Metal deployment with one database per database server
- C. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- D. Multiple Databases on a cluster
- E. A single database with one or more schema per application
- F. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
Answer: C,D,F
NEW QUESTION 40
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- B. ASR can upload configuration metadata to support problem resolution.
- C. ASR communicates with Oracle support services using HTTPS.
- 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 41
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?
- A. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- B. 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.
- C. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
- D. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
Answer: B
NEW QUESTION 42
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?
- A. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using
SFP28 transceivers and OM4 fiber cable for client network - B. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
- C. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network
- D. 2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network
Answer: B,D
NEW QUESTION 43
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?
- A. OS I/O metrics using OS tools such as iostat on the storage servers
- B. 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 - C. OS I/O metrics using OS tools such as iostat on the database servers
- D. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
- E. OS I/O metrics using Enterprise Manager host pages for the storage servers
Answer: C,D
NEW QUESTION 44
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?
- A. Sparse
- B. Normal
- C. Extended
- D. External
- E. High
Answer: E
Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf
NEW QUESTION 45
Which are two correct statements about backing up Exadata Database Machine?
- A. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
- B. The M.2 disk is hot pluggable and can be replaced when the power is on, but you will have to restore the system data manually.
- C. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
- D. Backing up Exadata Storage Server Software is critical for restoration.
- E. For high availability, system area can be on the first two disks and M.2 devices.
Answer: A,B
NEW QUESTION 46
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:
How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?
- A. 96 consisting of one griddisk each
- B. 0 because the new griddisks will be added to the existing faiigroups
- C. 7 consisting of 12 griddisks each
- D. 12 consisting of seven griddisks each
- E. 1 consisting of all 96 griddisks
Answer: D
NEW QUESTION 47
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. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- B. Add 32x 64GB DIMMs.
- C. Remove existing memory modules.
- D. Shutdown the Database Server if running.
- E. Add 16x 32GB DIMMs.
- F. Add 12x 32GB DIMMs.
- G. Add 16x 64GB DIMMs.
- H. Add 24x 32GB DIMMs.
- I. Add 12x 64GB DIMMs.
Answer: C,E,G
NEW QUESTION 48
Which statement is true about the patching features provided in Platinum Services?
- A. Patching services are available for the full software stack up to twice per year.
- B. The rolling and complete down time approaches are two options to patching.
- C. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
- D. Patching is done automatically during business hours.
Answer: C
NEW QUESTION 49
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?
- A. 2, 7, 8, and 6
- B. 4, 7, 8, 3, and 6
- C. 2, 8, 7, 3, and 6
- D. 1, 8, 7, 3 and 6
- E. 5, 8, 7, and 6
Answer: A
NEW QUESTION 50
......
Oracle: How to Prepare and Pass the Oracle 1Z0-902 Exam
Study Tips For Completing The Oracle Exadata Database Machine X9M Implementation Essentials
How To Score High on Oracle 1Z0-902 Exam: A guide about how to succeed in the Oracle 1Z0-902 Exam
Are you planning to get the certification of Oracle 1Z0-902 from the leading IT provider, Certifications Pass? If yes, then this question is for you.
To begin with, the certification of Oracle 1Z0-902 is one of the most highly demanded certifications around. So if you want to get a high-paying job and a comfortable career in this competitive field, then you need to go for this certification.
As we have seen in this article, the preparation process for the Oracle 1Z0-902 certification exam is not a walk in the park. But if you do everything right during this period, it is pretty sure that you can achieve success with ease. Certification-Question Oracle 1Z0-902 exam dumps are the best.
We understand that the certification of Oracle 1Z0-902 is not easy, and it requires a lot of dedication and hard work. However, in this article, we are going to discuss the preparation process in detail and teach you how to prepare for this exam without any stress.
New 1z1-902 Exam Dumps with High Passing Rate: https://www.real4dumps.com/1z1-902_examcollection.html
Oracle 1z1-902 Actual Questions and Braindumps: https://drive.google.com/open?id=1bDceORwln3OsPAHvXTwbNonRZiydK6ej
