单项选择题Which backup option defines a user-defined name for a backup? ()

A.FORMAT
B.NAME
C.TAG
D.FORMAT U%


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?()

A.Differential incremental backup
B.Different incremental backup 
C.Cumulative backup 
D.Cumulative incremental backup

2.单项选择题Which of the following best describes a full backup? ()

A.All datafiles of a database 
B.All datafiles, archive logs, and control files 
C.All datafiles and control files 
D.All the used blocks in a datafile

3.单项选择题How is block-change tracking enabled?()

A.With alter database enable block change tracking
B.With alter system enable block change tracking 
C.With an init.ora parameter change 
D.With an spfile parameter change 

4.单项选择题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()

A.Restore and recover the datafile. 
B.Restore and recover the tablespace. 
C.Restore and recover the database. 
D.Restore and recover the control file. 
E.Restore and recover the parameter file.

5.单项选择题What does the SCN represent?()

A.The system change number, which is a point in time relative to transactions within a given database. 
B.A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases. 
C.The security change number, which represents the security code that is needed to access any database structure.
D.A conversion factor that converts internal database time to external clock time. 
E.UTC time in the database, providing a standardized way of tracking time in Oracle. 

6.单项选择题What is the proper procedure to recover a lost tempfile?()

A.Restore the backup copy of the tempfile from the backup media. 
B.Re-create the tempfile with the create tempfile command. 
C.Copy an existing tempfile from another database. 
D.Re-create the tempfile with the create tablespace command. 
E.Re-create the tempfile with the alter tablespace command.

8.单项选择题Your archive-log destination directory runs out of space. What is the impact of this on the database?()

A.None. The database will switch over to the stand-by archive-log destination directory. 
B.A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced. 
C.The database will shut down, and will not restart until you correct the out-of-space situation. 
D.The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally. 
E.Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.

9.单项选择题What is the proper command to shut down the database in a consistent manner?()

A.shutdown abort 
B.shutdown kill 
C.Shutdown nowait 
D.shutdown immediate
E.shutdown halt

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

最新试题

You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?()

题型:单项选择题

Which three statements are true about windows?()

题型:多项选择题

You executed the following commands in a database session:What could have caused the recycle bin to clean up?()

题型:单项选择题

Which two commands never trigger an implicit rebalancing within the disk group?()

题型:多项选择题

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

题型:单项选择题

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

题型:单项选择题

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()

题型:多项选择题

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

题型:多项选择题

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()

题型:单项选择题

View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()

题型:单项选择题