1Z0-147 試験問題を無料オンラインアクセス

Examine this code:
CREATE OR REPLACE FUNCTION gen_email_name
(p_first VARCHAR2, p_last VARCHAR2)
RETURN VARCHAR2
IS
v_email_name VARCHAR (19) ;
BEGIN
v_email_bame := SUBSTR(p_first, 1, 1) ||
SUBSTR(p_last, 1, 7) ||
RETURN v_email_name;
END;
/
Which two statements are true? Select two.

• A.This function can be used against any table.
• B.This function is invalid.
• C.This function can be used only on tables where there is a p_first and p_last column.
• D.This function will generate a string based on 2 character values passed into the function.
• E.This function can be used only if the two parameters passed in are not null values.
• F.This function cannot be used in a SELECT statement.

You have a table with the following definition:
CREATE TABLE long_tab
(id NUMBER);
long_col LONG)
You need to convert the LONG_COL column from a LONG data type to a LOB data type. Which
statement accomplish this task?

• A.ALTER TABLE long_tab MODIFY (LONG_COL CLOB);
• B.EXECUTE utl_lob.migrate(long_tab, long_col, clob)
• C.EXECUTE utl_manage_lob.migrate(long_tab, long_col, clob)
• D.EXECUTE dbms_manage.lob.migrate(long_tab, long_col, clob)
• E.EXECUTE dbms_lob.migrate(long_tab, long_col, clob)

Which three are true regarding error propagation? (Choose three)

• A.The use of the RAISE; statement in an exception handler reraises the current exception.
• B.An exception raised inside a declaration immediately propagates to the current block.
• C.An exception raised inside an exception handler immediately propagates to the enclosing block.
• D.An exception cannot propagate across remote procedure calls.

The OLD and NEW qualifiers can be used in which type of trigger?

• A.Statement level system trigger
• B.Row level DML trigger
• C.Statement level DML trigger
• D.Row level application trigger
• E.Statement level application trigger
• F.Row level system trigger

Which statement is true about removing packages?

• A.Removing a package specification removes the body too
• B.Removing a package specification removes all stand alone stored functions named in the specification
• C.You must remove both the package body and the specification separately
• D.Removing the package body removes the specification too
• E.You must remove the package body first