QUESTION 86 The add_player procedure inserts rows into the PLAYER table. Which command will show this directory dependency? (A) SELECT * FROM USER_DEPENDENCIES WHERE REFERENCD NAME = ' PLAYER ' ; (B) SELECT * FROM USER DEPENDENCIES WHERE REFERENCD NAME = ' ADD PLAYER ' ; (C) SELECT * FROM USER_DEPENDENCIES WHERE TYPE = 'DIR' ; (D) SELECT * FROM USER DEPENDENCIES WHERE REFERENCD NAME = ' TABLE ' ;

複選題QUESTION 84 Procedure PROCESS_EMP references the table EMP. Procedure UPDATE_EMP updates rows if table EMP through procedure PROCESS_EMP. There is a remote procedure QUERY_EMP that queries the EMP table through the local procedure PROCESS_EMP. The dependency mode is set to TIMESTAMP in this session. Which two statements are true? (Choose two) BE (A) If the signature of procedure PROCESS_EMP is modified and successfully recompiles, the EMP table is invalidated. (B) If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time. (C) If the signature of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time. (D) If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the first time. (E) If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the second time.

其他試題