Create Next App

Exam contains 75 questions

Page 1 of 13

Question 1 🔥

Examine the code:Which two subprograms will be created successfully?

Which database solution meets these requirements?

A. CREATE FUNCTION p4 (y pkg.tab_typ) RETURN pkg.tab_typ IS BEGIN EXECUTE IMMEDIATE SELECT pdt_id, pdt_name FROM TABLE (:b) BULT COLLECT INTO pkg.x USING y; RETURN pkg.x; END p4;

Highly voted

B. CREATE PROCEDURE p1 (y IN OUT pkg.tab_typ) IS BEGIN EXECUTE IMMEDIATE SELECT f (:b) FROM DUAL INTO y USING pkg.x; END p1;

Highly voted

C. CREATE PROCEDURE p2 (v IN OUT VARCHAR2) IS BEGIN EXECUTE IMMEDIATE SELECT f (:b) FROM DUAL INTO v USING pkg.x; END p2;

Highly voted

D. CREATE FUNCTION p3 RETURN pkg. tab_typ IS BEGIN EXECUTE IMMEDIATE SELECT f (:b) FROM DUAL INTO pkg.x; END p3;

Highly voted

E. CREATE PROCEDURE p5 (y pkg. rec_typ) IS BEGIN EXECUTE IMMEDIATE SELECT pdt_name FROM TABLE (:b) BULK COLLECT INTO y USING pkg.x;

Highly voted

Discussion of the question

Question 2 🔥

Examine the section of code taken from a PL/SQL program:PLSQL_OPTIMIZE_LEVEL PARAMETER is set to 3.Which two statements are true?

Which database solution meets these requirements?

A. Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.

Highly voted

B. Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.

Highly voted

C. Calls to TESTPROC are not inlined in the line commented as Call 1.

Highly voted

D. Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.

Highly voted

E. Calls to TESTPROC might be inlined in the line commented as Call 2.

Highly voted

Discussion of the question

Question 3 🔥

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

Which database solution meets these requirements?

A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.

Highly voted

B. To execute chunks in parallel, users must have CREATE JOB system privilege.

Highly voted

C. No specific system privileges are required to create or run parallel execution tasks.

Highly voted

D. Only DBAs can create or run parallel execution tasks.

Highly voted

E. Users with CREATE TASK privilege can create or run parallel execution tasks.

Highly voted

Discussion of the question

Question 4 🔥

Which two statements are true regarding edition-based redefinition (EBR)?

Which database solution meets these requirements?

A. There is no default edition defined in the database.

Highly voted

B. EBR does not let you upgrade the database components of an application while in use.

Highly voted

C. You never use EBR to copy the database objects and redefine the copied objects in isolation.

Highly voted

D. Editions are non-schema objects.

Highly voted

E. When you change an editioned object, all of its dependents remain valid.

Highly voted

F. Tables are not editionable objects.

Highly voted

Discussion of the question

Question 5 🔥

Which two blocks of code execute successfully?

Which database solution meets these requirements?

A. DECLARE SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9; my_val new_one; BEGIN my_val :=0; END;

Highly voted

B. DECLARE SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string; BEGIN my_str := abc; END;

Highly voted

C. DECLARE SUBTYPE new_one IS NUMBER (2, 1); my_val new_one; BEGIN my_val :=12.5; END;

Highly voted

D. DECLARE SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL; my_val new_one; BEGIN my_val :=2; END;

Highly voted

E. DECLARE SUBTYPE new_one IS NUMBER (1, 0); my_val new_one; BEGIN my_val := -1;

Highly voted

Discussion of the question

Question 6 🔥

The STUDENTS table exists in your schema.Examine the DECLARE section of a PL/SQL block:Which two blocks are valid?

Which database solution meets these requirements?

B. BEGIN OPEN stcur; cursor1 :=stcur; END;

Highly voted

A. BEGIN OPEN cursor3 FOR SELECT * FROM students; cursor1 :=cursor3; END;

Highly voted

C. BEGIN OPEN cursor1 FOR SELECT * FROM students; stcur :=cursor1; END;

Highly voted

D. BEGIN OPEN stcur; cursor3 :=stcur; END;

Highly voted

E. BEGIN OPEN cursor1 FOR SELECT * FROM students; cursor2 :=cursor1;

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