Your success in Oracle 1Z0-146 is our sole target and we develop all our 1Z0-146 braindumps in a way that facilitates the attainment of this target. Not only is our 1Z0-146 study material the best you can find, it is also the most detailed and the most updated. 1Z0-146 Practice Exams for Oracle Database 11g 1Z0-146 are written to the highest standards of technical accuracy.
Q9. You executed the following command:
SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'
You create a new package called PACK1. View Exhibit1 to examine the PL/SQL code for the
PACK1 package specification and body.
You issue the following query to see all unique identifiers with a name, such as %1:
SQL> SELECT NAME, SIGNATURE, TYPE
FROM USER_IDENTIFIERS
WHERE NAME LIKE '%1' AND USAGE='DECLARATION'
ORDER BY OBJECT_TYPE, USAGE_ID;
View Exhibit2 to examine the output of the query. Which two statements are true about the output of the query? (Choose two.)
A. The SIGNATURE column has a unique value for an identifier except for identifiers with the same name.
B. The TYPE column has the value of packages, function or procedures, object types, PL/SQL types, triggers, or exceptions.
C. The query shows the output for only those identifiers for PL/SQL objects, which are created by the user and are compiled after the ALTER SESSION command.
D. The ALTER SESSION command automatically collects identifier data and the query shows the output for all the identifiers for PL/SQL objects, which are created by the user.
Answer: B,C
Q10. You created an application context successfully. The user OE was granted the EXECUTE privilege on the DBMS_SESSION package. The user receives this error while setting the value for an attribute within the context: SQL> EXECUTE DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); BEGIN DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); END; * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", line 94
ORA-06512: at line 1
What is the reason for this error?
A. The context was created with a package name in the USING clause.
B. The attribute can be set only in the package associated with the context.
C. The package associated with the context did not exist at the time of creation of the context.
D. The value for an attribute of a user-defined context can be set only by the ALTER SESSION command.
Answer: B
Q11. Which two statements correctly describe the features of SecureFiles? (Choose two.)
A. Compression does not entail table or index compression and vice-versa.
B. Encryption stores the encryption keys for the LOB columns inside the database.
C. Encryption stores the encryption keys for the LOB columns outside the database.
D. Compression stores identical data occurring two or more times in the same LOB column as a single copy for the table.
Answer: A,C
Q12. Which two statements are true about cursor variables? (Choose two.)
A. Cursor variables can be parameterized like cursors.
B. The query associated with a cursor variable cannot reference host variables and PL/SQL variables.
C. The FETCH statement executes the query associated with a cursor variable and identifies the result set.
D. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.
E. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.
Answer: D,E
Q13. 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. WRITEAPPEND must be replaced with APPEND.
B. The BUF variable data type must be changed to CLOB. C. FOR UPDATE must be added to the SELECT statement.
D. The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND.
Answer: C
Q14. Identify two methods for immunizing PL/SQL code against SQL injection attacks. (Choose two.)
A. Use bind arguments.
B. Validate all input concatenated to dynamic SQL.
C. Use dynamic SQLs constructed using concatenation of input values.
D. Use subprograms as part of packages instead of stand-alone subprograms.
Answer: A,B
Q15. To examine the dependencies between all PL/SQL objects and the tables and views they reference, you executed the following query as the user OE:
SQL> SELECT owner || '.' || NAME refs_table
, referenced_owner || '.' || referenced_name AS table_referenced
FROM all_dependencies
WHERE owner = USER
AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION')
AND referenced_type IN ('TABLE', 'VIEW')
AND referenced_owner NOT IN ('SYS', 'SYSTEM')
ORDER BY owner, NAME, referenced_owner, referenced_name;
Which statement is true about the output of the query?
A. It displays all PL/SQL code objects created by user OE that reference any table or view owned by other users except SYS and SYSTEM..
B. It displays no rows because this query needs to be executed as the user SYS for required results.
C. It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.
D. It displays only those PL/SQL code objects created by the user OE that reference a table or view created by the user SYS.
Answer: A
Q16. In which two situations is the body of a result-cached function executed? (Choose two.)
A. if the memory allocated for the result cache is increased
B. if a session on this database instance invokes the function with the same parameter values
C. if the first time a session on this database instance invokes the function with a parameter value
D. if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function
Answer: C,D