最も有効な 1z1-148 試験参考書

Your company decided to update its employees' contact information as a one-time event.
With thousands of employees' records to be updated, the project manager hoped to achieve substantial performance gains using the DBMS_PARALLEL_EXECUTE package and identified these four actions to be executed.
1) dbms_parallel_execute.create_task
2) GRANT system privilege CREATE JOB to the user executing this task
3) dbms_parallel_execute.run_task
4) dbms_parallel_execute.create_chunks_by_rowid
Select the correct order of actions to implement the parallel execution of PL/SQL blocks.

• A. 1, 2, 3 and 4
• B. 2, 4, 1 and 3
• C. 2, 1, 4 and 3
• D. 1, 2, 4 and 3
• E. 2, 1, 3 and 4

Which two statements are true about the DBMS_ LOB package?

• A. If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB.
• B. Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.
• C. DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs.
• D. DBMS_LOB.COMPARE can compare parts of two LOBs.
• E. DBMS_LOB.COMPARE returns the size difference of the compared LOBs.

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 fail with a runtime error complaining of insufficient INHERIT PRIVILEGES.
• B. It will execute successfully and return the date but the DBA role will not be granted to ORA1.
• C. It will execute successfully, return the date and the DBA role will be granted to ORA1.
• D. It will fail with a compile-time error.

Which two statements describe actions developers can take to make their application less vulnerable to security attacks?

• A. Do not concatenate unchecked user input into dynamically constructed SQL statements.
• B. Switch from using DBMS_SQL to EXECUTE IMMEDIATE.
• C. Include the AUTHID DEFINER clause in stored program units.
• D. Increase the amount of code that is accessible to users by default.
• E. Include the AUTHID CURRENT_USER clause in stored program units.

Which two blocks of code execute successfully?

• A. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type := tab_type(2);BEGINmy_tab(1)
  :=55;END;
• B. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab := tab_type ();my_tab (1) := 55;END;
• C. DECLARETYPE tab_type IS TABLE OF NUMBERmy_tab tab_type := tab_type (2, NULL,
  50);BEGINmy_tab.EXTEND (3, 2);END;
• D. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab. EXTEND (2);my_tab (1) := 55;END;
• E. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab (1) :=1;END;