单项选择题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?()

A.Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 
B.Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 
C.Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D.Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?()

A.A different procedure is required to restore a database from compressed backups 
B.The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. 
C.Using this command to create backups minimizes the bandwidth consumed.
D.Using this command to create backups improves the performance of the backup process 

2.单项选择题You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?()

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.

3.单项选择题ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?()

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

4.单项选择题What is the implication of this command?()

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. 

5.单项选择题While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?()

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. 

6.单项选择题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()

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 

7.多项选择题What are the advantages of variable extent size support for large ASM files?()

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.

8.单项选择题Which statement is true regarding virtual private catalogs? ()

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. 

9.单项选择题Which statement is true regarding this setting?()

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.

最新试题

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()

题型:单项选择题

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a solution to make tape streaming happen during the backup?()

题型:单项选择题

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?()

题型:多项选择题

Which two statements are true about a job chain?()

题型:多项选择题

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?()

题型:单项选择题

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?()

题型:单项选择题

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()

题型:多项选择题

Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()

题型:单项选择题

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?()

题型:单项选择题

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()

题型:多项选择题