Oracle 1z0-902 Exam Practice Questions (P. 2)
- Full Access (60 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #6
Which two statements are true in regards to starting the Exadata Virtual Machine? (Choose two.)
- AUse vm_maker boot-from-iso command to boot a virtual machine.
- BUse vm_maker --auto-start command to configure a virtual machine to start automatically when the KVM host is started.
- CUse vm_maker --start-domain to start a virtual machine manually.
- DTo see Oracle Linux boot messages during guest startup, use --console option with the vm_maker --start-domain command.
- ETo streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
send
light_mode
delete
Question #7
Which are two correct statements about backing up Exadata Database Machine? (Choose two.)
- ABacking up Exadata Storage Server Software is critical for restoration.
- BBackup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
- CFor high availability, system area can be on the first two disks and M.2 devices.
- DUse a snapshot-based backup of an Oracle Exadata Database Machine database server software.
- EThe 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.
send
light_mode
delete
Question #8
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)? (Choose two.)
- AThere is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
- BOEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
- COEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
- DOEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
send
light_mode
delete
Question #9
In order to support a new application, you are planning to add a RAC VM cluster to an existing Oracle Exadata Machine X9M-2 deployment.
Which two methods can be considered? (Choose two.)
Which two methods can be considered? (Choose two.)
- AUse Oracle VM Manager.
- BUse the OEDA web-based configuration tool.
- CUse domu_maker utility.
- DUse the xm command.
- EUse the OEDA Command line interface.
send
light_mode
delete
Question #10
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? (Choose two.)
Which two actions are NOT appropriate for that purpose? (Choose two.)
- AYou query V$SYSSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- BYou 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.
- CYou query V$SEGMENT_STATISTICS and filter for the Object ID of your table from DBA_OBJECTS and the column STATISTIC_NAME='optimized physical reads'.
- DYou query V$SYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
send
light_mode
delete
All Pages