A. An upper limit on how far you can flash back the database, depending on the information in the redo logs
B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
您可能感兴趣的试卷
你可能感兴趣的试题
A. generating the SQL profile
B. testing and accepting the SQL profile
C. generating a list of candidate SQLs for tuning
D. adding tuned SQL plans into the SQL plan baseline
E. tuning each SQL statement in the order of importance
F. generating baselines that include candidate SQLs for tuning
You issued the following command：
CREATE GLOBAL TEMPORARY TABLE admin_work_area
（startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command？（）
A. It stores only the temporary table but not its indexes.
B. It stores both the temporary table as well as its indexes.
C. It must be a nondefault temporary tablespace for the database.
D. It can be a default or nondefault temporary tablespace for the database.
E. It must be the default temporary tablespace of the user who issues the command.
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table.
Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.
Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
A. Restore the backup control file and open the database with RESETLOGS option.
B. Perform point-in-time recovery because flashback cannot be performed again on this table
C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script, which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.
Which two statements are true about this backup operation? （）(Choose two.)
A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager
A. Multiple change tracking files can be created for a database.
B. The change tracking file must be created after the first level 0 backup.
C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
Which statements about the MEMORY_TARGET initialization parameter are true?（） (Choose all that apply.)
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.
The following steps must be performed in the correct sequence to do this:
Choose the correct sequence.（）
A.4，1，3，2，5
B.4，3，1，2，5
C.2，4，3，5，1
D.4，2，5，3，1
The following command is executed to create the baseline template：
SQL> EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=> TO_TIESTAMP（SYSDATE+2），
END_TIME=>TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=>’Mybase4’，
TEMPLATE_NAME=>’Mytemp4’， EXPIRATION=>NULL）；
Which statement is true about the effect of the above command？（）
A. It creates a baseline template that never expires.
B. It produces an error because no snapshot information is provided to create the baseline.
C. It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.
D. It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN).
To accomplish the backup, you issued the following RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true about the execution of the above command? （）(Choose two.)
A. The backup piece size will be limited to 300 MB
B. The RMAN uses multiplexing to perform backup
C. The operation is accomplished using the default channel available
D. The RMAN parallelizes the backup although the parallelism is not set for a channel
最新试题
Which three statements are true about persistent configuration？（）
Which two statements are true about encrypting RMAN backup？（）
Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode？（）
The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner？（）
To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）
View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation： RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； } What is the multiplexing level in the preceding backup process？（）
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch？（）