資料庫管理系統(AS2)

QUESTION 1Examine this package:CREATE OR REPLACE PACKAGE BB_PACKISV_MAX_TEAM_SALARY NUMBER(12,2);PRO

QUESTION 2You need to create a trigger on the EMP table that monitors every row that is changed and

QUESTION 3Which statements are true? (Choose all that apply) ##long not (choose 3)(A)If errors occur

QUESTION 4Which two dictionary views track dependencies? (Choose two)(A)USER_SOURCE(B)UTL_DEPTREE(C)

QUESTION 5Given a function CALCTAX: longCREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN NUMBE

QUESTION 6What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE oper

QUESTION 7What part of a database trigger determines the number of times the trigger body executes?s

QUESTION 8Examine this code:CREATE OR REPLACE FUNCTION gen_email_name(p_first_name VARCHAR2, p_last_

QUESTION 9Which table should you query to determine when your procedure was last compiled?(A)USER_PR

QUESTION 10Examine this code:CREATE OR REPLACE TRIGGER secure_empBEFORE LOGON ON employeesBEGINIF (T

QUESTION 11Examine this package:CREATE OR REPLACE PACKAGE discountsISg_id NUMBER := 7829;discount_ra

QUESTION 12Examine this code:CREATE OR REPLACE TRIGGER update_empAFTER UPDATE ON empBEGININSERT INTO

QUESTION 13Examine this package:CREATE OR REPLACE PACKAGE BB_PACKISV_MAX_TEAM_SALARY NUMBER(12,2);PR

QUESTION 14There is a CUSTOMER table in a schema that has a public synonym CUSTOMER and you are gran

QUESTION 15Which two statements about packages are true? (Choose two)(A)Both the specification and b

QUESTION 16When creating a function in SQL *Plus, you receive this message:"Warning: Function c

QUESTION 17Which four triggering events can cause a trigger to fire? (Choose four) short1.A specific

QUESTION 18Examine this procedure:CREATE OR REPLACE PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME

QUESTION 19Which statement about triggers is true?short(A)You use an application trigger to fire whe

You want to create a PL/SQL block of code that calculates discounts on customer orders. -This code w

QUESTION 21Which type of argument passes a value from a procedure to the calling environment?(A)VARC

QUESTION 22You create a DML trigger. For the timing information, which is valid with a DML trigger?(

QUESTION 23You are about to change the arguments of the CALC_TEAM_AVG function. Which dictionary vie

QUESTION 24A CALL statement inside the trigger body enables you to call ______.(A)A package.(B)A sto

QUESTION 25You need to remove the database triggerBUSINESS_HOUR. Which command do you use to remove
 111    1 2 3 4 5 下一頁 尾頁