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

Examine this code:
CREATE OR REPLACE FUNCTION gen_email_name
(p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER)
RETURN VARCHAR2
IS
v_email_name VARCHAR2(19=;
BEGIN
v_email_name := SUBSTR(p_first_name, 1, 1) ||
SUBSTR(p_last_name, 1, 7) ||
'@Oracle.com';
UPDATE employees
SET email = v_email_name
WHERE employee_id = p_id;
RETURN v_email_name;
END;
Which statement removes the function?

• A.DELETE gen_email_name;
• B.DROP FUNCTION gen_email_name;
• C.TRUNCATE gen_email_name;
• D.ALTER FUNCTION gen_email_name REMOVE;
• E.REMOVE gen_email_name;

You need to remove the database triggerBUSINESS_HOUR.Which command do you use to remove the trigger in the SQL *Plus environment?

• A.ALTER TRIGGER business_hour REMOVE;
• B.DROP TRIGGER business_hour;
• C.DELETE TRIGGER business_hour;
• D.REMOVE TRIGGER business_hour;
• E.DELETE FROM USER_TRIGGERS
  WHERE TRIGGER_NAME = 'BUSINESS_HOUR';

You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to enable all triggers on the EMPLOYEES table. Which command accomplished this?

• A.ALTER TRIGGERS ON TABLE employees ENABLE;
• B.You cannot enable multiple triggers on a table in one command.
• C.ALTER employees ENABLE ALL TRIGGERS;
• D.ALTER TABLE employees ENABLE ALL TRIGGERS;

To be callable from a SQL expression, a user-defined function must do what?

• A.Have both IN and OUT parameters.
• B.Return a BOOLEAN or VARCHAR2 data type.
• C.Be stored only in the database.
• D.Use the positional notation for parameters.

A CALL statement inside the trigger body enables you to call ______.

• A.A stored procedure.
• B.A stored function.
• C.Another database trigger.
• D.A package.