2023 Provide Updated Oracle 1z1-902 Dumps as Practice Test and PDF [Q13-Q38]

2023 Provide Updated Oracle 1z1-902 Dumps as Practice Test and PDF

1z1-902 Dumps are Available for Instant Access

Oracle 1Z0-902 exam covers a wide range of topics related to the implementation and management of the Exadata Database Machine X8M. These topics include hardware and software installation, database migration, storage configuration, network configuration, backup and recovery, performance tuning, and troubleshooting. 1z1-902 exam is designed to test the candidate's understanding of the machine's architecture and features, as well as their ability to apply best practices in managing the system. Passing 1z1-902 exam demonstrates a high level of expertise in implementing and managing the Exadata Database Machine X8M, and it is a valuable credential for professionals working in this field.

NEW QUESTION # 13
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, 8, 7, 3, and 6
B. 5, 8, 7, and 6
C. 4, 7, 8, 3, and 6
D. 2, 7, 8, and 6
E. 1, 8, 7, 3 and 6

Answer: D

NEW QUESTION # 14
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 12x 64GB DIMMs.
B. Memory cannot be expanded on Exadata X9M-2 Database Servers.
C. Add 32x 64GB DIMMs.
D. Add 16x 32GB DIMMs.
E. Add 24x 32GB DIMMs.
F. Add 12x 32GB DIMMs.
G. Remove existing memory modules.
H. Add 16x 64GB DIMMs.
I. Shutdown the Database Server if running.

Answer: C,G,I

Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
https://chriscraftoracle.wordpress.com/2022/11/09/what-makes-exadata-faster/

NEW QUESTION # 15
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 12x 64GB DIMMs.
B. Add 16x 64GB DIMMs.
C. Memory cannot be expanded on Exadata X9M-2 Database Servers.
D. Add 32x 64GB DIMMs.
E. Add 24x 32GB DIMMs.
F. Shutdown the Database Server if running.
G. Add 12x 32GB DIMMs.
H. Remove existing memory modules.
I. Add 16x 32GB DIMMs.

Answer: B,H,I

NEW QUESTION # 16
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

A. 512GB
B. 768GB
C. 1536GB
D. 1024GB
E. 2048GB
F. 384GB

Answer: D

Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the maximum DRAM capacity you can expand an X9M-2 DB Server is 1024GB. This is the maximum amount of DRAM that can be installed in the server. The specific steps for adding DRAM are outlined in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_hardware_memory.html.

NEW QUESTION # 17
Which three of the following options are available for database consolidation on Exadata?

A. Bare Metal deployment with one database per database server
B. A single database with one or more schema per application
C. Multiple Databases on a cluster
D. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
E. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
F. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

Answer: C,D,F

Explanation:
A Exadata supports multiple pluggable databases in one or more container databases, which enables database consolidation by allowing multiple databases to be consolidated into a single container database. This can be deployed on a Virtual Machine or Bare Metal cluster.
D Multiple databases spanning a Bare Metal and Virtual Machine cluster provide resource isolation and consolidation concurrently. It allows multiple databases to be deployed on both Bare Metal and Virtual Machine clusters, providing isolation and consolidation at the same time.
E Multiple Databases on a cluster allows multiple databases to be deployed on a single cluster, which enables consolidation of databases by reducing the number of clusters required.

NEW QUESTION # 18
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 # 19
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

A. Configuring ASR is mandatory for all Database Machine assets.
B. ASR communicates with Oracle support services using HTTPS.
C. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
D. ASR Manager must be installed and configured on one of the database servers.
E. ASR can upload configuration metadata to support problem resolution.
F. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.

Answer: E,F

Explanation:
1. ASR can upload configuration metadata to support problem resolution1.
2. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm

NEW QUESTION # 20
Which two activities are supported on the storage servers in an Exadata Database Machine?

A. changing the root password
B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
C. configuring secure shell user equivalency for the cellmonitor user
D. installing an alternative package manager
E. upgrading the Storage Server software package using rpm

Answer: A,C

Explanation:
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
1. changing the root password
2. configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html

NEW QUESTION # 21
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

A. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
B. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
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: A,D

Explanation:
Oracle Exadata Deployment Assistant (OEDA) enables customers to deploy Oracle Exadata Database Machine in virtualized environments and it support both bare metal and virtual machine deployment in an Exadata X9M Quarter Rack.

NEW QUESTION # 22
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 the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
B. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
C. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
D. Copy and execute the script on all storage servers using the EXACLI command.
E. Copy and execute the script on all storage servers using the dcli command.

