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

You are logged on to the SCOTT schema and the schema has EMP and DEPT tables already created:
Examine this PL/SQL procedure:

Which PL/SQL block will raise an exception?

• A.EXEC get_tab_row_count ('DEPT, EMP')
• B.EXEC get_tab_row_count ('SCOTT.EMP');
• C.EXEC get_tab_row_count (' "EMP" ');
• D.EXEC get_tab_row_count ('DEPT');
• E.EXEC get_tab_row_count ('emp');

Refer to the Exhibit.

Examine this procedure created in a session where PLSQL_OPTIMIZE_LEVEL =2:

PL/SQL tracing in enabled in a user session using this command:
EXEC DBMS_TRACE.SET_PLSQL_TRACE (DBMS_TRACE.TRACE_ENABLED_LINES)
The procedure is executed using this command:
EXEC PRC_1
Examine the exhibit for the content of the PLSQL_TRACE_EVENTS table.
Why is tracing excluded from the PLSQL_TRACE_EVENTS table?

• A.PRC_1 is not compiled with debugging information.
• B.DBMS_TRACE.TRACE_ENABLED_LINES traces only exceptions in subprograms.
• C.Tracing will be enabled only for the second execution of PRC_1.
• D.PRC_1 is compiled with the default AUTHID DEFINER clause.
• E.Tracing is not enabled with the TRACE_ENABLED_CALLS option.

Examine this code:

You want to display the contents of CREATE_LIST.
Which two lines need to be corrected in the PL/SQL block?

• A.Line 6
• B.Line 3
• C.Line 5
• D.Line 2
• E.Line 7

Identify the three options which make a PL/SQL function highly suitable for using the RESULT_CACHE clause in its definition. (Choose three.)

• A.The code in the function performs more write operations on the database when compared to the read operations.
• B.The function has complex business logic depending on more than five tables to compute its return values.
• C.The logic in the function accesses tables or uses package variables which are modified very rarely.
• D.The function involves highly computational logic with minimal or no database access.
• E.The value returned by the function is deterministic for a given set of input parameters.
• F.The tables which are read in the function are very frequently updated.

Examine this code:

Examine this DML statement executed in the SCOTT schema:
UPDATE emp SET comm = 1000 WHERE deptno= 20;
What is the outcome after executing this statement?

• A.COMM is set to 1000 for all records in the EMP table where DEPTNO = 30.
• B.The statement executes successfully but no rows are updated.
• C.COMM is set to 1000 for all records in the EMP table where DEPTNO=20.
• D.The statement fails with error ORA-28115: policy with check option violation.