Free Oracle 1Z0-050 Exam Dumps Questions & Answers

Which statement is true regarding the VALIDATE DATABASE command?

• A.It checks the database for both intrablock and interblock corruptions.
• B.It checks for only those corrupted blocks that are associated with data files.
• C.It checks the database for intrablock corruptions only
• D.It checks for block corruption in the valid backups of the database.

You want to perform the following operations for the DATA ASM disk group:
-Verify the consistency of the disk.
-Cross-check all the file extent maps and allocation tables for consistency. -Check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

• A.ALTER DISKGROUP data CHECK FILE;
• B.ALTER DISKGROUP data CHECK DISK;
• C.ALTER DISKGROUP data CHECK;
• D.ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

• A.It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
• B.It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
• C.It returns space usage of only SecureFile LOB chunks.
• D.It returns space usage of only BasicFile LOB chunks.

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

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?

• A.Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
• B.Capture the plans from the previous version using STS and then load them into the stored outline.
• C.Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
• D.Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.