You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.
Which two options do you have for performing user-managed backups（）
A.You can perform consistent backups only.
B.You can perform a complete database backup without shutting down the database instance.
C.You can back up data files only when all data files have the same SCN recorded in the control file.
D.You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
您可能感兴趣的试卷
你可能感兴趣的试题
You are managing an Oracle Database 11g database. The database is open， and you plan to
performRecovery Manager （RMAN） backups.
Which three statements are true about these backups（）
A.The backups would be consistent.
B.The backups would be inconsistent.
C.The backups would be possible only if the database is running in ARCHIVELOG mode.
D.The backups would be possible only if the database is running in NOARCHIVELOG mode.
E.The backups need to be restored and the database has to be recovered in case of a media failure.
You executed the following command to perform a backup of the USERS tablespace：
SQL> ALTER TABLESPACE users BEGIN BACKUP；
ALTER TABLESPACE users BEGIN BACKUP *
ERROR at line 1：
ORA-01123： cannot start online backup； media recovery not enabled
What could be the reason for this error（）
A.The MTTR Advisor is disabled.
B.The database is in NOARCHIVELOG mode.
C.The tablespace is already in backup mode.
D.The Flash Recovery Area is not configured.
A.The backup will consist of used data blocks only.
B.The database must be shut down to accomplish the backup.
C.The backup can be accomplished without shutting down the database.
D.The backup will contain all database files that have never been backed up.
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.
What would you do to recover the data file（）
A.Take the USERS tablespace offline and re-create the lost data file.
B.Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
C.Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
D.Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server：
LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc
LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’
DB_RECOVERY_FILE_DEST = ’/u01/oradata’
DB_RECOVERY_FILE_DEST_SIZE = 20G
Which statement is true regarding the archived redo log files（）
A.It will be created on the local file system.
B.It will be created only in the Flash Recovery Area.
C.It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
D.It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.
Which two statements are true in this scenario（）
A.You must shut down the database instance to perform the backups.
B.You must configure the Flash Recovery Area （FRA） for the database.
C.You can perform complete database backups without closing the database.
D.All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order：
1：Shut down the instance.
2：Execute the ALTER DATABASE ARCHIVELOG command.
3：Start up the instance and mount the database.
4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database.
Which is the correct sequence of steps for accomplishing the task（）
A.4，1，3，2，5
B.1，3，4，5，2
C.1，3，2，5；4 not required
D.4，1，5，2；3 not required
E.1，3，4，5；2 not required
You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.
What will be the implications on the archiving and the location of archive redo log files（）
A.Archiving will be disabled because the destination for the redo log files is missing.
B.The database instance will shut down and the error details will be logged in the alert log file.
C.Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.
D.Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.
Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）
A.flashback log files
B.backups that have become obsolete
C.copies of the data files and control files
D.archived redo log files that have multiple copies in a different archive location and not backed up
最新试题
Which statements are true regarding a tablespace（）
Examine the following statement that is used to modify the primary key constraint on the SALES table：SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE；Which three statements aretrue regarding the above command（）
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE；Which statements describe the effect of the command（）
Which statements are true regarding listeners（）
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr；Which statement describes the outcome of the command（）
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）
Identify the situations in which you use the alert log file in your database to check the detail.（）
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）