1Z0-146無料問題集「Oracle database 11g:advanced pl/sql」

質問 1

The following command is executed to start tracing in a user session:
SQL> EXECUTE
DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS);
Which statement is true about the effect of the command?

（A）It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed in the session.

（B）It allows tracing of system-defined exceptions raised by all subprograms executed in the session.

（C）It allows tracing of user-defined exceptions raised by all subprograms executed in the session.

（D）It allows tracing of exceptions raised by all subprograms executed in the session.

正解：A 解答を投票する

質問 2

Which two statements are true about associative arrays and nested tables? (Choose two.)

（A）Both associative arrays and nested tables can hold an arbitrary number of elements.

（B）Only associative arrays can use numbers and strings for subscripts.

（C）Both associative arrays and nested tables can use numbers and strings for subscripts.

（D）Only associative arrays can hold an arbitrary number of elements.

正解：A、B 解答を投票する

質問 3

Examine the following command to create the table EMPLOYEES_TEMP and the PL/SQL block.
CREATE TABLE employees_temp (empid NUMBER(6) NOT NULL,
deptid NUMBER(6) CONSTRAINT c_emp_deptid CHECK (deptid BETWEEN 100 AND 200),
salary Number(8),
deptname VARCHAR2(30) DEFAULT 'Sales')
/
DECLARE
SUBTYPE v_emprec_subtype IS employees_temp%ROWTYPE;
v_emprec v_emprec_subtype;
BEGIN
v_emprec.empid := NULL; v_emprec.salary := 10000.002;
v_emprec.deptid := 50;
DBMS_OUTPUT.PUT_LINE('v_emprec.deptname: ' || v_emprec.deptname);
END;
/
Which statements are true about the above PL/SQL block? (Choose two.)

（A）Assigning the value 50 to V_EMPREC.DEPTID would work because the check constraint is not inherited.

（B）V_EMPREC.DEPTNAME would display a null value because the default value is not inherited.

（C）Assigning null to V_EMPREC.EMPID would generate an error because the null constraint is inherited.

（D）Assigning the value 1000.002 to V_EMPREC.SALARY would generate an error because of the decimal.

正解：A、B 解答を投票する

質問 4

View the Exhibit and examine the structure of the EMPLOYEES table.

Examine the following PL/SQL block:
DECLARE
TYPE EmpList
IS VARRAY(2) OF employees.employee_id%TYPE NOT NULL;
v_employees EmpList := EmpList();
BEGIN
DBMS_OUTPUT.PUT_LINE(v_employees.COUNT);
v_employees.EXTEND;
v_employees(1) := 30;
END;
/
Which statement is true about the outcome on executing the above PL/SQL block?

（A）It generates an error because EXTEND cannot be used for varrays.

（B）It executes successfully and displays the value 2.

（C）It executes successfully and displays the value 0.

（D）It generates an error because the declaration of the varray is not valid.

正解：C 解答を投票する

質問 5

A procedure is created in the SYS schema to allow users to change the password as follows: CREATE OR REPLACE PROCEDURE change_password(p_username VARCHAR2 DEFAULT NULL, p_new_password VARCHAR2 DEFAULT NULL)
IS
v_sql_stmt VARCHAR2(500);
BEGIN
v_sql_stmt := 'ALTER USER '||p_username ||' IDENTIFIED BY '
|| p_new_password;
EXECUTE IMMEDIATE v_sql_stmt;
END change_password;
The SYS user has granted EXECUTE privilege on the procedure to the OE user. But OE is able
to change the password for SYS by using this procedure. How would you protect this?

（A）by using the procedure as part of a PL/SQL package

（B）by using AUTHID DEFINER in the procedure to implement the definer's right

（C）by using AUTHID CURRENT_USER in the procedure to implement the invoker's right

（D）by using a bind argument with dynamic SQL in the procedure

正解：C 解答を投票する

質問 6

Which three statements are true about hierarchical profiling? (Choose three.)

（A）It is useful for understanding the structure and control flow of complex programs.

（B）It provides function-level summaries.

（C）It can be used to identify hotspots and tuning opportunities in PL/SQL applications.

（D）It produces an aggregated report of the SQL and PL/SQL execution times.

（E）It generates trace information for PL/SQL programs in the PLSQL_TRACE_EVENTS table.

正解：A、B、C 解答を投票する

質問 7

Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)

（A）You can describe a stored procedure, stored function, packaged procedure, or packaged function.

（B）You can describe anonymous PL/SQL blocks.

（C）You can describe remote objects.

（D）You can obtain information about the position, name, and data type of the arguments of a procedure.

正解：A、D 解答を投票する

質問 8

Which two are major approaches that can be used to reduce the SQL injection by limiting user input? (Choose two.)

（A）Restrict users accessing specified web page.

（B）Use dynamic SQL and construct it through concatenation of input values.

（C）Use NUMBER data type if only positive integers are needed.

（D）In PL/SQL API, expose only those routines that are intended for customer use.

正解：A、D 解答を投票する

質問 9

Examine the commands:
CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20)
/ CREATE TYPE typ_course_nst AS TABLE OF typ_course_tab / CREATE TABLE faculty (faculty_id NUMBER(5), faculty_name VARCHAR2(30), courses typ_course_nst) NESTED TABLE courses STORE AS course_stor_tab / INSERT INTO faculty VALUES (101, 'Jones', NULL); UPDATE (SELECT courses FROM faculty WHERE faculty_id=101) SET courses = typ_course_nst(11,'Oracle'); Which statement is true about the execution of these commands?

（A）Only the first two commands execute successfully.

（B）Only the first three commands execute successfully.

（C）Only the first four commands execute successfully.

（D）All the commands execute successfully.

正解：C 解答を投票する

質問 10

Which statement describes the purpose of the plshprof command?

（A）It produces HTML output from profiler tables in the database.

（B）It produces raw profiler output on the most recently run applications.

（C）It produces HTML output from raw profiler output.

（D）It populates profiler tables in the database from raw profiler output.

正解：C 解答を投票する

1Z0-146 無料問題集「Oracle database 11g:advanced pl/sql」

弊社を連絡する

関連リンク

トップ試験