Validated of 1Z0-146 actual exam materials and rapidshare for Oracle certification for consumer, Real Success Guaranteed with Updated 1Z0-146 pdf dumps vce Materials. 100% PASS Oracle 11g: Advanced PL/SQL exam Today!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-146 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-146 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-146-exam-dumps.html
Q11. You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?
A. The corresponding shared library is also removed from the system.
B. PL/SQL subprograms can be used to invoke the external C procedure.
C. The existing extproc process is terminated and a new extproc is started.
D. The PL/SQL subprogram that depends on the external C program becomes invalid.
Answer: D
Q12. 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 user has insufficient privileges on the DBMS_SESSION package.
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 policy is created by using SALES_ORDERS_PKG.THE_PREDICATE without a parameter.
Answer: C
Q13. 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
Q14. Which two statements are true about SecureFile LOB options? (Choose two.)
A. The COMPRESSION HIGH option can be enabled only for CLOBs.
B. The COMPRESSION HIGH option can be enabled for all internal LOBs.
C. The DECRYPT option can be used to remove encryption only if the LOB column is empty.
D. The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain data.
Answer: B,D
Q15. You created a procedure as follows:
CREATE OR REPLACE PROCEDURE query_prod(twhr VARCHAR2)
IS
stmt VARCHAR2(100);
pname VARCHAR2(20);
BEGIN
stmt:='SELECT product_name FROM products WHERE product_id=:2'
EXECUTE IMMEDIATE stmt INTO pname USING twhr;
DBMS_OUTPUT.PUT_LINE(pname);
END;
/
View the Exhibit to examine the structure of PRODUCTS table.
Which statement is true about the procedure?
A. It produces an error when invoked.
B. It can be invoked only from a PL/SQL block.
C. It reduces the chances of SQL injection by using bind arguments.
D. The values for bind arguments remain persistent in the session after the execution of the procedure.
Answer: C
Q16. Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a temporary LOB? (Choose two.)
A. It can be used for transforming data in permanent internal LOBs.
B. It is used only for the migration of BasicFile to the SecureFile format.
C. It is used only for the migration of the LONG column to the LOB column.
D. It creates a LOB variable that is not associated with any table and is stored in the user's temporary tablespace.
E. It creates a LOB variable that is associated with a specific table and is temporarily stored in the user's default tablespace.
Answer: A,D
Q17. View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure.
Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.)
A. Explicitly validate the identifier length limit.
B. Add AUTHID DEFINER to the definition of the procedure.
C. Use PRAGMA RESTRICT_REFERENCES in the procedure.
D. Filter out control characters in user-supplied identifier names.
E. Use the object ID of the table from the data dictionary to build the trigger name.
Answer: A,D,E
Q18. Match the following external C procedure components with their descriptions:
1. External procedure a. a process that starts the extproc process
2. Shared library b. a session-specific process that executes the external procedure
3. Alias library c. schema object that represents the operating system (OS) shared library
4. The extproc process d. operating system file that stores the external procedure
5. Listener process e. a unit of code written in C
A. 1-e; 2-d; 3-c; 4-b; 5-a
B. 1-c; 2-d; 3-e; 4-b; 5-a
C. 1-e; 2-c; 3-d; 4-b; 5-a
D. 1-a; 2-d; 3-e; 4-c; 5-b
Answer: A
Q19. Which two statements are true about associative arrays and varrays? (Choose two.)
A. Only varrays must start with the subscript 1.
B. Only varrays can be used as column types in database tables.
C. Both associative arrays and varrays must start with the subscript 1.
D. Both associative arrays and varrays can be used as column types in database tables.
Answer: A,B
Q20. Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)
A. Detect a wrong user.
B. Check input string length.
C. Verify qualified SQL names. D. Validate TNS connect strings.
E. Verify an existing schema name.
F. Enclose string literals within double quotation marks.
Answer: C,E,F
