1Z0-146 試験問題を無料オンラインアクセス

You have an external C procedure stored in a dynamic-link library (DLL).
The C procedure takes an integer as argument and returns an integer. You want to invoke the C
procedure through a PL/SQL program.
View the Exhibit.

Which statement is true about the C_OUTPUT PL/SQL program?

• A.It invokes the external C procedure.
• B.It fails because the input data type is BINARY_INTEGER and the external C procedure expects an integer.
• C.It fails because the external C procedure is not published.
• D.It only publishes the external C procedure.

To examine the dependencies between all PL/SQL objects and the tables and views they
reference, you executed the following query as the user OE:
SQL> SELECT owner || '.' || NAME refs_table
, referenced_owner || '.' || referenced_name AS table_referenced
FROM all_dependencies
WHERE owner = USER
AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION')
AND referenced_type IN ('TABLE', 'VIEW')
AND referenced_owner NOT IN ('SYS', 'SYSTEM')
ORDER BY owner, NAME, referenced_owner, referenced_name;
Which statement is true about the output of the query?

• A.It displays all PL/SQL code objects created by user OE that reference any table or view owned by other users except SYS and SYSTEM..
• B.It displays no rows because this query needs to be executed as the user SYS for required results.
• C.It displays only those PL/SQL code objects created by the user OE that reference a table or view created by the user SYS.
• D.It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.

Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE
PLSQL_OPTIMIZE_LEVEL = 3
Which statement would be true in this scenario?

• A.The compiler would automatically inline subprograms.
• B.The compiler would not inline the code unless the INLINE pragma is set to YES.
• C.The compiler would inline the code for external subroutines.
• D.The compiler would inline the code even if the INLINE pragma is set to NO.

When do you use static SQL as a technique for avoiding SQL injection?

• A.when the WHERE clause values are unknown
• B.when the code contains data definition language (DDL) statements
• C.when the SET clause values are unknown at the time of code compilation
• D.when all Oracle identifiers are known at the time of code compilation

The following command is executed to start tracing in a user session:
SQL> EXECUTE
DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS);
Which statement is true about the effect of the command?

• A.It allows tracing of system-defined exceptions raised by all subprograms executed in the session.
• B.It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed in the session.
• C.It allows tracing of user-defined exceptions raised by all subprograms executed in the session.
• D.It allows tracing of exceptions raised by all subprograms executed in the session.