053 (12)

56.

 About. You discover that your Recycle BincontainsTables withThe same name, my_table. You also has aTableNamed My_tableinchYourSchema. YouExecuteThe following Statement:flashbackTABLEMy_table toBeforeDROPRENAME toMy_table2; What would be is the result ofexecuting this statement? A. One ofThe tables isRecovered fromThe Recycle Bin using a firstinchFirst out (FIFO) approach. B. One ofThe tables isRecovered fromThe Recycle Bin using a lastinchFirst out (LIFO) approach. C. Both The tables is recovered fromThe Recycle Bin withOneTableRenamed toMy_table2 andThe other toA system-generated name. D. None ofThe tables is recovered fromThe Recycle Bin, andThe statementreturnsAn error.

57.

 $  of Database  as  into The ASM instance? A. Asmbb. Pmonc. Rbald. Smon

58.

 -  is  when  as on thevalueswith as expiration duration.

59.

 -. You have notConfigured Oracle Managed Files (OMF)inchYourDatabase. do notWant toScan the entire datafile every time an incrementalBackup  isperformed. You decide toEnable the block change tracking feature. Which statement should you Use  toEnable the block change tracking feature? A.ALTER DATABASEENABLE BLOCK Change TRACKING; B.ALTERSYSTEM ENABLE BLOCK Change TRACKING USINGFILE <Path>; C.ALTER DATABASEENABLE BLOCK Change TRACKING USINGFILE <Path>;D.ALTERSYSTEM ENABLE BLOCK Change TRACKING;

60.

 -. forWhich situations would you UseFunctionality provided byThe Resource Manager? (Choose.) A. Setting Idle timeout Limits onresource PLANSB. Saving storageSpace  byUsing compressedBackupSETSC Creating jobs that would run automatically at a scheduled TimeD. Assigning Priorities toJobs toManage Access tosystem Resourcese. Creating Alerts toPerform notification whenTablespaces is low onAvailableSpaceResources

053 (12)