Use Real Oracle Achieve the 1z1-902 Dumps - 100% Exam Passing Guarantee
Verified 1z1-902 Q&As - Pass Guarantee 1z1-902 Exam Dumps
Prerequisites for Oracle 1Z0-902 Exam
Oracle 1Z0-902 Exam is the most important certification for the IT professionals. Therefore, it is very necessary for you to prepare well for the exam. In order to prepare for the Oracle 1Z0-902 Exam, you should have enough experience in the related fields. We recommend that you should master the concepts of the Java SE platform and the Oracle 1Z0-902 Exam, so that you could pass the Oracle 1Z0-902 Exam easily.
Certification Topics of Oracle 1Z0-902 Exam
Exadata Database Machine Architecture and Key Capabilities
Exadata Database Maintenance Tasks
Exadata Database Machine Updates
Exadata Database Machine Integration
Exadata Database Machine Security
NEW QUESTION 37
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?
- A. Wait for a blue light to appear on the disk if the rebalance operation is running.
- B. Check the database to see if any rebalance operations are active.
- C. Call Oracle Support and make an appointment so that the drive can be replaced.
- D. Wait for the email of the failure that Exadata or Enterprise Manager will send.
E Download and run the latest exadiag tool. - E. Ask the system administrator to replace the broken disk with a spare.
Answer: E
NEW QUESTION 38
You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:
After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?
- A. # resize2fs +20G /dev/VGExaDb/LVDbOral
- B. # xfs_growfs /uOl +20G
- C. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
- D. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
Answer: D
NEW QUESTION 39
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. alert logs for Enterprise Manager
- B. alert logs for the ASM instances
- C. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- D. alert logs for the prod database instances
- E. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
Answer: C,E
NEW QUESTION 40
Which two statements are true about enabling write-back flash cache?
- A. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
- B. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
- C. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
- D. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
- E. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
Answer: A,C
NEW QUESTION 41
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. SQL Plan Quarantine
- B. Manually created Quarantine
- C. Cell Offload Quarantine
- D. Disk Region Quarantine
- E. Database Quarantine
Answer: B,E
NEW QUESTION 42
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. 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.
- B. 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.
- C. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- D. 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.
Answer: B,C
NEW QUESTION 43
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?
- A. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
- B. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
- C. ZFS Snapshots can provide rapid cloning of development and test environment.
- D. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
Answer: B,D
NEW QUESTION 44
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, but are not enabled by default.
- 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 and are enabled by default, however, appropriate roles and users should be created to ensure security.
Answer: D
NEW QUESTION 45
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- B. Run the appropriate patchmgr preqequisite check step for each component being updated.
- C. Run exachk and resolve only WARNINGS that you have not seen before.
- D. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- F. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
Answer: A,B,E,F
NEW QUESTION 46
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?
- A. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- B. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- C. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- D. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
Answer: A
NEW QUESTION 47
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. configuring secure shell user equivalency for the cellmonitor user
- B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- C. installing an alternative package manager
- D. changing the root password
- E. upgrading the Storage Server software package using rpm
Answer: C,D
NEW QUESTION 48
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
Answer: B
NEW QUESTION 49
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?
- A. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
- B. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
- C. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
- D. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
Answer: B,C
NEW QUESTION 50
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 VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- B. 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.
- C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- D. 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'.
Answer: A,D
NEW QUESTION 51
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple Databases on a cluster
- B. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- C. Bare Metal deployment with one database per database server
- D. A single database with one or more schema per application
- E. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- F. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
Answer: A,E,F
NEW QUESTION 52
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. Add 16x 32GB DIMMs.
- B. Remove existing memory modules.
- C. Add 12x 32GB DIMMs.
- D. Shutdown the Database Server if running.
- E. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- F. Add 32x 64GB DIMMs.
- G. Add 24x 32GB DIMMs.
- H. Add 12x 64GB DIMMs.
- I. Add 16x 64GB DIMMs.
Answer: A,B,I
NEW QUESTION 53
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. External
- C. Extended
- D. Normal
- E. High
Answer: E
Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf
NEW QUESTION 54
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. 914mm of space required above the rack height is required for maintenance access.
- B. Oracle Exadata Rack may only be installed on raised floor environments.
- C. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- D. The incline of any access route ramp must be less than or equal to 6 degrees.
- E. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- F. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
Answer: F
NEW QUESTION 55
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?
- A. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
- B. 'crsct1 stop cluster -all' on one of the database servers
- C. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
- D. CellCLI alter GRIDDISK all inactive on the affected storage server
- E. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
- F. shutdown -h now' on the affected storage server
Answer: F
Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB
NEW QUESTION 56
......
Check the Free demo of our 1z1-902 Exam Dumps with 62 Questions: https://www.practicevce.com/Oracle/1z1-902-practice-exam-dumps.html
Clear your concepts with 1z1-902 Questions Before Attempting Real exam: https://drive.google.com/open?id=1ompU_baOwQ8ruaW_IdRsMk5y5ZAhC_rU