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

The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2 and DEPARTMENT_ID of data type NUMBER.
There are six employees in DEPARTMENT_ID, 20. Examine this code:

What will be the outcome on execution?

• A.The number of employees will be displayed as six for both output messages.
• B.The execution of this code will fail with an invalid cursor error and not display either output message.
• C.The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.
• D.The number of employees will be displayed as six for the first output message and zero for the second output message.

Examine these statements regarding the DBMS_RESULT_CACHE package:
1.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by the PL/ SQL function result cache only.
2.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by both the PL/SQL function result cache and the SQL result cache.
3.DBMS_RESULT_CACHE package is owned by the SYS user.
4.RESULT_CACHE_MODE can be set using a subprogram defined in the DBMS_RESULT_CACHE package.
Which set of statements is correct?

• A.1 and 3
• B.2 and 4
• C.2, 3 and 4
• D.2 and 3
• E.1 and 4

Examine the structure and data in the CUSTOMERS table:


Examine this code:

What is the outcome on execution with SERVEROUTPUT enabled?

• A.It displays 3 for the row count and 2 for the total.
• B.It displays 3 for both the row count and the total.
• C.It throws a PL/SQL: numeric or value error: NULL index table key value exception.
• D.It throws a NO_DATA_FOUND exception.

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 7
• B.Line 3
• C.Line 2
• D.Line 5
• E.Line 6

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

• A.To execute chunks in parallel, users must have CREATE JOB system privilege.
• B.Users with CREATE TASK privilege can create or run parallel execution tasks.
• C.DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
• D.Only DBAs can create or run parallel execution tasks.
• E.No specific system privileges are required to create or run parallel execution tasks.