搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【单项选择题】

The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()

A、A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

B、B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

C、C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

D、D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

更多“The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()”相关的问题
第1题

A、Mount the database  B、Open the database in NORMAL mode  C、Open the database in RESTRICTED mode  D、Open the database with the RESETLOGS option  

点击查看答案
第2题

A、Mount the database  B、Open the database in NORMAL mode  C、Open the database in RESTRICTED mode  D、Open the database with the RESETLOGS option  

点击查看答案
第3题

A、It contains data till the last backup  B、It contains all data from target database until the current time  C、It contains all data from only the committed transactions in the target database  D、It contains all data except that which is used by the transactions in the current online redo file of target database  

点击查看答案
第4题

A、The source database backup must be copied over the net for test database.  B、The source database must be run in ARCHIVELOG mode if the database is open.  C、The source database must be shut down cleanly if the database is in mounted state.  D、A net service name should be set up and a listener configured with the target as well as the source database.  

点击查看答案
第5题

A、The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.  B、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.  C、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.  D、If you restart the database, the database will not be opened.  

点击查看答案
第6题

A、The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.  B、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.  C、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.  D、If you restart the database, the database will not be opened.  

点击查看答案
第7题

A、The C # # ROLE1 role is created in the root database and all the PDBs.  B、The C # # ROLE1 role is created only in the root database because the container clause is not used.  C、Privileges are granted to the C##A_ADMIN user only in the root database.  D、Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.  E、The statement for granting a role to a user fails because the CONTAINER clause is not used.  

点击查看答案
第8题

A、The sequence numbers are checked, and if the LSA is val id it is entered into the topology database.  B、The LSA is placed in the topological database and an acknowledgement is sent to the transmitting router.  C、The LSA is dropped and a message is sent to the transmitting router.  D、The LSA is flooded imme diately out of all the OSPF interfaces, except the interface from which the LSA was received.  

点击查看答案
第9题

A、The data files of the read-only tablespaces in the target database are not duplicated  B、The read-only tablespaces in the target database are still defined in new the database  C、The read-only tablespaces in the target database are changed to online after duplication  D、The data files of the read-only tablespaces in the target database get duplicated  E、The read-only tablespaces in the target database are not defined in the new database  

点击查看答案
第10题

A、When the instance is started   B、When thedatabaseis mounted   C、When thedatabaseis opened   D、When thedatabaseis closed  

点击查看答案
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服