搜题

【单项选择题】

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题

[单选题] You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

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题

[单选题] You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

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题

[单选题] Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: Which statement is true about the duplicate database in this scenario?（）

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题

[多选题] You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

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题

[单选题] Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

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题

点击查看答案

第7题

[多选题] In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）

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题

[单选题] When learning a new route, if a LSA received is not found in the topological database, what will an internal OSPF router do?（）

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题

[多选题] Examine the following command that is used to duplicate a database on the same host: Which two statements describe the effect after the database is duplicated successfully? （）

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题

[单选题] You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

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

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

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