A data file become&#...

单项选择题X 纠错

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

A. Flash back all the tables in the data file， one by one.
B. Restore the data file to a new location and perform a media recovery.
C. Flash back the database， there is no need to restore the data file.
D. Restore the data file from the most recent backup and flash the database.

参考答案：

进入题库练习

单项选择题

Exhibit： View the Exhibit and examine the characteristic of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to， in order to find information about table fragmentation？（）

A. Memory Advisor
B. Segment Advisor
C. SLQ Tuning Advisor
D. SLQ Access Advisor
E. Automatic Database Diagnostic Monitor （ADDM）

点击查看答案进入题库练习

单项选择题

For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）

A. Set the CPU time per call in the users profile.
B. Set the CPU time per session in the users profile.
C. Set the CPU levels for the user’s group using Resource Manager.
D. Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

点击查看答案进入题库练习

单项选择题

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

A. The index tablespace contains bitmap indexes.
B. The index tablespace contains more than one data file.
C. The index tablespace supports only complete recovery.
D. The index tablespace is not a dictionary-managed tablespace.
E. There is a dependency relationship between a table and its indexes.

点击查看答案进入题库练习

单项选择题

You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）

A. When a file is created in DGROUP1 with the template， it would have three-way mirroring.
B. When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
C. When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.
D. When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.
E. When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file striping.

点击查看答案进入题库练习

单项选择题

The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）

A. Fixed views
B. The alert log file
C. The parameter file
D. The server parameter file
E. Dynamic performance views

点击查看答案进入题库练习

单项选择题

You disabled the Flashback Database feature by using the following command：
SQL> ALTER DATABASE FLASHBACK OFF；
What would be the effect of this command on the existing flashback logs？（）

A. Flashback logs are not deleted.
B. Flashback logs are deleted automatically.
C. Flashback logs are deleted only if you are using Recovery Manager （RMAN）
D. Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
E. Flashback logs are deleted only if you are using Automatic Storage Management （ASM）

点击查看答案进入题库练习

单项选择题

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.

点击查看答案进入题库练习

单项选择题

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

点击查看答案进入题库练习

单项选择题

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

点击查看答案进入题库练习

单项选择题

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

点击查看答案进入题库练习