单项选择题Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()  

A. Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.
B. Oracle will automatically take the datafile out of hot backup mode and then open the database.
C. Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
D. The database will open with the file in hot backup mode. You can restart the backup at any time.
E. The datafile in hot backup mode will be corrupted and you will have to recover it.


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题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

2.单项选择题

What will be the result of the following configuration?()  
Log_archive_dest_1=location=c:\oracle\arch\mydb
Log_archive_dest_2=location=z:\oracle\arch\mydb  

A. An error will occur during database startup because the second parameter is not valid.
B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.
C. Archived redo logs will be created in two different locations by the ARCH process.
D. Archived redo logs will be created in two different locations by the LGWR process.
E. Neither parameter setting is valid, so the database will not start up.

4.单项选择题Which is not a valid way of backing up a control file?()  

A. Backing up the control file to trace
B. Copying the existing control file of the database to the backup location during a hot backup 
C. Copying the existing control file of the database to the backup location during a cold backup
D. Creating a backup control file
E. Using the create controlfile command

5.单项选择题Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?()  

A. Yes, if the database is in ARCHIVELOG mode
B. Yes, if the database is in NOARCHIVELOG mode
C. No, the backup is not usable in any way
D. Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

6.单项选择题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?()  

A. alter tablespace DAVE_TBS backup mode
B. alter tablespace DAVE_TBS start backup
C. alter tablespace DAVE_TBS begin backup
D. alter tablespace DAVE_TBS backup begin
E. alter tablespace DAVE_TBS backup

7.单项选择题Which command will result in a trace file being created with the create controlfile command contained in it?()  

A. alter database backup controlfile
B. alter database backup controlfile to trace
C. alter database controlfile backup
D. alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
E. alter database begin controlfile backup

9.单项选择题Which is the correct command to put the database in ARCHIVELOG mode?()  

A. alter database archivelog
B. alter system enable archivelog mode
C. alter database enable archive
D. alter database archivelog enable
E. None of the above

10.多项选择题What are the different logging modes available in Oracle Database 11g?() 

A. NOLOG mode
B. NOARCHIVELOG mode
C. LOGGING mode
D. HOTDATABASE mode
E. ARCHIVELOG mode

最新试题

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 enable automatic PGA memory management in your database. Which setting is required to achieve this?()

题型:单项选择题

Examine the following RMAN command:  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;  Which prerequisite must be met before accomplishing the backup?()

题型:单项选择题

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:  1) Restore an autobackup of the server parameter file.2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database  Which option illustrates the correct sequence that you must use?()  

题型:单项选择题

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

题型:多项选择题

Which three tasks can be performed using a duplicate database?()

题型:多项选择题

Examine the CREATE DISKGROUP command used to create a disk group:  SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2;  In which situation would you use this method of disk group creation?()

题型:单项选择题

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()  

题型:单项选择题

Examine the following RMAN script:  RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; }  Which statement describes the purpose of the script?()  

题型:单项选择题

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

题型:单项选择题