违法和不良信息举报 联系客服
免费注册 登录

You lost the PRODSTD tablespace， which was read/write. The t

题目
单选题
You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
A

 restore the tablespace from the backup； there is no need to apply the redo information

B

 restore the full database to recover the data up to the point when you performed the backup

C

 restore the tablespace from the backup and then perform a recovery using the backup control file

D

 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

单选题
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards.  The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1;  3> ALTER DATABASE MOUNT;  4> RESTORE DATABASE;  5> RECOVER DATABASE;  6> ALTER DATABASE OPEN RESETLOGS; 7> };  With reference to this scenario， which statement is true？（）
A

RMAN recovers up to log sequence 230， but not including 230.

B

RMAN returns an error because the log sequence number mentioned in the command should be 229.

C

RMAN returns an error because the log sequence number mentioned in the command may never be missing.

D

RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.


正确答案： D
解析： 暂无解析

第2题：

单选题
The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario？（）
A

 If the FORMAT option to the RMAN BACKUP command is specified， then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files （OMF） format.

B

 If any local destinations for LOG_ARCHIVE_DEST_n are set， then archived redo logs are stored in these destinations as well as in the flash recovery area.

C

 If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter， then the RMAN backup of Oracle managed datafiles （OMF） only will go to the flash recovery area by default.

D

 If no other destination is configured for recovery files， then RMAN places the control file autobackups in the flash recovery area by default.


正确答案： A
解析： 暂无解析

第3题：

单选题
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）
A

 Index-organized table

B

 Mapping Table

C

 Clustered Table

D

 Journal Table


正确答案： B
解析： 暂无解析

第4题：

单选题
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？（）
A

 The location used for control files.

B

 The location used for redo log files.

C

 The location set by using $ORACLE_BASE

D

 The location set by using $ORACLE_HOME

E

 The location set by using CORE_DUMP_DEST

F

 The location set by using BACKGROUND_DUMP_DEST


正确答案： F
解析： 暂无解析

第5题：

单选题
The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command：        SQL> EXECUTE   DBMS_SERVER_ALERT.SET_THRESHOLD        （dbms_server_alert.tablespace_pct_full，        dbms_server_alert.operator_ge，80，        dbms_server_alert.operator_ge，90，        1，1，NULL，   dbms_server_alert.object_type_tablespace，’DATA’）；   What will be the result of the command？（）
A

 The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.

B

 The total numbers of alerts that you receive every day will be reduced.

C

 The total number of alerts that you receive every day will be increased.

D

 No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.


正确答案： C
解析： 暂无解析

第6题：

单选题
In which scenario will you perform a cancel-based recovery？（）
A

 when a tablespace is dropped and you have only RMAN-based backup of the database

B

 when a table is dropped and stored in the Recycle Bin

C

 when you are required to recover an existing table to its previous state

D

 when a tablespace is dropped and you have only a user-managed full backup of the database


正确答案： A
解析： 暂无解析

第7题：

单选题
You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP  （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）;  This command errors out displaying the following message：  ERROR at line 1：  ORA/x7f29371： pending area is not active  ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115  ORA/x7f06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108  ORA/x7f06512： at line 1  What action would you take to overcome this error？（）
A

create the Pending Area before creating the consumer group

B

activate the Pending Area before creating the consumer group

C

increase the size of the large pool to accommodate the Pending Area

D

increase the size of the shared pool to accommodate the Pending Area

E

increase the size of the database buffer cache to accommodate the Pending Area


正确答案： C
解析： 暂无解析

第8题：

单选题
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）
A

 Index-organized table

B

 Mapping Table

C

 Clustered Table

D

 Journal Table


正确答案： D
解析： 暂无解析

第9题：

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


正确答案： E
解析： 暂无解析

第10题：

多选题
Which six files are maintained in the Flash Recovery Area？（）
A

control file

B

RMAN files

C

password file

D

parameter file

E

flashback logs

F

data file copies

G

core dump files

H

archived log files

I

RMAN recovery scripts

J

control file autobackpus


正确答案： A,E
解析： 暂无解析

更多相关问题
相关内容