Create Next App

Exam contains 75 questions

Page 11 of 13

Question 61 🔥

Examine this external function declaration:Which C function does it publish?

Which database solution meets these requirements?

A. OCINumber * compareAndSum (OCIExtProcContext *ctx, OCINumber *p1, OCINumber *p2, OCINumber *p3);

Highly voted

B. OCINumber compareAndSum (OCIExtProcContext *ctx, OCINumber p1, OCINumber p2, OCINumber *p3);

Highly voted

C. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, OCINumber *p3);

Highly voted

D. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, OCINumber p3);

Highly voted

E. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, int p3);

Highly voted

F. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, int* p3);

Highly voted

G. OCINumber compareAndSum (OCIExtProcContext *ctx, OCINumber p1, OCINumber p2, OCINumber p3);

Highly voted

Discussion of the question

Question 62 🔥

Examine the EMPLOYEE_IDS table its data:Examine this PL/SQL block:What is the result of executing this PL/SQL block with SERVEROUTPUT enabled?

Which database solution meets these requirements?

A. It executes successfully and outputs: Fetched: 1011, JJONES, 3789 Fetched: 1012, SSMITH, -1

Highly voted

B. Compilation fails saying EMP_TAXID must be declared.

Highly voted

C. An exception is thrown at runtime saying EMP_TAXID is not visible.

Highly voted

D. It executes successfully and outputs: Fetched: 1011, JJONES, Fetched: 1012, SSMITH,

Highly voted

E. It executes successfully and outputs: Fetched: 1011, JJONES, -1

Highly voted

Discussion of the question

Question 63 🔥

Examine this code:CREATE TYPE list_typ IS TABLE OF NUMBER;/DECLARE -l_list list_typ := list_typ ();Which two executable sections will display the message TRUE?

Which database solution meets these requirements?

A. BEGIN IF l_list.LIMIT IS NOT NULL THEN DBMS_OUTPUT.PUT_LINE (TRUE); END IF; END;

Highly voted

B. BEGIN l_list.EXTEND; IF l_list.PRIOR (1_list.FIRST) IS NULL THEN DBMS_OUTPUT.PUT_LINE (TRUE); END IF; END;

Highly voted

C. BEGIN l_list.EXTEND; IF l_list IS EMPTY THEN DBMS_OUTPUT.PUT_LINE (TRUE); END IF; END;

Highly voted

D. BEGIN IF l_list.FIRST IS NULL THEN DBMS_OUTPUT.PUT_LINE (TRUE); END IF; END;

Highly voted

E. BEGIN IF l_list.FIRST =1 THEN DBMS_OUTPUT.PUT_LINE (TRUE); END IF;

Highly voted

Discussion of the question

Question 64 🔥

Examine this function call:cur_num := DBMS_SQL.TO_CURSOR_NUMBER (cur_val);Which two statements are true?

Which database solution meets these requirements?

A. CUR_VAL must be opened after this line is executed in the PL/SQL block.

Highly voted

B. CUR_VAL must be a weakly typed cursor variable.

Highly voted

C. CUR_VAL can be either a strongly or weakly typed cursor variable.

Highly voted

D. CUR_VAL must be opened before this line is executed in the PL/SQL block.

Highly voted

E. The PL/SQL block can continue to use the cursor variable after this line is executed.

Highly voted

Discussion of the question

Question 65 🔥

Which two are correct when migrating BasicFile LOBs to SecureFile LOBs by DBMS_REDEFINITION?

Which database solution meets these requirements?

A. Online redefinition can be done only at the table level.

Highly voted

C. Set the database initialization parameter db_securefile to NEVER.

Highly voted

D. During migration, specify the NOLOGGING storage parameter for any new SecureFiles LOB columns.

Highly voted

E. Online redefinition is the recommended method for migration of BasicFile LOBs to Secure LOBs.

Highly voted

B. Specify only BasicFiles LOB and SecureFiles LOB column names in parameter col_mapping of DBMS_REDEFINITION.START_REDEF_TABLE.

Highly voted

Discussion of the question

Question 66 🔥

Examine this function body:Which two headers will allow this function to compile successfully and take advantage of both invokers rights and function result caching?

Which database solution meets these requirements?

A. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 RESULT_CACHE RELIES_ON (departments) AUTHID CURRENT_USER IS date_hired DATE;

Highly voted

B. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 RESULT_CACHE AUTHID CURRENT_USER IS date_hired DATE;

Highly voted

C. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 RESULT_CACHE AUTHID DEFINER IS date_hired DATE;

Highly voted

D. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 RESULT_CACHE RELIES_ON (employees) AUTHID CURRENT_USER IS date_hired DATE;

Highly voted

E. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 AUTHID DEFINER IS

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_148

Exam contains 75 questions

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

Company

Product

Resources

Follow us