1Z0-050 무료 덤프문제 온라인 액세스

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?

• A.All historical data older than three years is purged from the flashback archive FLA1.
• B.The command produces an error because the retention time cannot be reduced.
• C.All historical data is retained but the subsequent flashback data archives are maintained for only three years.
• D.All historical data is purged and the new flashback data archives are maintained for three years.

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,lTASK1l);
END;
/
BEGIN
dbms_advisor.set_task_parameter(lTASK1l,lANALYSIS_SCOPElllALLl);
dbms_advisor.set_task_parameter(lTASK1,,,MODE,llCOMPREHENSIVEl);
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK11));
END;
/
The blocks of code execute successfully; however, you do not get the required outcome.
What could be the reason?

• A.The partial or complete workload scope needs to be associated with the task.
• B.A workload needs to be associated with the task.
• C.The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
• D.A template needs to be associated with the task.

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

• A.Auditing is disabled for all privileges.
• B.The audit trail is stored in an operating system file.
• C.Auditing is enabled for certain privileges related to database security.
• D.The audit trail is stored in the database
• E.Auditing is enabled for all privileges.

You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?

• A.The collection level for the AWR should be set to BASIC.
• B.The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.
• C.The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.
• D.The moving window size must be less than Undo Retention.

You executed the following PL/SQL block successfully:
VARIABLE tname VARCHAR2(20)
BEGIN
dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage1,
FINDING_NAME=>'CPU Usage1,
MIN_ACTIVE_SESSIONS=>0,MIN_PERC_IMPACT=>90);
:tname := 'database ADDM task4';
dbms_addm.analyze_db(:tname, 150,162);
END;
/
Then you executed the following command:
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM)
analysis____.

• A.with the CPU Usage finding for snapshots below 90
• B.with the CPU Usage finding if it is less than 90
• C.with the CPU Usage finding for snapshots not between 150 and 162
• D.without the CPU Usage finding if it is less than 90