Oracle 1z0-070 Exam Practice Questions (P. 3)
- Full Access (90 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 #11
You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine.
A part of the requirement is to provide for high availability of the monitoring infrastructure.
If the host running the agent that has Database Machine targets bound to it fails, the monitoring of these targets must be done by another agent.
Which three statements are true regarding the configuration used to support this requirement?
A part of the requirement is to provide for high availability of the monitoring infrastructure.
If the host running the agent that has Database Machine targets bound to it fails, the monitoring of these targets must be done by another agent.
Which three statements are true regarding the configuration used to support this requirement?
- ADatabase Machine plug-ins must be deployed to at least two Enterprise Manager agents.
- BFail back to the original agent when the host is restarted is done automatically.
- CFail over to any secondary agent is done automatically.
- DFail over to any secondary agent must be done manually.
- EDatabase machine plug-ins must be deployed to all Enterprise Manager agents.
- FFail back to the original agent when the host is restarted must be done manually.
Correct Answer:
BCE
BCE
send
light_mode
delete
Question #12
An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.
Identify the two steps that you must perform to replace this failed physical disk.
Identify the two steps that you must perform to replace this failed physical disk.
- AAdd the griddisks back into the ASM diskground they used to be a member of.
- BCreate a new celldisk and new griddisks on the replaced physical disk.
- CVerify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- DIdentify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- EReplace the failed physical disk.
Correct Answer:
CE
You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.
Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.
References:
http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#DBMMN21047
CE
You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.
Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.
References:
http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#DBMMN21047
send
light_mode
delete
Question #13
Which two completely prevent a Smart Scan from occurring?
- Aquerying a table containing many chained rows
- Bquerying a table containing many migrated rows
- Cperforming a minimum or maximum function on an indexed column
- Dperforming a Fast Full Index scan on a reverse key index
- Ereferencing more than 255 columns form an OLTP compressed table in a query
- Fquerying a table containing a JSON column
Correct Answer:
BE
B: Migrated Rows is a special case of chained rows. Migrated rows still affect performance, as they do in conventional storage situations, but with the additional overhead of reducing the beneficial effects of "Smart Scan" in addition to increasing the number of I/Os
E: Smart Scans - broadly speaking and ignoring edge cases - can only transport a maximum of 254 columns from a single (non-HCC) segment. Requesting more columns will simply disable Smart Scans for that segment.
An interesting limitation to Exadata Smart Scans - if more than 254 columns from a table (not HCC compressed, more on that in moment) need to be projected,
Smart Scans for that particular segment will be disabled and Exadata will fall back to conventional I/O. This means that the number of columns in the projection clause can make a significant difference to performance, since only Smart Scans allow taking advantage of offloading and particularly avoiding I/O via Storage
Indexes.
Incorrect Answers:
A: Smart scan can cope with some cases of chained rows
References:
http://oracle-randolf.blogspot.se/2013/01/exadata-smart-scan-projection-limitation.html
BE
B: Migrated Rows is a special case of chained rows. Migrated rows still affect performance, as they do in conventional storage situations, but with the additional overhead of reducing the beneficial effects of "Smart Scan" in addition to increasing the number of I/Os
E: Smart Scans - broadly speaking and ignoring edge cases - can only transport a maximum of 254 columns from a single (non-HCC) segment. Requesting more columns will simply disable Smart Scans for that segment.
An interesting limitation to Exadata Smart Scans - if more than 254 columns from a table (not HCC compressed, more on that in moment) need to be projected,
Smart Scans for that particular segment will be disabled and Exadata will fall back to conventional I/O. This means that the number of columns in the projection clause can make a significant difference to performance, since only Smart Scans allow taking advantage of offloading and particularly avoiding I/O via Storage
Indexes.
Incorrect Answers:
A: Smart scan can cope with some cases of chained rows
References:
http://oracle-randolf.blogspot.se/2013/01/exadata-smart-scan-projection-limitation.html
send
light_mode
delete
Question #14
Which statement is true about operating systems in an X5 Database Machine multirack configuration consisting of two full racks and one Exadata storage expansion rack?
- AAll Exadata storage servers used by the same virtual cluster nodes must run the same O/S but Exadata Storage Servers in different clusters may run different operating systems.
- BAll Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
- CAll Exadata storage servers may run Oracle Virtual Machine (OVM).
- DAll Exadata storage servers must run Oracle Linux.
- EAll Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same version of Oracle Virtual
Correct Answer:
D
On both physical and virtual deployments, Exadata systems use minimal Linux distributions to ensure that just the RPMs needed to run Oracle database, are installed and enabled.
References:
http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds-2406241.pdf
D
On both physical and virtual deployments, Exadata systems use minimal Linux distributions to ensure that just the RPMs needed to run Oracle database, are installed and enabled.
References:
http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds-2406241.pdf
send
light_mode
delete
Question #15
Which two are true about Smart Scan?
- AA query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.
- BColumn projection does not contribute to the performance benefit of Smart Scan.
- CA query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.
- DIt is possible to offload single row functions to the Exadata Storage Servers.
- EJoin processing can be partly offloaded to Exadata Storage Servers.
- FJoin processing can be fully offloaded to Exadata Storage Servers.
Correct Answer:
DE
D: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.
References:
http://www.centroid.com/blog/exadata-smart-scan-processing
DE
D: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.
References:
http://www.centroid.com/blog/exadata-smart-scan-processing
send
light_mode
delete
All Pages