You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }

相似题目

• When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

  A . Until SCN B . Until time C . Until cancel D . Recover using backup control file.

  查看最佳答案

• You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）

  A .  Use SQL Server Profiler to identify missing indexes. B .  Use the Database Engine Tuning Advisor to identify missing indexes. C .  Use a Dynamic Management View to analyze query plans. D .  Use a DynamicManagement View to ascertain the number of pending I/O requests.

  查看最佳答案

• You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）

  A .  MOUNT mode B .  RESTRICTED mode C .  OPEN mode D .  NOMOUNT mode

  查看最佳答案

• You are implementing an ASP. NET MVC 2 Web application. You add a controller named Company Controller. You need to modify the application to handle the URL path /company/info. Which two actions should you perform？（）

  A . Add the following method to the CompanyController class. Function Info（） As ActionResult   Return View（） End Function B . Add the following method to the CompanyController class. Function Company_Info（） As ActionResult  Return View（） End Function C . Right-click the Views folder， and select View from the Add submenu to create the view for the action. D . Right-click inside the action method in the CompanyController class， and select Add View to create a view for the actio

  查看最佳答案

• You are preparing to install an operating system on virtual machines （VMs） in a Hyper-V environment. You need to configure each VM so that you can perform a network-based operating system installation. What should you do for each VM？（）

  A . Add a Network Adapter. B . Add a Legacy Network Adapter. C . Configure a static MAC address. D . Configure a dynamic MAC address.

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）

  A .  This operation resets the SCN for the database. B .  This operation creates a new incarnation of the database. C .  This operation moves all the redo log files to a different location. D .  This operation deletes the old redo log files and creates new redo log files. E .  This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

  A .  The target database must be in the MOUNT mode to ensure restoration of the datafiles. B .  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility. C .  The control file must be recreated. D .  The database must be opened with the RESETLOGS option.

  查看最佳答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）

  A .  SYSDATE should not be used with TIMESTAMP. B .  The database must have multiplexed redo log files. C .  The database must be in the MOUNT state to execute the command. D .  The database must be opened with the RESETLOGS option after the flashback operation. E .  The entire database needs to be restored from the most recent backup before the flashback operation.

  查看最佳答案

• You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）

  A . The index remains invisible. B . The index is not updated by the DML statements on the indexed table. C . The index automatically becomes visible in order to have it updated by DML on the table. D . The index becomes unusable but the table is updated by the DML. E . The index is updated by the DML on the table.

  查看最佳答案

• Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

  A .  open the database with the RESTRICTED option B .  open the database with the RESETLOGS option C .  recover to the required SCN only that data file in which the error occurred D .  recover all the data files to the same system change number （SCN）

  查看最佳答案

• You are developing a WCF service. The service includes an operation names GetProduct. You need to ensure that GetProduct will accept a POST request and will indicate that the returned data is XML.   Which two actions should you perform?（）

  A . Add the WebGet attribute to the service contract. B . Set WebOperationContext.Current.OutgoingRequest.ContentType to "text/xml" in the GetProduct method. C . Add the WebInvoke attribute to the service contract. D . Set WebOperationContext.Current.OutgoingResponse.ContentType to "text/xml" in the GetProduct method.

  查看最佳答案

• 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.

  查看最佳答案

• Your company has an Active Directory forest that contains client computers that run Windows Vista  and Windows XP.   You need to ensure that users are able to install approved application updates on their computers.  Which two actions should you perform（）

  A . Set up Automatic Updates through Control Panel on the client computers. B . Create a GPO and link it to the Domain Controllers organizational unit. Configure the GPO to  automatically search for updates on the Microsoft Update site. C . Create a GPO and link it to the domain. Configure the GPO to direct the client computers to the  Windows Server Update Services （WSUS） server for approved updates. D . Install the Windows Server Update Services （WSUS）. Configure the server to search for new updates  on the Internet. Approve all required updates.

  查看最佳答案

• You are troubleshooting an OSPF problem where external routes are not showing up in the OSPF database. Which two options a re valid checks that should be performed first to verify proper OSPF operation?（）

  A . Are the ASBRs trying to redistribute the external routes into a totally stubby area? B . Are the ABRs configured with stubby areas? C . Is the subnets keyword being used with the redistribution command? D . Is backbone area (area 0) contiguous? E . Is the CPU utilization of the routers high?

  查看最佳答案

• You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

  A . The backups would be consistent. B . The backups would be inconsistent. C . The backups would be possible only if the database is running in ARCHIVELOG mode. D . The backups would be possible only if the database is running in NOARCHIVELOG mode. E . The backups need to be restored and the database has to be recovered in case of a media failure

  查看最佳答案

• You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

  查看最佳答案

• The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  

  A .  The block change tracking feature must be enabled. B .  OMF must be configured on your database. C .  The database must be in ARCHIVELOG mode. D .  A USERID must be supplied.

  查看最佳答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

  A . SYSDATE should not be used with TIMESTAMP. B . The database must have multiplexed redo log files. C . The database must be in the MOUNT state to execute the command. D . The database must be opened with the RESETLOGS option after the flashback operation. E . The entire database needs to be restored from the most recent backup before the flashback operation.

  查看最佳答案

• You are developing an ASP.NET application by using Visual Studio 2010. You need to interactively debug the entire application. Which two actions should you perform？ （）

  A . Set the Debug attribute of the compilation node of the web.config file to true. B . Add a DebuggerDisplay attribute to the code-behind file of the page that you want to debug. C . Select the ASP.NET debugger option in the project properties. D . Define the DEBUG constant in the project settings.

  查看最佳答案

• Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process？ （）

  A . open the database with the RESETLOGS option B . open the database with the RESTRICTED option C . recover all the data files to the same system change number （SCN） D . recover to the required SCN only that data file in which the error occurred

  查看最佳答案

• You are developing an application that will perform mathematical calculations.You need to ensure that the application is able to perform multiple calculations simultaneously. What should you do？（）

  A . Set the IdealProcessor property of the ProcessThread object. B . Set the ProcessorAffinity property of the ProcessThread object. C . For each calculation， call the QueueUserWorkItem method of the ThreadPool class. D . Set the Process.GetCurrentProcess（）.BasePriority property to High.

  查看最佳答案

• You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

  A .  UNTIL CANCEL B .  UNTIL SCN C .  UNTIL SEQUENCE D .  UNTIL TIME

  查看最佳答案