单选题You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1）Shut down the instance. 2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3）Execute the ALTER DATABASE FLASHBACK OFF command. 4）Start up the instance and mount the database. 5）Execute the ALTER DATABASE FLASHBACKON command. 6）Open the database. Select the correct order in which these tasks need to be performed. （）A2，1，4，3，5，6B1，4，3，2，6，5C1，4，2，6，3，5D3，2，1，4，5，6
单选题
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1）Shut down the instance. 2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3）Execute the ALTER DATABASE FLASHBACK OFF command. 4）Start up the instance and mount the database. 5）Execute the ALTER DATABASE FLASHBACKON command. 6）Open the database. Select the correct order in which these tasks need to be performed. （）
A
2，1，4，3，5，6
B
1，4，3，2，6，5
C
1，4，2，6，3，5
D
3，2，1，4，5，6
参考解析
解析：
暂无解析
相关考题：
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）A、to enable the ASM instance to identify the alert log fileB、to enable the ASM instance to identify the server parameter fileC、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）A、You can perform consistent backups only.B、You can perform a complete database backup without shutting down the database instance.C、You can back up data files only when all data files have the same SCN recorded in the control file.D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
In which two cases would you perform only consistent backup？（）A、You are working on a database where downtime is not tolerated.B、You are working on a database where downtime can be tolerated.C、You are working on a database that operates in ARCHIVELOG mode.D、You are working on a database that operates in NOARCHIVELOG mode.E、You are working on a database where all the tablespaces are locally managed.F、You are working on a database where control files and redo log files are multiplexed.G、You are working on a database where control files and redo log files are not multiplexed.
You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B、 Before the instance starts， you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）A、Shut down the instance， copy the control file to the third location and open the database.B、Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.C、Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.D、Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.E、Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.
You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You must make sure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. Besides this, you must make sure that the password complexity rules continue to be enforced. So what action should you perform to achieve this goal?（） A、You should create an SQL Server Agent job. If a rule violation is detected, the job runs periodically to raise an alert B、You should modify all logins by using the ALTER LOGIN ... HASHED statement. C、You should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON statement to. D、You should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement. E、You should create a policy by using Policy-Based Management. The policy prevents any violation of these rules
You are developing an application that receives events asynchronously.You create a WqlEventQuery instance to specify the events and event conditions to which the application must respond.You also create a ManagementEventWatcher instance to subscribe to events matching the query.You need to identify the other actions you must perform before the application can receive events asynchronously.Which two actions should you perform？（）A、Start listening for events by calling the Start method of the ManagementEventWatcher.B、Set up a listener for events by using the EventArrived event of the ManagementEventWatcher.C、Use the WaitForNextEvent method of the ManagementEventWatcher to wait for the events.D、Create an event handler class that has a method that receives an ObjectReadyEventArgs parameter.E、Set up a listener for events by using the Stopped event of the ManagementEventWatcher.
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. So what action should you perform to achieve this goal？（）A、You should recapture the workload by using the data collector.B、You should enable the XP_MSVER stored procedure on the local server.C、You should enable the XP_MSVER stored procedure on the remote serverD、You should recapture the workload to a trace file by using SQL Profiler.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. B、You should identify whether the SQL Server Agent is started on the primary server. C、You should identify whether the AdventureWorks database uses the Simple recovery model. D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
Your network contains a server named Server1 that runs Windows Server 2008 R2. On Server1， you create an Active Directory Lightweight Directory Services （AD LDS） instance named Instance1. You connect to Instance1 by using ADSI Edit. You run the Create Object wizard and you discover that there is no User object class. You need to ensure that you can create user objects in Instance1. What should you do（）A、Run the AD LDS Setup Wizard.B、Modify the schema of Instance1.C、Modify the properties of the Instance1 service.D、Install the Remote Server Administration Tools （RSAT）.
ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
单选题You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）A2，1，4，3，5，6B1，4，3，2，6，5C1，4，2，6，3，5D3，2，1，4，5，6
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （）AYou should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. BYou should identify whether the SQL Server Agent is started on the primary server. CYou should identify whether the AdventureWorks database uses the Simple recovery model. DYou should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）AWhen you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.BWhen a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.CWhen a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.DWhen you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
单选题Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）AOracle Net ManagerBListener Control utilityCDatabase Configuration AssistantDOracle Net Configuration Assistant
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）AYou should install SQL Server 2008 as a named instance, and make the new application to use the new instance. BYou should install SQL Server 2008 as the default instance, and make the new application to use the default instance. CYou should upgrade the SQL Server 2005 application to use SQL Server 2008. DYou should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. So what action should you perform to achieve this goal？（）AYou should recapture the workload by using the data collector.BYou should enable the XP_MSVER stored procedure on the local server.CYou should enable the XP_MSVER stored procedure on the remote serverDYou should recapture the workload to a trace file by using SQL Profiler.
单选题You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）AYou must have started the database instance in restricted mode.BYou must have started the database instance inNORMALmode.CYou must have started the database instance with server parameter file.DYou must have started the database instance but must not have mounted.EYou must have started the database instance but must not have opened.
单选题You create an application. The application processes hundreds of XML documents per minute. The XML documents are validated against inline schemas. You need to load XML documents from the file system and read them as quickly as possible. XML comments must be ignored while reading the XML documents.What should you do? （）ACreate an instance of the XmlReader class by using the XmlReader Create method with an instance of the XmlReaderSettings class.BCreate an instance of the XmlReader class with an instance of the XmlTextReader class.CCreate an instance of the XmlDocument class and specify a location for the application schema.DCreate an instance of the XmlReader class with an instance of the XmlNodeReader class.
单选题You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）AStart the instance and open the database， instance recovery automatically recoverscontrol filesBCreate a file based on the contents of the trace file and save it to the control file locations and start the databaseCRe-create the database （The recovery of the control file is not possible because you have lost all the control files.）DStart the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.EStart the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单选题You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）AShut down the instance， copy the control file to the third location and open the database.BAbort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.CCopy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.DShut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.EShut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.
单选题You are making a telephone call ship-to-shore using the VHF-FM service.You can tell that the working channel is busy if you hear（）.ASpeechBSignaling tonesCA busy signalDAll of the above