1z0-148 무료 덤프문제 온라인 액세스

Which three commands can be used to set PL/SQL conditional compilation inquiry directive MODE?

• A.ALTER SESSION SET PLSQL_CCFLAGS= 'mode: Level1';
• B.ALTER SESSION SET PLSQL_CCFLAGS= 'mode: NULL';
• C.ALTER SESSION SET PLSQL_CCFLAGS= 'mode: 1'
• D.ALTER SESSION SET PLSQL_CCFLAGS = 'mode: FALSE';
• E.ALTER SESSION SET PLSQL_CCFLAGS= 'mode: Level 1';

Which statement is true about internal and external LOBs?

• A.When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.
• B.A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.
• C.After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.
• D.Internal and external LOBs can be written using DBMS_LOB.
• E.An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.

Which two statements describe actions developers can take to make their application less vulnerable to security attacks?

• A.Switch from using DBMS_SQL to EXECUTE IMMEDIATE.
• B.Increase the amount of code that is accessible to users by default.
• C.Do not concatenate unchecked user input into dynamically constructed SQL statements.
• D.Include the AUTHID CURRENT_USER clause in stored program units.
• E.Include the AUTHID DEFINER clause in stored program units.

Which two statements about the PL/SQL hierarchical profiler are true?

• A.Profiler data is recorded in tables and published in HTML reports.
• B.Access it using the DBMS_HPROF package.
• C.It is only accessible after a grant of the CREATE PROFILE privilege.
• D.It helps you identify subprograms that are causing bottlenecks in application performance.
• E.Access it using the DBMS_PROFILER package.

Examine the section of code taken from a PL/SQL program:

PLSQL_OPTIMIZE_LEVEL PARAMETER is set to 3.
Which two statements are true?

• A.Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.
• B.Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.
• C.Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.
• D.Calls to TESTPROC might be inlined in the line commented as Call 2.
• E.Calls to TESTPROC are not inlined in the line commented as Call 1.