PassLeader now are offering 100% pass ensure 1Z0-417 dumps! All 1Z0-417 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-417 VCE dumps and PDF dumps: https://www.passleader.com/1z0-417.html (88 Q&As)
BTW: Download PassLeader 1Z0-417 dumps from Google Drive for free: https://drive.google.com/open?id=1kMC-RfnLKjTKw1rBdvqaO-1OdVbkOpox
QUESTION 50
Which two statements are true about server-generated alerts?
A. They are always logged in the alert log.
B. They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.
C. They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.
D. They can be generated for user-defined metric thresholds.
E. They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.
Answer: DE
QUESTION 51
You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%. Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded?
A. The alert log
B. Oracle Enterprise Manager Cloud Control
C. DBA_ALERT_HISTORY
D. DBA_OUTSTANDING_ALERTS
E. DBA_ACTIVE_SESSION_HISTORY
F. DBA_THRESHOLDS
Answer: AF
QUESTION 52
Which are two strategies to maintain performance and improve a table segment’s compression ratio when you are using Advanced Row Compression on a table segment?
A. Use smaller database block size.
B. Use larger database block size.
C. Use direct-path inserts where possible.
D. Increase PCTFREE on the table segment.
E. Increase the size of the tablespace.
Answer: AE
QUESTION 53
Upon migration to Oracle Database 12c, a customer asked that monitoring at an individual database level be disabled in favor of database performance monitoring consolidated and centralized across their enterprise. Which are two actions you would take to meet the customer’s requirements?
A. Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.
B. For the always active Oracle Enterprise Manager Database Express process, create a script that will disable that process upon database boot.
C. Using the appropriate architecture implement Oracle Enterprise Manager.
D. Delete the “express” directory in Oracle Home to disable Oracle Enterprise Manager Database Express.
E. Changes permissions of the “express” directory to real only by root.
F. Enable SNMP and configure MIBS on each database and forward database monitoring SNMP traps.
Answer: BE
QUESTION 54
Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?
A. SQL Hints
B. Stored Outlines
C. Stored Profiles
D. SQL Plan Management
E. SQL Profiles
Answer: B
Explanation:
SQL statement, or migrate an existing stored outline by loading the “outlined” plan as a fixed plan.
https://docs.oracle.com/cd/E18283_01/server.112/e16638/optplanmgmt.htm
QUESTION 55
When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?
A. Result Cache
B. Mega Cache
C. Oracle In-Memory Database Cache
D. Database Smart Flash Cache
E. Oracle In-Memory DBSTATS Cache
Answer: ACD
QUESTION 56
Which option would you use to capture workloads from one or more systems concurrently and then play them back?
A. Automatic Workload Repository
B. Enterprise Manager Cloud Control
C. Consolidated Database Replay
D. Consolidation Planner
E. Workload Consolidator and Playback
Answer: C
PassLeader now are offering 100% pass ensure 1Z0-417 dumps! All 1Z0-417 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-417 VCE dumps and PDF dumps: https://www.passleader.com/1z0-417.html (88 Q&As)
BTW: Download PassLeader 1Z0-417 dumps from Google Drive for free: https://drive.google.com/open?id=1kMC-RfnLKjTKw1rBdvqaO-1OdVbkOpox