最新的Oracle 1z0-148免費考試真題

問題1

Examine the DBMS_LOB.LOADCLOBFROMFILE procedure:

Which statement is true about DBMS_LOB.LOADCLOBFROMFILE?

A. An exception will always be raised if amount plus src_offset exceeds the length of the BFILE.

B. If any error occurs when calling the procedure then it is written to the warning parameter and DBMS_LOB.LOADCLOBFROMFILE finishes successfully.

C. The amount parameter can be set to DBMS_LOB.LOBMAXSIZE to indicate to load to the end of the BFILE.

D. The amount parameter can be set to NULL to indicate to load to the end of the BFILE.

正確答案: C

問題2

Examine this code executed in the ORA1 schema:

Examine this code executed by DBA_USER who has been granted the DBA role:
REVOKE INHERIT PRIVILEGES ON USER dba_user FROM PUBLIC;
Examine this query:
SELECT return_date (1) FROM dual;
What is the result of executing this query in the DBA_USER schema?

A. It will execute successfully and return the date but the DBA role will not be granted to ORA1.

B. It will fail with a compile-time error.

C. It will execute successfully, return the date and the DBA role will be granted to ORA1.

D. It will fail with a runtime error complaining of insufficient INHERIT PRIVILEGES.

正確答案: C

問題3

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?

A. Having excess database privileges

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

C. Using automated tools to generate code

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

E. Validating parameters before concatenating them into dynamic SQL statements

正確答案: D

問題4

Examine these statements regarding the DBMS_RESULT_CACHE package:
1.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by the PL/ SQL function result cache only.
2.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by both the PL/SQL function result cache and the SQL result cache.
3.DBMS_RESULT_CACHE package is owned by the SYS user.
4.RESULT_CACHE_MODE can be set using a subprogram defined in the DBMS_RESULT_CACHE package.
Which set of statements is correct?

A. 2 and 3

B. 1 and 4

C. 2 and 4

D. 2, 3 and 4

E. 1 and 3

正確答案: C

問題5

Examine this code:

The anonymous block fails this error stack:

Which two changes, when separately applied, would prevent these errors from occurring?

A. Define v2 as pkg. rec.

B. Nothing because using the function TABLE (V1) is prohibited.

C. Initialize v1 and v2 with appropriate constructor functions.

D. Define v2 as employees%ROWTYPE.

E. Define v1 as employees%ROWTYPE.

正確答案: A,D

問題6

Examine this code:

Users of this function may set different date formats in their sessions.
Which two modifications must be made to allow the use of your session's date format when outputting the cached result of this function?

A. Change the data type of 1_date to DATE.

B. Change AUTHID to CURRENT_USER.

C. Use the TO_CHAR function around SYSDATE, that is, 1_date := TO_CHAR (SYSDATE).

D. Set the RESULT_CACHE_MODE parameter to FORCE.

E. Change the RETURN type to DATE.

F. Set NLS_DATE_FORMAT to 'DD-MM-YY' at the instance level.

正確答案: B,E

最新的Oracle Database: Advanced PL/SQL - 1z0-148免費考試真題

聯系我們

站內鏈接

最新更新