Question 1
Multiple choice
Which three of the following options are available for database consolidation on Exadata?
-
A
Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
-
B
Bare Metal deployment with one database per database server
-
C
A single database with one or more schema per application
-
D
Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
-
E
Multiple Databases on a cluster
-
F
Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
Reveal answer details
Close answer details
Correct answersA, C, E
ExplanationExplanation: According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
A. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal
cluster 123.
C. A single database with one or more schema per application12.
E. Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
-
A
-
B
-
C
-
D
Reveal answer details
Close answer details
Correct answerB
ExplanationExplanation: Oracle Linux 7.9 is the minimum version required to support RoCE and Persistent Memory.
This is because Oracle Linux 7.9 includes kernel enhancements that enable RDMA over Converged Ethernet (RoCE) networking and Intel Optane DC Persistent Memory Modules (DCPMM) for Exadata X8M systems 3. These features allow faster access latency and higher throughput for database workloads 2.
Question 3
Multiple choice
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
Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
-
B
Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
-
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
The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
-
E
It is required to install OEDA on the first new database server.
Reveal answer details
Close answer details
Correct answersC, D
ExplanationExplanation:
https://docs.oracle.com/en/database/oracle/oracle-database/21/ladbi/db-on-exadata.html
Question 4
Multiple choice
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
CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
-
C
'crsct1 stop cluster -all' on one of the database servers
-
D
CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
-
E
CellCLI alter GRIDDISK all inactive on the affected storage server
-
F
shutdown -h now' on the affected storage server
Reveal answer details
Close answer details
Correct answersE, F
ExplanationExplanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB
The two commands that must be executed to safely power off the storage server in an Exadata X9M
Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage server is completely powered off and no data is lost. For more information on how to properly power off an Exadata Storage Server, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1188080_1.html
Question 5
Multiple choice
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
-
A
RoCE network interface cards in the storage servers
-
B
fans in the storage servers
-
C
Cisco RDMA over Converged Ethernet (RoCE) switches
-
D
RoCE network interface cards in the database servers
-
E
-
F
-
G
power supplies in the database servers
Reveal answer details
Close answer details
Correct answersA, C, E, G
ExplanationExplanation: According to the Oracle Auto Service Request (ASR) documentation1, ASR raises service requests for qualified Oracle products that are detected with specific faults. The qualified Exadata products include2: Database servers Storage servers InfiniBand switches Cisco switches (X8M and later systems)
Power distribution units (PDUs)
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
-
B
-
C
-
D
-
E
Reveal answer details
Close answer details
Question 7
Multiple choice
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
Replace the failed physical disk.
-
B
Add the griddisks back into the ASM diskgroup they used to be a member of.
-
C
Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
-
D
Rebalance the data on the effected griddisks before performing a manual drop command.
-
E
Create a new celldisk and new griddisks on the replaced physical disk.
-
F
Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
Reveal answer details
Close answer details
Correct answersA, C
ExplanationExplanation: Once the physical disk has been replaced, you will need to create a new celldisk and griddisks on the replaced physical disk. After the griddisks have been dropped from the associated ASM diskgroups, you can then add the griddisks back into the ASM diskgroup they used to be a member of and rebalance the data on the effected griddisks. Finally, you should verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
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 celldisk attributes name, deviceName, diskType, physicalFirmware
-
B
list cell attributes name, deviceName, diskType, physicalFirmware
-
C
list physicaldisk attributes name, deviceName, diskType, physicalFirmware
-
D
list devices attributes name, deviceName, diskType, physicalFirmware
Reveal answer details
Close answer details
Correct answerC
ExplanationExplanation: This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M
Implementation Essentials Official Text Book (page 85). https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html
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 must be invoked with the --rolling argument. Each component type must be upgraded independently of the other.
-
B
patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
-
C
patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
-
D
patchmgr must be invoked with the --rolling argument with all database and storage servers listed in a single input file.
Reveal answer details
Close answer details
Correct answerD
ExplanationAccording 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.
|