首页计算机考试Oracle认证
(单选题)

You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body.  Whichstatement is true after you recompile the EMP_ADMIN package body()

AThe USE_P procedure remains valid.

BThe USE_P procedure becomes invalid.

CThe SHOW_DETAIL procedure becomes invalid.

DThe EMP_ADMIN package specification becomes invalid and needs to be recompiled

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which LogMiner command can you use to find out which user made the table change?()

    答案解析

  • (单选题)

    You received the following error:   ORA-01578: ORACLE data block corrupted   (file # %s, block # %s)   Which file will you check to view additional information regarding the cause of this error?()

    答案解析

  • (单选题)

    You need to rename a data file of a tablespace. How would you perform this?()

    答案解析

  • (单选题)

    By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:  a) A list of changes made along with the transaction identifier of each change.  b) The necessary SQL statements to undo the erroneous changes.  Which option would you choose?()

    答案解析

  • (单选题)

    By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:  a) a list of changes made along with the transaction identifier of each change  b) the necessary SQL statements to undo the erroneous changes  Which option would you choose?()

    答案解析

  • (单选题)

    By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:  a) a list of changes made along with the transaction identifier of each change  b) the necessary SQL statements to undo the erroneous changes  Which option would you choose?() 

    答案解析

  • (单选题)

    You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to ()

    答案解析

  • (单选题)

    You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing?()

    答案解析

  • (单选题)

    You work as a database administrator for Certkiller .com. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of atablespace. Which statement is true in this scenario?()

    答案解析

快考试在线搜题