Oracle 1z0-148 問題集

質問 1：
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 throws a PL/SQL: numeric or value error: NULL index table key value exception.
C. It displays 3 for both the row count and the total.
D. It throws a NO_DATA_FOUND exception.
正解：C

質問 2：
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 NUMBER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/
B. CREATE FUNCTION totalEmp (sal IN POSITIVEN) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/
C. CREATE FUNCTION totalEmp (sal IN PLS_INTEGER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/
D. CREATE FUNCTION totalEmp (sal IN BINARY_FLOAT) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/
E. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/
正解：A,D

質問 3：
Which two statements will raise an exception? (Choose two.)
A. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@my_dblink') FROM dual;
B. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('"10_Employees"') FROM dual;
C. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME (' Emp_Dept_information_table ') FROM dual;
D. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@') FROM dual;
E. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employee_Department_information_table') FROM dual;
正解：B,D

質問 4：
Examine the EMP table:
CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10));
Examine this PL/SQL procedure:

Which is the correct replacement for the assignment to variable l_sql to avoid SQL injection?
A. l_sql := 'SELECT empno FROM emp WHERE ename = ' ||
SYS.DBMS_ASSERT.ENQUOTE_LITERAL (p_ename);
B. l_sql := 'SELECT empno FROM emp WHERE ename = ''' || SYS.DBMS_ASSERT.NOOP (p_ename) ||
'''';
C. l_sql := 'SELECT empno FROM emp WHERE ename = ''' ||
SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME (p_ename) || '''';
D. l_sql := 'SELECT empno FROM emp WHERE ename = ' ||
SYS.DBMS_ASSERT.SIMPLE_SQL_NAME (p_ename);
E. l_sql := 'SELECT empno FROM emp WHERE ename = ' ||
SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME (p_ename);
正解：A

質問 5：

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 2
C. Line 5
D. Line 3
E. Line 7
正解：B,E

質問 6：
Which three statements are true about varrays in a database table column? (Choose three.)
A. The data in a single element of a varray can be changed through either PL/SQL or SQL.
B. A varray may be stored outside the table segment in which it is defined but still in the same tablespace.
C. A varray used as a column in a database table must be initialized to empty.
D. The data in a single element of a varray can only be changed through PL/SQL.
E. A varray's size can be increased beyond the maximum number of elements specified in the definition.
F. A varray is always stored in the same segment as the table in which it is defined.
G. A varray's size can be both increased and decreased from the maximum number of elements specified in the definition.
H. A varray used as a column in a database table must be initialized to null.
正解：A,B,G