单选题

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file()

ATake the USERS tablespace offline and re-create the lost data file.

BShut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.

CShut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.

DTake the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online

正确答案

来源:www.examk.com

答案解析

相似试题
  • Your database is not configured for session failover. Your tnsnames.ora file contains the following details:  test.us.oracle.com= (DESCRIPTION=  (ADDRESS_LIST= (LOAD_BALANCE=off)   (FAILOVER=ON)   (ADDRESS= (PROTOCOL=tcp)(HOST=test1-server)(PORT=1521))   (ADDRESS= (PROTOCOL=tcp)(HOST=test2-server)(PORT=1521)))   (CONNECT_DATA= (SERVICE_NAME=test.us.oracle.com)))   Which feature is enabled in this case?()

    单选题查看答案

  • Given: 11.String test = "Test A. Test B. Test C."; 12.// insert code here 13.String[] result = test.split(regex); Which regular expression, inserted at line 12,correctly splits test into "Test A","Test B",and "Test C"?()

    单选题查看答案

  • A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()

    单选题查看答案

  • You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  

    单选题查看答案

  • You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?()

    单选题查看答案

  • The following are the details of your database:Instance name:test  Host name : tech1.us.oracle.com IP address:145.33.230.186 Enterprise Manager Console HTTP Port number:5500  You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser.  Which two URLs would you use to access the Database Control?()

    多选题查看答案

  • In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What isthe impact of this setting()

    单选题查看答案

  • in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting()

    单选题查看答案

  • You issued the following statement in your SQL*Plus session:   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()

    单选题查看答案

  • Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace. Which option is open to you?()

    单选题查看答案