-
编辑 删除
043-085
85. A data file become corrupted in your database due to bad sectorson the disk. Because of corruption, you lost all the important tablesin that data file. Which method would you use for recovery?A. F...
-
编辑 删除
043-084
84. 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...
-
编辑 删除
043-083
83. 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,...
-
编辑 删除
032-082
82. You lost the index tablespace in your database. You are not ableto use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?A. The index tablespace contains...
-
编辑 删除
043-081
81. You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for thedisk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIB...
-
编辑 删除
043-080
80. 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. Y...
-
编辑 删除
043-079
79. 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 l...
-
编辑 删除
043-078
78. 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: % ...
-
编辑 删除
043-077
77. 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 usi...
-
编辑 删除
043-076
76. ExhibitViewing the Exhibit and examine the Flashback Database architecture.Identify the missing component (shown with a "?`"= in the Flashback Database architecture.A. DBWnB. RVWRC. ARCHD. RECOE. ...
-
编辑 删除
043-075
75. 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...
-
编辑 删除
043-074
74. While setting up the threshold for tablespace space usage metricsfor one of your tablespaces, you define the critical threshold as 60%and warning threshold as 75%. What would be the result of this...
-
编辑 删除
043-073
73. You work as a database administrator at Certkiller .com. 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 ...
-
编辑 删除
043-072
72. By using the transaction identifier provided by ______ for a particular row change, you can use the Flashback Transaction Query to seethe operation performed by the transaction.A. Flashback TableB...
-
编辑 删除
043-071
71. What effect should the loss of an index tablespace have on an Oracle instance that is running?A. instance hangsB. instance gets abortedC. instance continues runningD. instance gets restarted autom...
-
编辑 删除
043-070
70. 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 timeB.to restore the E...
-
编辑 删除
043-069
69. 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 ...
-
编辑 删除
043-068
68. You noticed that the index tablespace in your database requires arecovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two opti...
-
编辑 删除
043-067
67. You want to create a consumer group, GROUP1, and you execute thefollowing command in the command-line interface:SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP=>'group1', COM...
-
编辑 删除
043-067
67. You want to create a consumer group, GROUP1, and you execute thefollowing command in the command-line interface:SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP=>'group1', COM...
