053 (27)

131, Exhibit:

View  to Values  to Set  for  of Database    1440 362 272

132.

 the. You is managing an OracleDatabase11gDatabase. You want toTake theBackup  ofMult_data, a bigfileTablespace ofSize -TB on TapeDrive , and you have tapedrives of  only TenGB each. Which method would accomplish the task quickly andefficiently? A. ParallelImageCopyBackupB.Backup  withMaxpiecesize configured forThe channelc parallel.Backup  withMaxpiecesize configured forThe channed intrafile parallelBackup

133.

133. You performed the RMANDatabase Backup  withThe KEEPoption. Which statements is true regarding thisBackup? (Choose.) A. theBackup containsData files, the server parameterfile, andThe controlfileEvenifThe controlfileAutobackup isdisabled. B. The KEEPoptionoverrides the configured retention policy. C. theBackup contains  onlyData files andArchived RedoLogfiles. D. The KEEPoption  isAn attribute ofAn individualBackupPiece.

134.

134. You is managing an OracleDatabase11gDatabase. You want toTake aBackup  on TapeDrives ofThe USERS tablespace that have a SingleDatafile  of  theMB. you haveTapeDrives of  -MB each. toAccomplish theBackup, you issued the following RMAN Command:rman>BACKUPSection SIZE 300MTABLESPACE users; What configuration should is effected toAccomplish faster andOptimized backups byusing the above command? A. The SBT channel must be configured, withThedefaultParallelism setting forThe SBT deviceSet  to 1. B. The COMPATIBLE initialization parameter forTheDatabaseInstance must beSet  toAt least10.0. C. The SBT channel must be configured, withThe Parallelism setting forThe SBT deviceSet  to 3. D. The SBT channel must be configured, withThe MaxpiecesizeSet  to  -MB.

135.

135. The Admin_empTableHas columns EMPNO, ename, DEPTNO, andSAL. It has a materializedViewEmp_mv withA materializedLog  andAn ENAME_IDXIndex  onThe enamecolumn. You need toPerform an onlineTableredefinition onThe Admin_empTable  toMove it fromThe TBS1 tablespace toThe TBS2 tablespaceinchThe sameSchema. What action isRequired forThe dependent objects whenYou perform online redefinition onTheTable? A. The materializedViewShould a complete refresh performed after the onlineTableredefinition iscompleted. B. The materializedViewShould a fast refresh performed after the onlineTableredefinition iscompleted. C. The materializedView, materializedLog, andTheIndexshould be dropped andRe-Created after the onlineTableredefinition isComplete . D. The materializedView  andMaterializedLogshould be dropped and  AllConstraints disabled andRe-Created after the onlineTableredefinition isComplete.

053 (27)