Free Oracle 1Z0-060 Exam Dumps Questions & Answers

Which statement is true regarding the default behavior of the order by clause?

• A.NULL values are not considered at all by the sort operation.
• B.Only those columns that are specified in the select list can be used in the order by clause.
• C.In a character sort, the values are case-sensitive.
• D.Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

The following parameter are set for your Oracle 12c database instance:

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.1, 2, 3, 4, 5
• B.1, 2, 4, 5
• C.2, 4, 5
• D.2, 1, 4, 3, 5

You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?

• A.It may advise the use of online table redefinition for tables in locally managed tablespaces
• B.It may advise the use of segment shrink for free list managed tables.
• C.It may advise the use of online table redefinition for tables in dictionary managed tablespace.
• D.It will detect and advise about chained rows.
• E.It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:

What is the result?

• A.The file `+data.231.45678' is renamed as `myfile.dbf', and copied to `+data/prod'.
• B.The file `+data.231.45678' is physically relocated to `+data/prod' and renamed as `myfile.dbf'.
• C.The file `+data.231.45678' remains in the same location andasynonym'myfile.dbf' is created.
• D.The file `myfile.dbf' is created in `+data/prod' and the reference to `+data.231.45678' in the data dictionary removed.

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

• A.It fails because no SQL *Loader control file location is specified.
• B.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• C.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• D.It fails because no SQL *Loader data file location is specified.