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

質問 1

Which two statements are true about the working of fine-grained access? (Choose two.)

（A）Security policies can be associated only with tables, but not with views.

（B）Fine-grained access control policies always remain in effect until they are dropped from a table or view.

（C）Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.

（D）User statements are dynamically modified by the Oracle server through a security policy function.

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

質問 2

View the Exhibit and examine the code in the PL/SQL block.

The PL/SQL block generates an error on execution. What is the reason?

（A）The DELETE(n) method cannot be used with nested tables.

（B）The DELETE(n) method cannot be used with varrays.

（C）The NEXT method cannot be used with an associative array with VARCHAR2 key values.

（D）The NEXT method cannot be used with a nested table from which an element has been deleted.

正解：B 解答を投票する

質問 3

Examine the following error:
SQL> DECLARE
v_runid NUMBER;
BEGIN
v_runid := DBMS_HPROF.ANALYZE (LOCATION => 'PROFILE_DATA',
FILENAME => 'pd_cc_pkg.txt');
DBMS_OUTPUT.PUT_LINE('Run ID: ' || v_runid);
END;
DECLARE
*ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_HPROF", line 299
ORA-06512: at line 4
What would you do to execute the above block successfully?

（A）Grant READ and WRITE privileges to the current user on the PROFILE_DATA directory object.

（B）Run the dbmshptab.sql script located at ORACLE_HOME\RDBMS\ADMIN.

（C）Start the PL/SQL profiler before executing the block.

（D）Run the tracetab.sql script located at ORACLE_HOME\RDBMS\ADMIN.

正解：B 解答を投票する

質問 4

Examine the structure of the TEST_DETAILS table: Name Null? Type
TEST_ID NUMBER
DESCRIPTION CLOB
DESCRIPTION data was entered earlier and saved for TEST_ID 12.
You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION
column for TEST_ID 12:
DECLARE
clob_loc CLOB;
buf CHAR(12);
BEGIN
SELECT description INTO clob_loc FROM test_details WHERE test_id = 12 ;
buf := '0123456789';
DBMS_LOB.WRITEAPPEND(clob_loc,DBMS_LOB.GETLENGTH(buf), buf);
COMMIT;
END;
/
It generates an error on execution.
What correction should you do to achieve the required result?

（A）FOR UPDATE must be added to the SELECT statement.

（B）WRITEAPPEND must be replaced with APPEND.

（C）The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND.

（D）The BUF variable data type must be changed to CLOB.

正解：A 解答を投票する

質問 5

Which two types of query results cannot be stored in the query result cache? (Choose two.)

（A）results of a query having the DATE data type in the WHERE clause

（B）results of a query having the SYSDATE function

（C）results of a query having the GROUP BY clause

（D）subquery results

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

質問 6

View the Exhibit and examine the PL/SQL code.

Identify the sections of the code that need to be modified for better performance gains. (Choose all that apply.)

（A）Define and compile procedures independently, and not as part of a package.

（B）Avoid the NOT NULL constraint when declaring the variable.

（C）Use cursors to fetch values.

（D）Remove redundant SQL statements in the procedures.

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

質問 7

View the Exhibit and examine the output.

Which statement is an inference from the output?

（A）Java class methods in the Java class file have been published.

（B）The class file is pinned into the Java pool.

（C）The class file has been loaded into the shared library.

（D）The loadjava command has been executed to load the Java source and class files.

正解：D 解答を投票する

質問 8

You created the SALES_ORDERS_CTX context to use the
OE.SALES_ORDERS_PKG package.
View Exhibit1 and examine the package that is used with the context.
View Exhibit2 to examine the policy defined and the logon trigger.
A user receives the following error when he or she executes a query:
ERROR at line 2:
ORA-28112: failed to execute policy function
What could be the reason for the error?

（A）The policy is created by using SALES_ORDERS_PKG.THE_PREDICATE without a parameter.

（B）The subprograms inside the package have not been created with the invoker's right.

（C）The THE_PREDICATE function has an insufficient number of parameters in the package.

（D）The user has insufficient privileges on the DBMS_SESSION package.

正解：C 解答を投票する

質問 9

Which two statements are true about the extproc process? (Choose two.)

（A）It loads the dynamic library.

（B）It is started by the server process.

（C）A single extproc process serves all user sessions.

（D）It converts the C output back to PL/SQL.

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

質問 10

Which two types of query results cannot be stored in the query result cache? (Choose two.)

（A）results of a query having the DATE data type in the WHERE clause

（B）results of a query having the SYSDATE function

（C）results of a query having the GROUP BY clause

（D）subquery results

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

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

弊社を連絡する

関連リンク

トップ試験