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

Which two statements are correct about the collections before v3. DELETE is executed?

• A.The value of v3 (31) (1) and v3 (33) (3) are identical,
• B.The values of v3(31) (2) and v3 (33) (2) are identical.
• C.The values of v3 (32) (2) and v1 (2) are identical.
• D.The value of v3 (31) (1) is "hello".
• E.The value of v3 (31) (3) is 6.

Examine this PL/SQL block:

If PLSQL_CCFLAGS is set to:
'flag1:TRUE, flag2:2, flag3:NULL'
What is the result of submitting this PL/SQL block for execution with SERVEROUTPUT enabled?

• A.It executes successfully and outputs "Line: ".
• B.It executes successfully and outputs "Line: 5".
• C.It fails compilation.
• D.It executes successfully and outputs "Line: 8".
• E.It executes successfully and outputs "Line: 3".
• F.It executes successfully and outputs "Line: 10".

Examine this code executed as SYS:

Examine this code executed as SPIDER and the error message received upon execution:

What is the reason for this error?

• A.The user SPIDER needs to be granted the CREATE TABLE privilege and the procedure needs to be granted the DYNAMIC_TABLE_ROLE.
• B.The procedure needs to be granted the DYNAMIC_TABLE_ROLE role.
• C.The EXECUTE IMMEDIATE clause is not supported with roles.
• D.Privileges granted through roles are never in effect when running definer's rights procedures.

Your company's executive team voted to give a one-time special bonus, the amount of which is to be based on number of years of service. The bonus table will be updated using a procedure called update_bonus().
Examine this PL/SQL block which shows the logic to calculate the bonus:

Consider these possible optimization actions:
1.Remove the service_days calculation statement.
2.Move bonus1 and bonus2 initializations out of the loop.
3.Inline the update_bonus() subprogram.
4.Call update_bonus(), passing the literal bonus amount instead of the bonus1 or bonus2 variables.
Which set of optimizations will be performed if this block is compiled with PLSQL_OPTIMIZE_LEVEL = 2?

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

Examine this code:

Examine this query:
SELECT ename, d.dname, job, sal, comm FROM emp e, dept d WHERE d.deptno = e.deptno; Which statement is correct regarding the execution of this SQL query?

• A.The query will only fetch records pertaining to department 30 with SAL and COMM values displayed as NULL.
• B.The query will only fetch records pertaining to department 30 with SAL and COMM data replaced by
  "xxxxx".
• C.The query will fetch records from all departments with SAL and COMM values displayed as NULL for all records other than department 30.
• D.The query will only fetch records pertaining to department 30 with SAL and COMM displaying the actual data from the table.