A.The Flashback Archive FLA1 is dropped only if it is empty.
B.The tablespace having Flashback Archive is dropped.
C.The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D.The Flashback Data Archive and historical data are dropped.
您可能感兴趣的试卷
你可能感兴趣的试题
A.parallel image copy backup
B.backup with MAXPIECESIZE configured for the channel
C.parallel backup with MAXPIECESIZE configured for the channel
D.intrafile parallel backup
A.The command produces an error because the retention time cannot be reduced.
B.All historical data is retained but the subsequent flashback data archives are maintained for only three years.
C.All historical data is purged and the new flashback data archives are maintained for three years.
D.All historical data older than three years is purged from the flashback archive FLA1.
A.The backup fails because one of the archived redo log files is missing.
B.The backup succeeds but it would be without the missing archived log.
C.During backup, you are prompted for the alternative destination for the missing archived redo log file.
D.The backup succeeds because it fails over to one of the alternative archived redo log destinations.
A.SQL statements that are part of the AWR baseline only
B.SQL statements based on the AWR top SQL identification
C.SQL statements that are part of the available SQL Tuning Set (STS) only
D.SQL statements that are available in the cursor cache and executed by a user other than SYS
A.It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
B.It improves performance in the extended cluster configuration by reading from a local copy of an extent.
C.Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
D.This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
A.A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B.The virtual private catalog owner cannot create and modify the stored scripts.
C.The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D.To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
A.It drops the connection after the specified number of login attempts fail for any user.
B.It is enforced only if the password profile is enabled for the user.
C.It locks the user account after the specified number of attempts.
D.It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
![](https://static.ppkao.com/ppmg/img/appqrcode.png)
最新试题
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?()
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
Which three statements are true about persistent configuration?()
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()
Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?()
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.Which method must you use to recover the lost data?()
View the exhibit and examine the TRANS table's storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?()
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()