Online Access Free 1Z0-146 Exam Questions

In a user session, tracing is enabled as follows:
SQL> EXECUTE
DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES);
PL/SQL procedure successfully completed.
You executed the procedure as follows:
SQL> EXECUTE PROC10
PL/SQL procedure successfully completed.
When you examine the PLSQL_TRACE_EVENTS table, you find that no trace information was
written into it.
View the Exhibit.

What is the reason for this?

• A.The TRACE_ENABLED parameter is set to FALSE for the session.
• B.The PROC10 procedure is not compiled with the DEBUG option.
• C.The PROC10 procedure is created with the invoker's right.
• D.Tracing is not enabled with the TRACE_ENABLED_CALLS option.

Examine the structure of the EMPLOYEES table that exists in your schema. Name Null? Type
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
DEPARTMENT_ID NUMBER(4)
You successfully create a GET_MAX procedure to find the maximum salary in the department of
a specified employee.
You then code a PL/SQL block to display the maximum salary in the departments of the first five
employees in the EMPLOYEES table.
View the Exhibit. Examine the procedure and the block of PL/SQL code.

What is the outcome of executing the block of PL/SQL code?

• A.It gives an error because usage of the %ROWCOUNT attribute is not valid.
• B.It gives an error because ROWNUM cannot be used in cursor definitions.
• C.It executes successfully, but does not give the required output because the procedure call resets the %ROWCOUNT value.
• D.It executes successfully and gives the required output.

Which two statements are true about the initialization of internal LOBs? (Choose two.)

• A.The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs.
• B.The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs.
• C.The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size.
• D.The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non-NULL internal LOBs.
• E.The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and EMPTY_BLOB() functions, respectively.

Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a temporary LOB? (Choose two.)

• A.It is used only for the migration of BasicFile to the SecureFile format.
• B.It creates a LOB variable that is associated with a specific table and is temporarily stored in the user's default tablespace.
• C.It creates a LOB variable that is not associated with any table and is stored in the user's temporary tablespace.
• D.It is used only for the migration of the LONG column to the LOB column.
• E.It can be used for transforming data in permanent internal LOBs.

View the Exhibit and examine the code in the PL/SQL block.

The PL/SQL block generates an error on execution. What is the reason?

• A.The DELETE(n) method cannot be used with nested tables.
• B.The NEXT method cannot be used with an associative array with VARCHAR2 key values.
• C.The NEXT method cannot be used with a nested table from which an element has been deleted.
• D.The DELETE(n) method cannot be used with varrays.