单项选择题You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()

A. The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.
B. Before the instance starts, you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens because two redo log groups still exist.
E. The instance starts and the database opens, but every attempt to write to redo log files fails with an error.


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()

A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday’s backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening

2.单项选择题You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?()

A. streams pool
B. shared pool
C. log buffer
D. keep buffer cache
E. recycle buffer cache

3.单项选择题You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups?()

A. You need to mention it with every BACKUP command.
B. The block change tracking feature is used automatically by RMAN.
C. You need to configure it using the CONFIGURE command.
D. You need to set the necessary initialization parameters to direct RMAN to use the feature.

4.多项选择题You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? ()

A. The member jobs would get dropped when the job class is dropped.
B. Both the jobs would be executed concurrently.
C. The member jobs would get disabled when the job class is dropped.
D. The attributes defined at the class level would be applied to both the jobs.
E. Jobs in the job class must have been assigned the same priority.

5.单项选择题The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configured to perform a transportable tablespace import?()

A. DB_4K_CACHE_SIZE only
B. DB_8K_CACHE_SIZE only
C. DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
D. DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
E. SGA_TARGET and DB_4K_CACHE_SIZE
F. DB_CACHE_SIZE only

6.多项选择题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.

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

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

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

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

最新试题

You lost the index tablespace in your database. You are not able to use tablespace point­in­time recovery on the index tablespace. What could be the reason for this?()

题型:单项选择题

You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()

题型:单项选择题

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

题型:单项选择题

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

题型:单项选择题

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

题型:多项选择题

You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()

题型:单项选择题

View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()

题型:单项选择题

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

题型:单项选择题

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

题型:多项选择题

In which case would you use the Flashback Database feature to perform a recovery?()

题型:单项选择题