多项选择题Which two statements are correct regarding the Flashback Versions Query feature?()

A. You can use this feature to identify the committed versions of the rows, but not the uncommitted versions.
B. You can use this feature to identify the versions of V$ views.
C. You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table.
D. You can use this feature for a table only if row movement is enabled for the table.
E. You can use this feature to identify the versions of external and fixed tables.


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()

A. The FLASHBACK TABLE statement will not be written to the alert log file.
B. The EMP table that was dropped by mistake from the database will be restored.
C. The changes made to the EMP table since the specified time will be undone.
D. The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
E. The FLASHBACK TABLE statement will be executed within a single transaction.
F. The list of transactions that have modified the EMP table since the specified time will be displayed.

2.单项选择题Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario?()

A. recovery cannot be performed because a backup was not performed after the last incomplete recovery
B. restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
C. restore all the files from Sunday’s backup, and open the database to reset the database to the point in time when the backup was performed on Sunday
D. restore all the files from Sunday’s backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday

3.单项选择题The loss of the control file forced you to re-create the control file. After re-creating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a five-digit number starting with 0. What could be the possible reason?()

A. These are the data files that are corrupted.
B. There is no SYSAUX tablespace in your database
C. There is a read-only tablespace in your database.
D. These are the data files that cannot be recovered.

4.单项选择题You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace?()

A. restore the tablespace from the backup, and then perform an incomplete recovery
B. restore the tablespace from the backup, and then apply all the redo information
C. restore all the data files in the database, and then perform an incomplete recovery
D. restore the tablespace from the backup

5.多项选择题Which two statements regarding compressed backups in Recovery Manager (RMAN) are true?()

A. Backup compression is disabled by default.
B. Backup compression can be used with both backup sets and image copies.
C. Backup compression cannot be enabled using the CONFIGURE command.
D. Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
E. Backup compression applies to only backup sets.
F. Backup compression applies to only image copies.

6.多项选择题

Exhibit: View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace: SQL> ALTER TABLE trans SHRINK SPACE CASCADE; 
Which objects would be affected by this command?()

A. the materialized views based on the TRANS table
B. the materialized views log of the TRANS table
C. the TRANS table
D. the B*Tree indexes on the TRANS table
E. the large object (LOB) segments of the TRANS table

7.多项选择题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()

A. open the database with the RESTRICTED option
B. open the database with the RESETLOGS option
C. recover to the required SCN only that data file in which the error occurred
D. recover all the data files to the same system change number (SCN)

8.单项选择题

In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective: 
DROP DISKGROUP dgroup1 EXCLUDING CONTENTS; 
What would be the result of this command?()

A. This command would result in an error because the disk group is not empty.
B. The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
C. The command would result in the contents being moved to the parent disk group and dropping of the disk group.
D. The command would result in the disk group being marked as INVALID because it cannot be dropped.
E. The command would drop the disk group, ignoring the EXCLUDING CONTENTS option.

最新试题

On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use?()

题型:单项选择题

In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()

题型:单项选择题

You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’2004­08­05:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()

题型:单项选择题

In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()

题型:多项选择题

You performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()

题型:多项选择题

Consider the recovery steps in each of the cases given below: Case 1: Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files, open the database using the RESETLOGS option. Back up the database. Case 2: Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3:Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?()

题型:单项选择题

For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()

题型:多项选择题

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel­based recovery?()

题型:多项选择题

You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()

题型:多项选择题

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?() 

题型:单项选择题