单项选择题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）

A. RMAN would use the current operating system location to place the backup.
B. RMAN would use the control file of the target database to maintain the backup.
C. RMAN would use the recovery catalog of the target database to maintain the backup.
D. RMAN would use the control file of the target database to maintain the backup metadata.
E. RMAN would use the recovery catalog of the target database to maintain the backup metadata.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题

Case 1： 
1. Shut down the database and perform a backup. 
2. Restore all the data files. 
3. Mount the database. 
4. Recover the database. 
5. Without applying all the redo log files， open the database using the RESETLOGS option. 
6. Back up the database.
 Case 2： 
1. Shut down the database and perform a backup. 
2. Restore only the data files of the tablespace where user error damaged the data. 
3. Mount the database.
4. Recover the database. 
5. Open the database with the RESETLOGS option. 
6. Back up the database. 
Case 3： 
1. Shut down the database. 
2. Restore the data files. 
3. Open the database. 
4. Perform recovery to the current point in time. 
Which case has the correct steps for an incomplete recovery？（）

A. Only case 1
B. Only case 2
C. Only case 3
D. Case 1 and 2
E. Case 2 and 3
F. Case 1 and 3
G. All cases， case 1， case 2， case 3

点击查看答案
2.单项选择题Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）

A. DBWn
B. RVWR
C. ARCH
D. RECO
E. TRWR

点击查看答案
3.单项选择题You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）

A. assign users to consumer groups
B. set the resource plan for the instance
C. configure a simple resource plan and specify plan directives
D. configure a complex resource plan and specify plan directives

点击查看答案
4.单项选择题While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

A. It would result in an error because the warning threshold cannot be more than the critical threshold.
B. The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C. The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D. Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

点击查看答案
5.单项选择题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

A. The user must have been granted the DBA role.
B. The user must have been granted the switch privilege as a part of a role.
C. The user must have been granted the Resource Manager administrator privilege.
D. The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

点击查看答案
6.单项选择题By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. 

A. Flashback Table
B. Flashback Database
C. Flashback Version Query
D. The RMAN REPORT command
E. The DBA_PENDING_TRANSACTIONS view

点击查看答案
7.单项选择题What effect should the loss of an index tablespace have on an Oracle instance that is running？（）

A. instance hangs
B. instance gets aborted
C. instance continues running
D. instance gets restarted automatically

点击查看答案
8.单项选择题

Why would you use the following FLASHBACK TABLE command？（）
FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；

A. to undo the changes made to the EMP table since the specified time
B. to restore the EMP table that was wrongly dropped from the database
C. to view the transactions that have modified the EMP table since the specified time
D. to view the changes made to the EMP table for one or more rows since the specified time

点击查看答案
9.多项选择题In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

A. the V$LOG view
B. the V$DBFILE view
C. the V$LOGFILE view
D. the V$INSTANCE_RECOVERY view
E. Oracle Enterprise Manager Database Control

点击查看答案
10.多项选择题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

A. ONLINE
B. REVERSE
C. PARALLEL
D. COMPRESS
E. NOLOGGING
F. COMPUTE STATISTICS

点击查看答案

最新试题

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 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？（）

题型：单项选择题

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re­create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re­create the indexes？（）

题型：多项选择题

In which case would you use the Flashback Database feature to perform a recovery？（）

题型：单项选择题

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？（）

题型：单项选择题

View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）

题型：单项选择题

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？（）

题型：单项选择题

View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）

题型：单项选择题

For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）

题型：多项选择题

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）

题型：多项选择题