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

問題1

Examine the structure of the EMP table:

Examine this code and statements:

Which statement is true?

A. The result cache does not get invalidated at all since the RELIES_ON clause is not used.

B. The result cache gets invalidated only after the second UPDATE statement.

C. The result cache gets invalidated after the ALTER FUNCTION and again after the second UPDATE statement.

D. The result cache gets invalidated only after each UPDATE statement.

E. The result cache gets invalidated after the ALTER FUNCTION and again after each UPDATE statement.

F. The result cache gets invalidated only after the ALTER FUNCTION statement.

正確答案: A

問題2

You create this package and procedure:

Which two blocks will execute without errors? (Choose two.)

A. Option D

B. Option B

C. Option C

D. Option E

E. Option A

正確答案: B,D

問題3

Examine this declaration section:

Which two executable sections will display the message 'Summary is null'?

A. BEGIN1_emp. EXTEND;IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;

B. BEGIN1_rec.emp_id :=1;1_rec.expr_summary := NULL;1_emp :=emp_typ (1_rec);IF
1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;

C. BEGIN1_rec := NULL;1_emp := emp_typ (1_rec);IF 1_emp (1).expr_summary IS EMPTY THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;

D. BEGIN1_emp := emp_typ ();IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;

E. BEGIN1_rec.emp_id :=1;1_rec.expr_summary := EMPTY_CLOB ();1_emp := emp_typ (1_rec);IF
1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;

正確答案: B,D

問題4

With SERVEROUTPUT enabled, you successfully create the package YEARLY_LIST:

Examine this code:

You want to display the contents of CREATE_LIST.
Which two lines need to be corrected in the PL/SQL block? (Choose two.)

A. Line 2

B. Line 3

C. Line 5

D. Line 7

E. Line 6

正確答案: B,D

問題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

Which two can be used to find details of parameters for overloaded PL/SQL routines?

A. ALL_DESCRIBE

B. ALL_SOURCE

C. ALL_ARGUMENTS

D. ALL_PROCEDURES

E. ALL-DEPENDENCIES

正確答案: B,C

問題7

You execute this PL/SQL block:

What will be the outcome?

A. It will fail compile and execute successfully.

B. It will fail compile because of error at line 7.

C. It will fail compile because of errors at lines 5 and 6.

D. It will fail compile because of errors at lines 11 and 12.

E. It will fail compile because of errors at lines 6 and 12.

正確答案: E

問題8

Examine this function that is using the RESULT_CACHE clause:

After executing the function twice, passing 100 and 150 as input parameters, the LOCATIONS table is updated for LOCATION_ID = 100.
Which statement is correct if the function is called again, passing 150 as the input parameter?

A. The results are retrieved from the results cache because the LOCATIONS table was not updated for LOCATION_ID = 150.

B. The function is executed again because the result cache was invalidated when the LOCATIONS table was updated.

C. The function is executed again because the database checks for changes to the LOCATIONS table each time the function is called.

D. The results are retrieved from the results cache because not enough rows of the LOCATIONS table were modified to cause invalidation.

正確答案: A

問題9

Refer to the Exhibit.

Examine this procedure created in a session where PLSQL_OPTIMIZE_LEVEL =2:

PL/SQL tracing in enabled in a user session using this command:
EXEC DBMS_TRACE.SET_PLSQL_TRACE (DBMS_TRACE.TRACE_ENABLED_LINES)
The procedure is executed using this command:
EXEC PRC_1
Examine the exhibit for the content of the PLSQL_TRACE_EVENTS table.
Why is tracing excluded from the PLSQL_TRACE_EVENTS table?

A. PRC_1 is not compiled with debugging information.

B. Tracing will be enabled only for the second execution of PRC_1.

C. DBMS_TRACE.TRACE_ENABLED_LINES traces only exceptions in subprograms.

D. PRC_1 is compiled with the default AUTHID DEFINER clause.

E. Tracing is not enabled with the TRACE_ENABLED_CALLS option.

正確答案: A

問題10

Examine the EMP table:
CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10));
Examine this PL/SQL procedure:

Which is the correct replacement for the assignment to variable l_sql to avoid SQL injection?

A. l_sql := 'SELECT empno FROM emp WHERE ename = ''' || SYS.DBMS_ASSERT.NOOP (p_ename) ||
'''';

B. l_sql := 'SELECT empno FROM emp WHERE ename = ' ||
SYS.DBMS_ASSERT.SIMPLE_SQL_NAME (p_ename);

C. l_sql := 'SELECT empno FROM emp WHERE ename = ' ||
SYS.DBMS_ASSERT.ENQUOTE_LITERAL (p_ename);

D. l_sql := 'SELECT empno FROM emp WHERE ename = ' ||
SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME (p_ename);

E. l_sql := 'SELECT empno FROM emp WHERE ename = ''' ||
SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME (p_ename) || '''';

正確答案: C

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

聯系我們

站內鏈接

最新更新