Create Next App

Exam contains 75 questions

Page 2 of 13

Question 7 🔥

You are designing and developing a complex database application built using many dynamic SQL statements. Which option could expose your code to SQL injection attacks?

Which database solution meets these requirements?

A. Using bind variables instead of directly concatenating parameters into dynamic SQL statements

Highly voted

B. Using automated tools to generate code

Highly voted

C. Not validating parameters which are concatenated into dynamic SQL statements

Highly voted

D. Validating parameters before concatenating them into dynamic SQL statements

Highly voted

E. Having excess database privileges

Highly voted

Discussion of the question

Question 8 🔥

Examine this code executed as SYS:Examine this code executed as SPIDER and the error message received upon execution:What is the reason for this error?

Which database solution meets these requirements?

A. The procedure needs to be granted the DYNAMIC_TABLE_ROLE role.

Highly voted

B. The EXECUTE IMMEDIATE clause is not supported with roles.

Highly voted

C. Privileges granted through roles are never in effect when running definer’s rights procedures.

Highly voted

D. The user SPIDER needs to be granted the CREATE TABLE privilege and the procedure needs to be granted the DYNAMIC_TABLE_ROLE.

Highly voted

Discussion of the question

Question 9 🔥

Which codes executes successfully?

Which database solution meets these requirements?

A. CREATE PACKAGE pkg AS TYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER); PROCEDURE calc_price (price_rec IN OUT rec_typ); END pkg; / CREATE PACAKGE BODY pkg AS PROCEDURE calc_price (price_rec IN OUT rec_typ) AS BEGIN price_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100; END calc_price; END pkg; / DECLARE 1_rec pkg. rec_typ; BEGIN 1_rec_price :=100; 1_rec.inc_pct :=50; EXECUTE IMMEDIATE BEGIN pkg. calc_price (:rec); END; USING IN OUT 1_rec; END;

Highly voted

B. CREATE PACKAGE pkg AS TYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER); END pkg; / CREATE PROCEDURE calc_price (price_rec IN OUT pkg. rec_typ) AS BEGIN price_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100; END / DECLARE 1_rec pkg.rec_typ; BEGIN EXECUTE IMMEDIATE BEGIN calc_price (:rec); END; USING IN OUT 1_rec (100, 50); END;

Highly voted

C. CREATE PACKAGE pkg AS TYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER); END pkg; / CREATE PROCEDURE calc_price (price_rec IN OUT pkg. rec_typ) AS BEGIN price_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100; END ; / DECLARE 1_rec pkg. rec_typ; BEGIN 1_rec_price :=100; 1_rec.inc_pct :=50; EXECUTE IMMEDIATE BEGIN calc_price (1_rec); END;; END;

Highly voted

D. DECLARE TYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER); 1_rec rec-typ; PROCEDURE calc_price (price_rec IN OUT rec_typ) AS BEGIN price_rec.price := price-rec.price+ (price_rec.price * price_rec.inc_pct)/100; END; BEGIN 1_rec_price :=100; 1_rec.inc_pct :=50; EXECUTE IMMEDIATE BEGIN calc_price (:rec); END; USING IN OUT 1_rec;

Highly voted

Discussion of the question

Question 10 🔥

Examine this function header:FUNCTION calc_new_sal (emp_id NUMBER) RETURN NUMBER;You want to ensure that whenever this PL/SQL function is invoked with the same parameter value across active sessions, the result is not recomputed.If a DML statement is modifying a table which this function depends upon, the function result must be recomputed at that point in time for all sessions calling this function.Which two actions should you perform?

Which database solution meets these requirements?

B. Enable the result cache by using DBMS_RESULT_CACHE.BYPASS (FALSE).

Highly voted

C. Add the deterministic clause to the function definition.

Highly voted

D. Add the RELIES_ON clause to the function definition.

Highly voted

E. Add the RESULT_CACHE clause to the function definition.

Highly voted

A. Ensure RESULT_CACHE_MAX_SIZE is greater than 0.

Highly voted

Discussion of the question

Question 11 🔥

Examine this block:Which two will be correct after line 5?

Which database solution meets these requirements?

A. va. LAST and va. LIMIT will return the same value.

Highly voted

B. va. LAST and va. COUNT will return the same value.

Highly voted

C. va. LIMIT and va. COUNT will return the same value.

Highly voted

D. va. LIMIT and va. NEXT (199) will return the same value.

Highly voted

E. va. LAST will return 200.

Highly voted

F. va. NEXT (199) will return NULL.

Highly voted

Discussion of the question

Question 12 🔥

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