1Z0_146 questions • Exam prepare

Exam contains 114 questions

Page 16 of 19

Question 91 🔥

View the Exhibit to examine a Java source file. You have the corresponding Java class file and you execute the command as follows: SQL> CREATE ORREPLACE PROCEDURE ccformat (x IN OUT VARCHAR2) AS LANGUAGE JAVA NAME 'FormatCreditCardNo.formatCard()'; Which statement is true about the command?

Which database solution meets these requirements?

A. It loads the Java class method into Oracle Database and publishes it.

B. It publishes the Java class method, but the CCFORMAT PL/SQL procedure fails when it is executed.

C. It creates the CCFORMAT PL/SQL subprogram without publishing, which can be used to invoke the Java class method.

D. It publishes the Java class method and the CCFORMAT PL/SQL procedure invokes the Java class method when it is executed.

Discussion of the question

Question 92 🔥

View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table in an associative array:1 DECLARE 2 emp_cv SYS_REFCURSOR; 3 TYPE list IS TABLE OF emp_cv; 4 sals list; 5 BEGIN 6 OPEN emp_cv FOR SELECT salary FROM employees 7WHERE job_id = 'SA_REP'; 8 FETCH emp_cv BULK COLLECT INTO sals; 9 CLOSE emp_cv; 10 END;What should you correct in the above code to ensure that it executes successfully?

Which database solution meets these requirements?

A. Replace EMP_CV in line 3 with employees.salary%TYPE.

B. Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.

C. Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.

D. Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.

Discussion of the question

Question 93 🔥

Which statements are true about temporary LOBs? (Choose all that apply.)

Which database solution meets these requirements?

A. They can be created only for CLOB and NCLOB data.

B. They can be accessed only by the user who creates them.

C. They generate more redo information than persistent LOBs.

D. They exist for the duration of the session in which they are created.

E. They are stored temporarily in the default tablespace of the user who creates them.

Discussion of the question

Question 94 🔥

View Exhibit1 and examine the structure of the EMPLOYEES table. View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the employees in department ID 60. Which statement is true about the outcome?

Which database solution meets these requirements?

A. It generates an error because RECORD type cannot be used with varrays.

B. It generates an error because BULK COLLECT cannot be used with varrays.

C. It executes successfully only if department ID 60 has five or less than five employees.

D. It executes successfully even if department ID 60 has more than five employees by dynamically extending the varray.

Discussion of the question

Question 95 🔥

Which two guidelines should be considered when designing and using cursors in a PL/SQL block? (Choose two.)

Which database solution meets these requirements?

A. When fetching from a cursor, fetch into a record.

B. When fetching from a cursor, fetch required values into individually declared variables.

C. Whenever possible, explicitly declare the cursor and use the OPEN, FETCH, and CLOSE statements to manipulate the cursor instead of using the cursor FOR loop.

D. Whenever possible, use the cursor FOR loop instead of explicitly declaring the cursor and using the OPEN, FETCH, and CLOSE statements to manipulate the

Discussion of the question

Question 96 🔥

Which two statements are true about the initialization of internal LOBs? (Choose two.)

Which database solution meets these requirements?

A. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs.

B. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non-NULL internal LOBs.

C. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs.

D. The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and EMPTY_BLOB() functions, respectively.

E. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_146

Exam contains 114 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us