資料庫管理系統(AS2)

QUESTION 51You need to disable all triggers on the EMPLOYEES table.Which command accomplishes this?(

QUESTION 52An internal LOB is _____.NOT A(A)A table.(B)A column that is a primary key.(C)Stored in t

QUESTION 53Examine this code:CREATE OR REPLACE FUNCTION calc_sal(p_salary NUMBER) RETURN NUMBERISv_r

QUESTION 54This statement fails when executed:CREATE OR REPLACE TRIGGER CALC_TEAM_AVGAFTER INSERT ON

QUESTION 55Examine this code:CREATE OR REPLACE PROCEDURE audit_emp(p_id IN emp_empno%TYPE)ISv_id NUM

QUESTION 56Examine this code:CREATE OR REPLACE PACKAGE metric_converterISc_height CONSTRAINT NUMBER

QUESTION 57What is a condition predicate in a DML trigger?(A)A conditional predicate allows you to s

QUESTION 58Examine this package specification:CREATE OR REPLACE PACKAGE concat_allISv_string VARCHAR

QUESTION 59Local procedure A calls remote procedure B.Procedure B was compiled at 8 A.M. Procedure A

QUESTION 60Under which two circumstances do you design database triggers? (Choose two)to for(A)To du

QUESTION 61Examine this procedure:CREATE OR REPLACE PROCEDURE DELETE_PLAYER(V_ID IN NUMBER)ISBEGINDE

QUESTION 62Examine this package:CREATE OR REPLACE PACKAGE manage_empsIStax_rate CONSTANT NUMBER(5,2)

QUESTION 63Which command must you issue to allow users to access the UPD_TEAM_STAT trigger on the TE

QUESTION 64Examine this code:CREATE OR REPLACE PROCEDURE set_bonus(p_cutoff IN VARCHAR2 DEFAULT 

QUESTION 65Which three statements are true regarding database triggers? (Choose three)acd(A)A databa

QUESTION 66You create a DML trigger. For the timing information, which are valid with a DML trigger?

QUESTION 67Which two statements about the overloading feature of packages are true? (Choose two)頭尾 o

QUESTION 68All users currently have the INSERT privilege on the PLAYER table. You only want your use

QUESTION 69When creating a function, in which section will you typically find the RETURN keyword?(A)

QUESTION 70A dependent procedure or function directly or indirectly references one or more of which

QUESTION 71Which three are true regarding error propagation? (Choose three)no block(A)An exception c

QUESTION 72Which two tables or views track object dependencies? (Choose two)(A)USER_DEPENDENCIES(B)U

QUESTION 73Examine the trigger heading:CREATE OR REPLACE TRIGGER salary_checkBEFORE UPDATE OF sal, j

QUESTION 74You have an AFTER UPDATE row-level on the table EMP. The trigger queries the EMP table an

QUESTION 75The add_player, upd_player_stat, and upd_pitcher_stat procedures are grouped together in
 111   首頁 上一頁 1 2 3 4 5 下一頁 尾頁