READ Free Dumps For Oracle- 1z0-067
| Question ID 22074 | The following parameters 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_EVOVLE_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.
|
| Option A | 2, 4, 5
|
| Option B | 2, 1, 4, 3, 5
|
| Option C | 1, 2, 3, 4, 5
|
| Option D | 1, 2, 4, 5
|
| Correct Answer | B |
Explanation
| Question ID 22075 | You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
|
| Option A | USERS
|
| Option B | SYSTEM
|
| Option C | SYSAUX
|
| Option D | EXAMPLE
|
| Correct Answer | A |
Explanation Explanation: This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.