Oracle Exadata Database Machine 2014 Implementation Essentials - 1z1-485 Exam Practice Test
How would you execute CellCLI commands and scripts?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-image with an Oracle Support installation image. Which three tasks would you need to perform to re-image the compute node?
Correct Answer: B,C,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which two statements appropriately describe the backup and recovery procedures on Exadata?
Correct Answer: A,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Consider the following setup:
User A1 belongs to resource group High on Database A.
User B2 belongs to resource group Low on Database B.
User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%.
Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5
Database B: Share=30, limit=10
Database C: 5 shares
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?
User A1 belongs to resource group High on Database A.
User B2 belongs to resource group Low on Database B.
User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%.
Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5
Database B: Share=30, limit=10
Database C: 5 shares
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?
Correct Answer: E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Storage indexes are unique to the 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 I MO storage regions.
2.cellsrv checks the high and low values, and determines the storage region does not contain any values meeting 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.MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the I/O request.
1.The Exadata cell services software conducts I/O requests on I MO storage regions.
2.cellsrv checks the high and low values, and determines the storage region does not contain any values meeting 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.MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the I/O request.
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which is the best location to point your customer to, for finding the latest Exadata patches?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
When running OS Watcher, which two data outputs are valid for Exadata storage cell performance analysis? Select the two correct choices that apply?
Correct Answer: A,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?
Correct Answer: A
Vote an answer