Question 1
Multiple choice
Which two statements are true about troubleshooting failed patching activities? (Choose two.)
-
A
Dependency issues found during yum updates should be ignored by using the force option.
-
B
Failed storage cell patches are rolled back to the previous release automatically.
-
C
Failed OS patches on database servers can be rolled back.
-
D
Dependency issues that are found during yum updates require rolling back to a previous release before retrying.
-
E
Bundle patches applied by using opatch auto cannot roll back only the database or the grid infrastructure home.
-
F
Database server OS updates can be rolled back by using opatch auto -rollback.
Reveal answer details
Close answer details
Correct answersA, F
ExplanationReferences: http://www.toadworld.com/platforms/oracle/w/wiki/11500.managing-troubleshooting-exadata-part-1-upgrading-patching-exadata
When performing the Oracle recommended bonding of NETl/NETZ or NET4/NET5, what other step should be completed in order to ensure connectivity, in case of a network hardware outage?
-
A
Each link should terminate at a separate switch to provide network redundancy.
-
B
NET0/NET3 should also be bonded and linked to a separate network.
-
C
The MTU should be set to 7000 to improve performance.
-
D
Jumbo Frames should be disabled.
-
E
STP should be disabled to prevent routing loops.
Reveal answer details
Close answer details
Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B. Which architecture would you suggest to solve this deployment issue?
-
A
Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B.
-
B
Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.
-
C
Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.
-
D
Define the split by setting up database services that are specific to department A and department B.
Reveal answer details
Close answer details
Consider the following software changes that are performed manually on a Linux server: 1. Changes for Linux kernel firewall configuration 2. Changes for custom performance monitoring tools 3. Changes for security scan tools 4. Changes for Linux system performance optimization Which of the software changes listed are permitted on Exadata Storage Servers?
-
A
-
B
-
C
-
D
-
E
-
F
Reveal answer details
Close answer details
Storage indexes are unique to Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order: 1. The Exadata cell services software conducts I/O requests on 1 MB storage regions. 2. cellsrv checks the high and low values, and determines that the storage region does not contain any values that meet the predicate. 3. The database is started. 4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage. 5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500. 6. A subsequent query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234. 7. The MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the l/O request.
-
A
-
B
-
C
-
D
-
E
Reveal answer details
Close answer details
Which statement is true about High Availability (HA) in an Exadata environment?
-
A
When a standby database is in place, DB_BLOCK_CHECKING is not required and thus is not recommended.
-
B
The checksums that are performed on the Exadata Storage Server ensure logical consistency of the block content.
-
C
Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.
-
D
Due to the different architecture that Exadata has with storage servers when compared to regular Storage Area Network, DB_LOST_WRITE_PROTECT need not be set.
-
E
The Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.
Reveal answer details
Close answer details
Which CellCLI command is used to conclude that a storage server can be taken offline without impacting database availability?
-
A
LIST GRIDDISK ATTRIBUTES name, status;
-
B
LIST CELLDISK ATTRIBUTES name, raidLevel, asmModeStatus;
-
C
LIST CELLDISK ATTRIBUTES name, raidLevel
-
D
LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;
-
E
LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;
Reveal answer details
Close answer details
Correct answerD
ExplanationExplanation: ASMDeactivationOutcome recall that grid disks can be deactivated, which is effectively taking them offline. Since ASM mirroring ensures that the data is located on another disk, making this disk offline does not lose data. However, if the mirror is offline, or is not present, then making this grid disk offline will result in loss of data. This attribute shows whether the grid disk can be deactivated without loss of data. A value of "Yes" indicates you can deactivate this grid disk without data loss. CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus DBFS_DG_CD_02_cell01 Yes ONLINE DBFS_DG_CD_03_cell01 Yes ONLINE DBFS_DG_CD_04_cell01 Yes ONLINE
Question 8
Multiple choice
In which three cases would RMAN backup and recovery be a good strategy for migrating to the cloud? (Choose three.)
-
A
when the source platform is little endian, character set is AL32UTF8, and the architecture is multitenant
-
B
when moving an Oracle Data Guard physical standby database to the cloud
-
C
when you are migrating a database from a different database version and it might have a different character set
-
D
when you are concerned about the endian nature of the database and want to perform conversions from different formats
-
E
when a physical migration approach is feasible and physical database reorganization is no necessary
Reveal answer details
Close answer details
The Exadata architecture is divided into two specific tiers: the database tier and the storage tier. What protocol do these tiers use to communicate with each other?
-
A
iDB - Intelligent Database Protocol
-
B
-
C
-
D
-
E
Reveal answer details
Close answer details
Correct answerA
ExplanationReferences: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/concepts.htm#SAGUG20333
Question 10
Multiple choice
Which three statements describe the memory capabilities of the X6-2 Exadata system?
-
A
The database server come with 256GB memory default.
-
B
The database server can contain 768GB memory.
-
C
The HC and EF storage servers contain 128GB memory.
-
D
The database server come with 512GB memory by default.
-
E
The HC and EF server come with 512GB memory default.
Reveal answer details
Close answer details
Question 11
Multiple choice
Which two statements are true about CellCLI? (Choose two.)
-
A
CellCLI can be used to back up the Exadata storage cells or make a bootable disk to restore the cell.
-
B
With a simple CellCLl command, you can synchronize changes to all the storage cells in the Exadata realm.
-
C
Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell.
-
D
Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers.
-
E
Using a CellCLI command, you can see whether grid disks are being used by ASM or not.
Reveal answer details
Close answer details
Question 12
Single choice
In a customer's ACFS filesystem, they would like you to set up replication between the existing local primary and the remote standby Exadata system. Which tool would you use to administer the replication process?
-
A
Replication is controlled by using Enterprise Manager Cloud Control.
-
B
Replication is controlled by using sqlplus while you are logged in as SYSASM.
-
C
Replication is controlled by using the acfsutil command-line tool.
-
D
Replication of ACFS filesystems for non-database files on Exadata is not supported.
-
E
Replication is controlled by using the exacli command-line tool.
Reveal answer details
Close answer details
Correct answerC
ExplanationReferences: http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/acfs/learnmore/acfs-replication-122-3634228.html
Question 13
Multiple choice
Which two statement are true about enabling the write-back flash cache?
-
A
When enabling the write-back-flash-cache in a rolling manner dbcli should be used to inactivate the grid disks on all cells first.
-
B
Before write-back-flash-cache is enabled you need to drop the flash cache first.
-
C
Write back flash cache requires a minimum required software version.
-
D
When enabling write-back-flash-cache in a non-rolling manners it is important to ensure that asmdeactivationoutcome is set to yes and asmmodestatus is set to online for all grid disks.
-
E
flashcachemode should be set to write back by updating cellinit.ora and restarting cellsrv.
Reveal answer details
Close answer details
|