Select the correct statement regarding BEQUEATH CURRENT_USER.

Select the correct statement regarding BEQUEATH CURRENT_USER. 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 user’s privileges. B. The BEQUEATH CURRENT_USER clause allows invoker’s rights functions referenced in a view to execute with the privileges of the invoking user. C. […]

Read More

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

Which two statements are true with respect to fine-grained access control? A. It is implemented by end users. B. It can be used to implement column masking. C. It implements security rules through functions and associates these security rules with tables, views or synonyms. D. Separate policies are required for queries versus INSERT/UPDATE/DELETE statements. E. […]

Read More

DELETE is executed?

Which two statements are correct about the collections before v3. DELETE is executed? A. The values of v3(31) (2) and v3 (33) (2) are identical. B. The value of v3 (31) (3) is 6. C. The value of v3 (31) (1) and v3 (33) (3) are identical, D. The value of v3 (31) (1) is […]

Read More

Which two statements are true about the DBMS_ LOB package?

Which two statements are true about the DBMS_ LOB package? A. DBMS_LOB.COMPARE can compare parts of two LOBs. B. DBMS_LOB.COMPARE returns the size difference of the compared LOBs. C. DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs. D. If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB. […]

Read More

Which two blocks of code execute successfully?

Which two blocks of code execute successfully? A. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab (1) :=1; END; B. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type(2); BEGIN my_tab(1) :=55; END; C. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab. EXTEND (2); my_tab (1) := […]

Read More

Which statement is true about internal and external LOBs?

Which statement is true about internal and external LOBs? A. An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package. B. A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs. C. Internal and external LOBs can be written using DBMS_LOB. D. After an exception transfers program control […]

Read More