1z0-148 Exam Questions Answers

Valid4sure 1z0-148 VCE Practice Test

New Updated 1z0-148 Exam Questions from valid4sure 1z0-148 PDF dumps! Welcome to download the newest valid4sure 1z0-148 VCE dumps: (76 Q&As)

  • Oracle Database 12c: Advanced Pl/SQL certification exam

Keywords: 1z0-148 exam dumps,1z0-148 exam questions, 1z0-148 VCE dumps, 1z0-148 PDF dumps, 1z0-148 practice tests, 1z0-148 study guide, 1z0-148 braindumps,

PS. New 1z0-148 dumps PDF   https://www.valid4sure.com/top/demo/Oracle/1z0-148.pdf



1z0-148 Practice Test Questions Answers – 1z0-148 braindump

QUESTION NO: 21

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

 

A. UNDOTBS1

B. SYSAUX

C. SYSTEM

D. TEMP

E. USERS

 

Answer: B

References:

 

QUESTION NO: 22

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

 

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

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

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

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

 

Answer: C

QUESTION NO: 23

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. The DBMS_FGA package is used to set up fine-grained access control.

 

Answer: C,D


QUESTION NO: 24

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 “hello”.

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

 

Answer: A,D

 

QUESTION NO: 25

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.

E. Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.

 

Answer: D,E