Miscellaneous New Features

These questions are based on 1Z0-050 – Oracle Database 11g New Features
Oracle Self Test Software Practice Test.


Objective: Miscellaneous new features.
Sub-objective: Describe and use the enhanced online table redefinition.


Single answer, multiple choice


You have a table named AR_TRX_HY that contains the following columns:


AR_TRX_ID
AR_TRX_DATE
AR_TRX_CUST_ID
AR_TRX_AMT


You have a PL/SQL procedure named GET_CUST_TRX that accepts a customer ID and a beginning and ending date, and returns customer accounts receivable transactions for a specific time period. Which statement about using online table redefinition on the AR_TRX_HY table is true?



  1. Any online redefinition will invalidate the GET_CUST_TRX procedure.
  2. If your redefinition affects only columns that are not referenced by the GET_CUST_TRX procedure, the procedure will not be invalidated.
  3. If your redefinition adds a new column, the GET_CUST_TRX procedure will become invalid.
  4. If your redefinition drops the AR_TRX_CUST_ID column, the GET_CUST_TRX procedure will remain valid.

Answer:
B. If your redefinition affects only columns that are not referenced by the GET_CUST_TRX procedure, the procedure will not be invalidated.


Tutorial:
If your redefinition affects only columns that are not referenced by the GET_CUST_TRX procedure, the procedure will not be invalidated. With Oracle 11g, only dependent objects that are logically affected by the redefinition and triggers are invalidated. The GET_CUST_TRX will remain valid and will not need to be recompiled the next time it is executed.


The option that states any online redefinition will invalidate the GET_CUST_TRX procedure is incorrect. Any…


cmadmin

ABOUT THE AUTHOR

Posted in Uncategorized|

Comment:

Powered by WebDesk