Answer: E

Explanation:
According to Oracle's documentation1, the Cell Control Command-Line Interface (CellCLI) utility is the command-line administration tool for Oracle Exadata System Software. It can be used to perform various tasks on Exadata Storage Servers, such as creating and managing objects, monitoring performance, and configuring alerts.
To run CELLCLI commands on multiple cells simultaneously, you can use the Distributed Command-Line Interface (dcli) utility2. The dcli utility allows you to execute commands or scripts on a group of cells or hosts in parallel. You can use the dcli utility to copy files from one cell or host to multiple cells or hosts using the -f option3. You can also use the dcli utility to execute commands or scripts on multiple cells or hosts using the -l option to specify a user name and the -g option to specify a file containing a list of cells or hosts3.
Therefore, to achieve your requirement of running a script with several CELLCLI commands on each cell in your Exadata full rack simultaneously, you must:
Copy and execute the script on all storage servers using the dcli command.

NEW QUESTION # 23
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 12x 64GB DIMMs.
B. Add 16x 64GB DIMMs.
C. Memory cannot be expanded on Exadata X9M-2 Database Servers.
D. Add 32x 64GB DIMMs.
E. Add 16x 32GB DIMMs.
F. Add 24x 32GB DIMMs.
G. Add 12x 32GB DIMMs.
H. Remove existing memory modules.
I. Shutdown the Database Server if running.

Answer: B,H,I

Explanation:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".

NEW QUESTION # 24
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

A. Oracle Linux 7.9
B. Oracle Linux 7.5
C. Oracle Linux 7.7
D. Oracle Linux 8.0

Answer: A

Explanation:
RoCE (RDMA over Converged Ethernet) and Persistent Memory are features that are supported by Oracle Linux. The minimum version of Oracle Linux required to support RoCE and Persistent Memory is Oracle Linux 7.9.
RoCE is a low-latency, high-bandwidth networking technology that enables fast data transfer between servers using converged Ethernet networks. It is supported by Oracle Linux 7.9 and later versions, which includes the necessary kernel modules and user-space libraries to enable RoCE.
Persistent Memory is a technology that allows data to be stored in non-volatile memory (NVM) devices, such as NVDIMMs (Non-Volatile Dual In-line Memory Modules), which can be accessed at near-DRAM speeds. Oracle Linux 7.9 and later versions include support for Persistent Memory, which includes kernel modules and user-space libraries to enable Persistent Memory.

NEW QUESTION # 25
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 database servers and at least two storage servers in both racks
B. on all database servers in both racks and one storage server in each rack
C. on all database servers in the second rack
D. on at least two storage servers in both racks
E. on only one database server in both racks
F. on all storage servers in both racks
G. on all database servers in the first rack

Answer: A,B

NEW QUESTION # 26
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 Enterprise Manager host pages for the storage servers
B. OS I/O metrics using OS tools such as iostat on the storage servers
C. OS I/O metrics using OS tools such as iostat on the database servers
D. 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
E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

Answer: C,E

Explanation:
The two monitoring tools that might be useful in examining I/O performance for the prod database are:
OS I/O metrics using OS tools such as iostat on the database servers.
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "I/O metrics can be collected from the database server using OS tools such as iostat [1], as well as from the storage servers using cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk". It also suggests using Enterprise Manager host pages for the storage servers to view OS I/O metrics.

NEW QUESTION # 27
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

A. moving all disks from one cell to another as part of a chassis-level component failure
B. corruption in a normal or high redundancy ASM diskgroup
C. the failure of physical disk 0 and 11
D. the failure of physical disk 1
E. accidental loss of all data from all griddisks in a storage server
F. the failure of both physical M.2 disks
G. corruption in the / (root) filesystem

Answer: F,G

Explanation:
The two valid reasons are:
corruption in the / (root) filesystem . According to 1, this is one of the scenarios that requires a storage server rescue procedure , because it prevents the storage server from booting up normally . The rescue procedure will re-image the root filesystem with a fresh copy of the operating system and restore the configuration files from a backup1.
the failure of both physical M.2 disks . According to 2, each Exadata Storage Server X9M-2 has two physical M.2 disks that store the operating system and configuration files for the storage server . If both M.2 disks fail , then the storage server cannot boot up or function properly . The rescue procedure will replace the failed M.2 disks with new ones and re-image them with the operating system and configuration files2.

