View 1z1-902 Exam Question Dumps With Latest Demo [Nov 19, 2022]
Free 1z1-902 Test Questions Real Practice Test Questions
Target Audience of Oracle 1Z0-902 Exam
The target audience for this certification exam include:
Analyst/consultant: This candidate needs to have experience in business intelligence and data warehousing technologies and practices. These candidates will be expected to help other people with their careers by using these tools.
Information architect: This candidate needs to have experience designing enterprise portals and intranet sites, as well as designing web applications and databases for small businesses, medium-sized companies and large enterprises. They will also be expected to create custom applications based on these applications' specifications.
Database administrator: This candidate needs experience in administering large databases at various levels of scale (small-medium-large). They will be expected to manage these databases effectively according to deadlines set by their employers or clients within an organization's budget constraints.
Oracle 1z1-902 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
NEW QUESTION 34
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- B. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- C. 914mm of space required above the rack height is required for maintenance access.
- D. Oracle Exadata Rack may only be installed on raised floor environments.
- E. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- F. The incline of any access route ramp must be less than or equal to 6 degrees.
Answer: A
NEW QUESTION 35
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. 1, 8, 7, 3 and 6
- B. 2, 8, 7, 3, and 6
- C. 5, 8, 7, and 6
- D. 4, 7, 8, 3, and 6
- E. 2, 7, 8, and 6
Answer: E
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?
- A. Add 24x 32GB DIMMs.
- B. Add 16x 64GB DIMMs.
- C. Add 12x 64GB DIMMs.
- D. Remove existing memory modules.
- E. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- F. Add 32x 64GB DIMMs.
- G. Add 16x 32GB DIMMs.
- H. Shutdown the Database Server if running.
- I. Add 12x 32GB DIMMs.
Answer: B,D,G
NEW QUESTION 37
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?
- A. 44, 6, 9
- B. 7,6,9,11
- C. 0
- D. 10, 8, 9, 11
- E. 10, 8, 2, 5
Answer: D
NEW QUESTION 38
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, 8, 3, 4, 2, 1
- C. 6, 1, 2, 7, 5, 8
- D. 6, 3, 1, 9, 7, 8
Answer: D
NEW QUESTION 39
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. Check the database to see if any rebalance operations are active.
- B. Ask the system administrator to replace the broken disk with a spare.
- C. Wait for a blue light to appear on the disk if the rebalance operation is running.
- D. Call Oracle Support and make an appointment so that the drive can be replaced.
- E. Wait for the email of the failure that Exadata or Enterprise Manager will send.
E Download and run the latest exadiag tool.
Answer: B
NEW QUESTION 40
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. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
- B. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
- C. 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.
- D. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
- E. It is required to install OEDA on the first new database server.
Answer: B,D
NEW QUESTION 41
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?
- A. 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.
- B. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
- C. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
- D. 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.
- E. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
Answer: A
NEW QUESTION 42
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 Exadata Storage Server Grid home page
- B. alert logs for the prod database instances
- C. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- D. alert logs for Enterprise Manager
- E. alert logs for the ASM instances
Answer: A,C
NEW QUESTION 43
Which are two correct statements about backing up Exadata Database Machine?
- A. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
- B. For high availability, system area can be on the first two disks and M.2 devices.
- C. Backing up Exadata Storage Server Software is critical for restoration.
- D. 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.
- E. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
Answer: D,E
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. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
- B. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- C. 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.
- D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
Answer: C
NEW QUESTION 45
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 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
- 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 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
Answer: A,B
NEW QUESTION 46
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?
- A. Exadata storage realms using ASM-scoped security mode
- B. Using EXADCLI instead of CELLCLI to create the griddisks
- C. File permissions on the griddisks in each storage server
- D. Exadata storage realms using database-scoped security mode
- E. File permissions on the griddisks in each database server
Answer: B,C
NEW QUESTION 47
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. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- B. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- C. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- D. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
Answer: B
NEW QUESTION 48
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. 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.
- B. 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.
- C. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- D. 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.
Answer: A,C
NEW QUESTION 49
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. 'crsct1 stop cluster -all' on one of the database servers
- B. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
- C. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
- D. CellCLI alter GRIDDISK all inactive on the affected storage server
- E. shutdown -h now' on the affected storage server
- F. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
Answer: E
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 50
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?
- A. Rebalance the data on the effected griddisks before performing a manual drop command.
- B. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- C. Replace the failed physical disk.
- D. Create a new celldisk and new griddisks on the replaced physical disk.
- E. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- F. Add the griddisks back into the ASM diskgroup they used to be a member of.
Answer: A,C
NEW QUESTION 51
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 52
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. High
- D. External
- E. Extended
Answer: C
Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf
NEW QUESTION 53
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?
- A. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.
- B. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
- C. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
- D. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.
Answer: D
NEW QUESTION 54
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. installing an alternative package manager
- D. upgrading the Storage Server software package using rpm
- E. changing the root password
Answer: C,E
NEW QUESTION 55
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?
- A. on all storage servers in both racks
- B. on at least two storage servers in both racks
- C. on all database servers in the first rack
- D. on all database servers and at least two storage servers in both racks
- E. on all database servers in both racks and one storage server in each rack
- F. on only one database server in both racks
- G. on all database servers in the second rack
Answer: A,C
NEW QUESTION 56
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. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
- C. ZFS Snapshots can provide rapid cloning of development and test environment.
- D. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
Answer: B,D
NEW QUESTION 57
......
View All 1z1-902 Actual Free Exam Questions Updated: https://surepass.actualtests4sure.com/1z1-902-practice-quiz.html
