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.
♥♥ 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
Q71. Examine the following structure: SQL> DESCRIBE user_identifiers Name Null? Type
NAME VARCHAR2(30)
SIGNATURE VARCHAR2(32)
TYPE VARCHAR2(18)
OBJECT_NAME NOT NULL VARCHAR2(30)
OBJECT_TYPE VARCHAR2(13)
USAGE VARCHAR2(11)
USAGE_ID NUMBER
LINE NUMBER
COL NUMBER
USAGE_CONTEXT_ID NUMBER
Identify two scenarios in which information is stored in the USAGE column. (Choose two.)
A. an assignment made to VARIABLE
B. declaration of a variable or formal parameter
C. an identifier passed to a subprogram in IN OUT mode
D. execution of the GOTO statement or raise of an exception
Answer: A,B
Q72. There is a Java class file in your system and you publish it using the following command:
CREATE OR REPLACE PROCEDURE ccformat
(x IN OUT VARCHAR2)
AS LANGUAGE JAVA
NAME 'FormatCreditCardNo.formatCard(java.lang.String[])'
However, you receive the following error when executing the CCFORMAT procedure:
ERROR at line 1:
ORA-29540: class FormatCreditCardNo does not exist
ORA-06512: at "SH.CCFORMAT", line 1
ORA-06512: at line 1
What would you do to execute the procedure successfully?
A. Change the listener configuration.
B. Create a directory object and link it to the Java class file.
C. Rebuild the Java class file when the database instance is running.
D. Use the loadjava utility to load the Java class file into the database.
Answer: D
Q73. The user OE is working on an app lication that needs to call an exte rnal C program multiple times in a single session. However, the extproc.exe file on the server gets accidentally deleted after the OE user connected and made calls to the external C program. Wh ich statement is true about the current session by the OE user?
A. The session can continue calling the external C program.
B. The session can call the external C program after republishing it.
C. The session receives an error for the next call to the external C program.
D. The session terminates during the subsequent call to the external C program.
Answer: A
Q74. 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 executes successfully and displays the value 2.
B. It executes successfully and displays the value 0.
C. It generates an error because EXTEND cannot be used for varrays.
D. It generates an error because the declaration of the varray is not valid.
Answer: B
Q75. 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
Q76. 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 NUMBER data type if only positive integers are needed.
C. Use dynamic SQL and construct it through concatenation of input values.
D. In PL/SQL API, expose only those routines that are intended for customer use.
Answer: A,D
Q77. The result cache is enabled for the database instance.
Examine the following code for a PL/SQL function:
CREATE OR REPLACE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR
RESULT_CACHE RELIES_ON (HR.EMPLOYEES)
IS
date_hired DATE;
BEGIN
SELECT hire_date INTO date_hired
FROM HR.EMPLOYEES
WHERE EMPLOYEE_ID = emp_id;
RETURN TO_CHAR(date_hired);
END;
You notice that results for the functions are not used effectively. What do you recommend for better utilization of the result cache? (Choose all that apply.)
A. Set the RESULT_CACHE_MODE parameter to FORCE.
B. Increase the value for the RESULT_CACHE_MAX_SIZE parameter.
C. Add a format mask parameter, such as RETURN TO_CHAR(date_hired, fmt) to GET_HIRE_DATE.
D. Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.
Answer: C,D
Q78. Examine the code in the following PL/SQL block:
DECLARE
TYPE NumList IS TABLE OF INTEGER;
List1 NumList := NumList(11,22,33,44);
BEGIN
List1.DELETE(2);
DBMS_OUTPUT.PUT_LINE
( 'The last element# in List1 is ' || List1.LAST ||
' and total of elements is '||List1.COUNT);
List1.EXTEND(4,3);
END;
/
Which two statements are true about the above code? (Choose two.)
A. LAST and COUNT give different values.
B. LAST and COUNT give the same values.
C. The four new elements that are added contain the value 33.
D. The four new elements that are added contain the value 44.
Answer: A,C
Q79. View the Exhibit and examine the settings for the PLSQL_CODE_TYPE parameter.
After sometime, the user recompiles the procedure DISPLAY_SAL_INFO by issuing the following command:
SQL> ALTER PROCEDURE display_sal_info COMPILE;
Which statement would be true in this scenario?
A. The procedure would be invalidated.
B. The procedure would remain as NATIVE code type.
C. The procedure would be changed to INTERPRETED code type.
D. The command would produce an error and the procedure must be compiled using the PLSQL_CODE_TYPE attribute with value INTERPRETED.
Answer: C
Q80. 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