NEW QUESTION # 28
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
B. Install in Oracle Virtual Machine with required hardware.
C. Install on Exadata Engineered System.
D. Install on Oracle Database Appliance.
E. Provide individual x86 64-Bit gateway hardware.

Answer: A,D,E

Explanation:
According to Oracle's documentation1, the customer options for hosting the Platinum Services Advanced Support Gateway are:
Provide individual x86 64-Bit gateway hardware1
Purchase the recommended x86 64-Bit gateway hardware from Oracle1
Install on Oracle Database Appliance2

NEW QUESTION # 29
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?

A. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
B. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
C. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
D. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

Answer: B

Explanation:
According to Oracle documentation12, patchmgr is the utility used to update software for Exadata infrastructure components. It can apply patches in a rolling or non-rolling manner depending on the argument and input file provided.

NEW QUESTION # 30
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. 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.
B. It is required to install OEDA on the first new database server.
C. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
D. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
E. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.

Answer: C,E

NEW QUESTION # 31
Which two statements are true about applying updates on Exadata systems?

A. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
B. Failed database server updates are rolled back to a working state on a previous release automatically.
C. Failed storage server updates are automatically rolled back to a previous release.
D. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
E. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
F. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.

Answer: B,C

Explanation:
When applying updates on Exadata systems, database server updates are automatically rolled back to a working state on a previous release if the update fails. This ensures that the system can be restored to a working state in the event of a failed update. Additionally, storage server updates are also automatically rolled back to a previous release in the event of a failed update.
This is documented in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and more information can be found on the Oracle support website [1][2].

NEW QUESTION # 32
How do ASM failure groups provide redundancy?

A. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
B. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
C. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
D. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

Answer: A

NEW QUESTION # 33
Which two statements are true in regards to starting the Exadata Virtual Machine?

A. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
B. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
C. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
D. Use vm_maker boot-from-iso command to boot a virtual machine.
E. Use vm_maker -start-domain to start a virtual machine manually.

Answer: A,E

NEW QUESTION # 34
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?

A. -> start /SYSTEM/power
B. -> start /System
C. -> set /SYS power_state=ON
D. -> start /SYS/power
E. -> start /SP/console
F. You must be physically present in the data center to start an Exadata Storage Server.

Answer: D

Explanation:
ILOM (Integrated Lights Out Manager) is a remote management system that allows you to control and monitor Exadata Database Machine components, such as storage servers and database servers, from a remote location. The command "start /SYS/power" is used to power on the storage server in the Exadata Database Machine after hardware maintenance. This command can be executed remotely via ILOM.

NEW QUESTION # 35
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, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
C. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
D. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
E. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.

Answer: A

NEW QUESTION # 36
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?

A. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
B. to the CELLMONITOR account using cellcli interactively on each storage server
C. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
D. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
E. to the CELLADMIN account using cellcli interactively on each storage server
F. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli

Answer: A,C,E

Explanation:
To drop all celldisks on all the storage servers in an X9M-2 quarter rack, you should use the CELLADMIN account, which has the necessary privileges to perform this task. You can use the CELLCLI command-line interface to drop the celldisks. The best way to do this is by calling CELLCLI on all cells using DCLI (Oracle Database Command Line Interface) which allows you to run commands on multiple servers at once. Alternatively, you can use an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli. It is not recommended to use the CELLMONITOR account, as it has a more limited set of privileges. It is also important to note that EXACLI is not a valid tool for this task
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html

NEW QUESTION # 37
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. 4,3,2,6,1,7,5
B. 2,6,1,4,3,7,5
C. 3,2,6,1,4,7,5
D. 2,3,4,6,1,7,5
E. 3,2,6,4,1,7,5

Answer: D

Explanation:
This ordering is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. First, the Exadata should be stabilized and unpacked (Steps 2 and 3). Then, the safety guidelines should be reviewed (Step 4). The Exadata should then be allowed to acclimatize for 24 hours (Step 4). After that, the Exadata PDU A should be powered on (Step 6) and the Exadata should be placed in its allocated space (Step 6). Finally, the Exadata PDU B should be powered on (Step 7).

NEW QUESTION # 38
......

Updated 1z1-902 Dumps Questions For Oracle Exam: https://www.testvalid.com/1z1-902-exam-collection.html

Valid 1z1-902 Dumps for Helping Passing 1z1-902 Exam!: https://drive.google.com/open?id=1QvnvAhdMZDDXGCFlYoq4K-mgaYSTVRkW