Online Access Free 1z0-061 Exam Questions

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

• A.Active Session History (ASH) report
• B.Compare Period ADDM report
• C.Taking a new snapshot and comparing it with a preserved snapshot
• D.AWR Compare Period report

The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3. Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4 . Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5 . Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps:

• A.2, 4, 5
• B.2, 1, 4, 3, 5
• C.1, 2, 3, 4, 5
• D.1, 2, 4, 5

Evaluate this SQL statement:
SELECT ename, sal, 12*sal+100 FROM emp;
The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?

• A.SELECT ename, sal+100, *12 FROM emp;
• B.SELECT ename, sal, (12*sal)+100 FROM emp;
• C.No change is required to achieve the desired results.
• D.SELECT ename, sal, 12*(sal+100) FROM emp;

What are two reasons to create synonyms? (Choose two.)

• A.Your tables names are too long.
• B.You want to use another schema's tables.
• C.You have too many columns in your tables.
• D.Your tables have difficult names.
• E.You have too many tables.
• F.You want to work on your own tables.

View the Exhibit and examine the structure of the SALES table.

The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times.

Which statement is true regarding this SQL statement?

• A.It executes successfully and generates the required result.
• B.It produces an error because count{*) should be only in the HAVING clause and not in the WHERE clause.
• C.It produces an error because count(*) should be specified in the SELECT clause also.
• D.It executes successfully but produces no result because COUNT (prod_id) should be used instead of COUNT (*).