网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which view provides information on the backup status of the datafiles in the database？（）
- A、 V$BACKUP
- B、 V$BACKUP_STATUS
- C、 V$BACKUP_DATAFILE
- D、 V$DATAFILE_BACKUP
- E、 V$TABLESPCE_BACKUP
参考答案
更多 “Which view provides information on the backup status of the datafiles in the database？（） A、 V$BACKUPB、 V$BACKUP_STATUSC、 V$BACKUP_DATAFILED、 V$DATAFILE_BACKUPE、 V$TABLESPCE_BACKUP” 相关考题
考题
Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase?()
A.V$BACKUPB.V$BACKUP_STATUSC.V$BACKUP_DATAFILED.V$DATAFILE_BACKUPE.V$TABLESPCE_BACKUP
考题
YouareusingtheBlockMediaRecoveryfeaturetorecovertheblocksthataremarkedcorruptsincethelastbackup.Whichviewwillyouquerytodisplayinformationaboutthedatablocksthataremarkedcorruptsincethelastbackup?()
A.V$BACKUP_CORRUPTIONB.V$COPY_CORRUPTIONC.V$DATABASE_BLOCK_CORRUPTIOND.RC_BACKUP_CORRUPTION
考题
You are evaluating the use of pass-through disks for the database servers. You need to recommend a backup solution for the database servers that meets the following requirements： - Minimizes costs. - Provides for the recovery of the databases if a hardware failure occurs. What should you include in the recommendation？（）A、Create full backups of the Hyper-V host by using Windows Server BackupB、Create snapshots of the VMs from Hyper-V ManagerC、Create full backups of the Hyper-V host by using Microsoft System Center Data Protection ManagerD、Create full backups of the VMs by using Windows Server Backup from within the VMs
考题
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
考题
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
考题
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A、 V$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST
考题
What view might you use to try to determine how long a particular backup will take?（）A、V$SESSION_EVENT B、V$SESSION C、V$W0041ITSD、V$WAITSTAT E、V$SESSION_LONGOPS
考题
Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）A、V$BACKUPSETB、RC_DATABASEC、V$BACKUP_SETD、RC_BACKUP_SET
考题
Which view provides information on the backup status of the datafiles in the database?（）A、V$BACKUPB、V$BACKUP_STATUS C、V$BACKUP_DATAFILE D、V$DATAFILE_BACKUP E、V$TABLESPCE_BACKUP
考题
You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A、create a backup of the database and recover all corrupted blocks found in the backupB、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
考题
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
考题
Which dynamic view displays the status of block-change tracking?（）A、V$BLOCK_CHANGE B、V$BLOCK_CHANGE_TRACKING C、V$BLOCKCHANGE D、V$BLOCK_TRACKING
考题
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
考题
Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A、V$DATAFILEB、V$TEMPFILEC、V$DBFILED、V$DATAFILE_HEADER
考题
You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（） A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
考题
You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）A、 Create a backup of the database and recover all corrupted blocks found in the backup.B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
考题
What view might you use to try to determine how long a particular backup will take？（） A、 V$SESSION_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SESSION_LONGOPS
考题
单选题You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A
V$DATABASEB
V$FLASHBACK_DATABASE_STATC
V$FLASHBACK_DATABASE_LOGD
V$RECOVERY_FILE_DEST
考题
单选题Which view provides information on the backup status of the datafiles in the database？（）A
V$BACKUPB
V$BACKUP_STATUSC
V$BACKUP_DATAFILED
V$DATAFILE_BACKUPE
V$TABLESPCE_BACKUP
考题
单选题Which view provides information on the backup status of the datafiles in the database?（）A
V$BACKUPB
V$BACKUP_STATUS C
V$BACKUP_DATAFILE D
V$DATAFILE_BACKUP E
V$TABLESPCE_BACKUP
考题
单选题What view might you use to try to determine how long a particular backup will take？（）A
V$SESSION_EVENTB
V$SESSIONC
V$WAITSD
V$WAITSTATE
V$SESSION_LONGOPS
考题
单选题You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A
create a backup of the database and recover all corrupted blocks found in the backupB
run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC
run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD
run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE
run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
考题
单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A
Query the V$FLASHBACK_DATABASE_LOG view.B
Query the V$FLASHBACK_DATABASE_STAT view.C
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D
Query the V$RECOVERY_FILE_DEST view.
考题
单选题You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（）A
The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.B
The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.C
The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.D
The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
考题
单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A
V$FLASHBACK_DATABASE_LOGB
V$FLASHBACK_DATABASE_STATC
V$DATABASED
V$UNDOSTAT
考题
单选题You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A
V$BACKUP_CORRUPTIONB
V$COPY_CORRUPTIONC
V$DATABASE_BLOCK_CORRUPTIOND
RC_BACKUP_CORRUPTION
热门标签
最新试卷