Create Next App

Exam contains 75 questions

Page 4 of 13

Question 19 🔥

Select the correct statement regarding BEQUEATH CURRENT_USER.

Which database solution meets these requirements?

A. If a view references a PL/SQL function then BEQUEATH CURRENT_USER allows the function to execute with DBA privileges, regardless of the invoking users privileges.

Highly voted

B. The BEQUEATH CURRENT_USER clause allows invoker’s rights functions referenced in a view to execute with the privileges of the invoking user.

Highly voted

C. Any view calling a PL/SQL function with BEQUEATH CURRENT_USER in effect will execute with the privileges of the function owner.

Highly voted

D. With the BEQUEATH CURRENT_USER clause, a definer’s rights function referenced in a view executes with the privileges of the view owner, not the function

Highly voted

Discussion of the question

Question 20 🔥

Which tablespace is used to store the data collected by PL/Scope?

Which database solution meets these requirements?

Discussion of the question

Question 21 🔥

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

Which database solution meets these requirements?

A. The IN parameters must not include BLOB, CLOB, collection or record data types.

Highly voted

B. The function must be created with invoker’s rights or in an anonymous block.

Highly voted

C. The function must be declared as a pipelined table function.

Highly voted

D. The function must have an OUT or an IN OUT parameter.

Highly voted

Discussion of the question

Question 22 🔥

Which two statements are true with respect to fine-grained access control?

Which database solution meets these requirements?

A. It is implemented by end users.

Highly voted

B. It can be used to implement column masking.

Highly voted

C. It implements security rules through functions and associates these security rules with tables, views or synonyms.

Highly voted

D. Separate policies are required for queries versus INSERT/UPDATE/DELETE statements.

Highly voted

E. The DBMS_FGA package is used to set up fine-grained access control.

Highly voted

Discussion of the question

Question 23 🔥

Which two statements are correct about the collections before v3. DELETE is executed?

Which database solution meets these requirements?

A. The values of v3(31) (2) and v3 (33) (2) are identical.

Highly voted

B. The value of v3 (31) (3) is 6.

Highly voted

C. The value of v3 (31) (1) and v3 (33) (3) are identical,

Highly voted

D. The value of v3 (31) (1) is "hello".

Highly voted

E. The values of v3 (32) (2) and v1 (2) are identical.

Highly voted

Discussion of the question

Question 24 🔥

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