单选题Which command would you use to determine what database backups are currently available for restore?()Alist database backupBreport database backupClist backup of databaseDlist summary backupEreport backup of database
点击查看答案
单选题In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()AREBUILDBCASCADECTRUNCATEDROW MOVEMENTESHRINK SPACE COMPACTFSHRINK SPACE CASCADE
单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()Apoint-in-time recoveryBexecute the ROLLBACK command with transaction numberCflashback the database to before the transaction was committedDdetermine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
填空题Which command (without options) would you use to display how much space is available on all mounted partitions?()
多选题You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery?()AChange the RMAN archived log deletion policyBUse the RMAN CROSSCHECK command to reclaim the archived log spaceCChange the RMAN retention policy to retain backups for a shorter period of timeDUse OS command to move files from the flash recovery area to some other location
单选题When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()AINCLUDING DEPENDENCIESBINCLUDING DEPENDENCIES CASCADECCOMPACTDCASCADEENone of the above
单选题In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()A REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE