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

Examine the structure of the EMP table:
Name Null? Type
------------------ -------------- ---------------------
EMPNO NOT NULL NUMBER (4)
ENAME VARCHAR2 (10)
SAL NUMBER (7, 2)
Examine this code:

Which code should be inserted to display the collection contents?

• A.FOR indx IN 1_list. COUNT .. -1 LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx));END LOOP;
• B.FOR indx IN 1_list.FIRST . . 1_list.LAST LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx));END LOOP;
• C.FOR indx IN -1 .. 1_list.LIMIT LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx) );END LOOP;
• D.1_indx := 1_list.FIRST;WHILE (1_indx IS NOT NULL) LOOPDBMS_OUTPUT.PUT_LINE (1_indx ||
  ' ' || 1_list (1_indx));1_indx := 1_emp.NEXT (1_indx);END LOOP;

Which data dictionary view includes information about the parameters of procedures and functions that you can call?

• A.ALL_ARGUMENTS
• B.ALL_PROCEDURES
• C.ALL_OBJECTS
• D.ALL_PACKAGES

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.

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.
Examine this PL/SQL package AS

Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

• A.CREATE FUNCTION totalEmp (sal IN POSITIVEN) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• B.CREATE FUNCTION totalEmp (sal IN BINARY_FLOAT) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• C.CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• D.CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• E.CREATE FUNCTION totalEmp (sal IN PLS_INTEGER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/

Which two statements are correct for collecting data about identifiers in PL/SQL source code?

• A.ALTER <function/Procedure> COMPILE PLSCOPE_SETTINGS = 'IDENTIFIERS: ALL'
• B.ALTER SYSTEM SET PLSCOPE_SETTINGS = 'IDENTIFIERS: NONE'
• C.ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS: ALL'
• D.ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS: NONE'
• E.CREATE < function/Procedure> PLSCOPE_SETTINGS = 'IDENTIFIERS: ALL' AS ...