You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）A、set SQL_TRACE=True B、set UNDO_RETENTION=14400 C、set FAST_START_MTTR_TARGET=240 D、set LOG_CHECKPOINT_INTERVAL=240 E、set DB_FLASHBACK_RETENTION_TARGET=14400 F、set the RETENTION GUARANTEE clause for the undo tablespace
You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）
- A、set SQL_TRACE=True
- B、set UNDO_RETENTION=14400
- C、set FAST_START_MTTR_TARGET=240
- D、set LOG_CHECKPOINT_INTERVAL=240
- E、set DB_FLASHBACK_RETENTION_TARGET=14400
- F、set the RETENTION GUARANTEE clause for the undo tablespace
相关考题：
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
You have an Exchange Server 2010 organization that contains 20 mailbox databases. You configure each database to retain all deleted items for 30 days.You need to ensure that all items that pass the retention period are permanently deleted daily between 02：00 and 06：00. Which cmdlet should you use？（）A、Set-MailboxDatabaseB、Set-MailboxServerC、Set-OrganizationConfigD、Set-RetentionPolicy
You plan to use Windows PowerShell scripts to configure system settings when you deploy Windows 7. You need to ensure that Windows PowerShell scripts will run on the client computers during initial setup. What should you do？（）A、Set the script execution policy to RemoteSigned.B、Set the script execution policy to AllSigned.C、Set the script execution policy to Restricted.D、Use Group Policy preferences.
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）A、Execute the query and view Active Session History (ASH) for information about the query.B、Enable SQL trace for the query.C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A、 Set the CPU time per call in the users profile.B、 Set the CPU time per session in the users profile.C、 Set the CPU levels for the user’s group using Resource Manager.D、 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）A、3 hoursB、6 monthsC、until last yearD、until last commitE、until the point when the undotablespacewas refreshedF、until the database is shut down and the memory erased
From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective？（）A、create a plan directive in the SYS_GROUPB、create the pending area for the consumer groupC、activate the provided SYSTEM_PLAN in Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter fileE、set the execution time limit for all users， except SYS and SYSTEM， in their profiles
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A、set the CPU time per call in the users profileB、set the CPU time per session in the users profilesC、set the CPU levels for the users’ group using Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter file
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）A、Use the Database Resource Manager.B、Set the limits in the profiles used by users.C、Modify the SESSIONS initialization parameter.D、Set the warning threshold for the Current Logons Count metric.
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）A、set DB_FLASHBACK_RETENTION_TARGET=10800 B、create a new scheduler window for the time period of 24 hours and use the optimizer statistics C、modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings D、specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
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. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?（）A、You should set query governor cost limitB、You should set cost threshold for parallelismC、You should set priority boost D、You should set precompute rank
You have a DHCP server that runs windows server 2008. You restore the DHCP database by using a recent backup. You need to prevent DHCP clients from receiveing IP addresses that are currently in use on the network. What should you do?（）A、Add the DHCP serve option 44.B、Set the conflict detetion value to 0.C、Set the conflict detection value to 2.
You create a Web Form that contains a button named btnCancel that enables users to exit the page. When users click this button, validation must not occur. During testing you learn that clicking the Cancel button does not enable users to exit the page. You need to ensure that users can always exit the page. What should you do?（）A、Set the Enabled property of the validation controls on the Web Form to False.B、Set the CausesValidation property of the btnCancel button to False.C、Set the CausesValidation property of the btnCancel button to True.D、Set the Visible property of the validation controls on the Web Form to False.
You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）A、Replace the named query with an SQL view.B、Set the transaction isolation level to serializable in the named query.C、Set the source database to use snapshot isolation.D、Set the transaction isolation level to repeatable read in the named query.
You are debugging a Windows Communication Foundation (WCF) service. The service uses signed and encrypted messages.You need to configure logging so that you can read the contents of the messages. What should you do?（）A、Set maxSizeMessagesToLog to 10B、Set logMessageAtServiceLevel to true.C、Set maxMessagesToLog to 10.D、Set logMessageAtTransportLevel to true.
Your company has an existing Windows Communication Foundation (WCF) service that allows business partners to place orders. The service uses netMsmqBinding. You find that processing every order in its own transaction is causing a delay. You need to ensure that the service is configured to process multiple orders in one transaction. What should you do? （）A、Use service behavior and set the maxConcurrentCalls attribute.B、Use endpoint behavior and set the maxBatchSize attribute.C、Use endpoint behavior and set the maxPendingReceives attribute.D、Use endpoint behavior.
Your network contains a Windows Server 2008 server that has the Web Server （IIS） server role installed. You have a Web application that uses a custom application pool. The application pool is set to recycle every 1，440 minutes. The Web application does not support multiple worker processes. You need to configure the application pool to ensure that users can access the Web application after the application pool is recycled. What should you do？（）A、Set the Shutdown Executable option to True.B、Set the Process Orphaning Enabled option to True.C、Set the Disable Overlapped Recycling option to True.D、Set the Disable Recycling for Configuration Changes option to True.
You are developing a user control for Windows Presentation Foundation (WPF) application. The user control contains a button. Both the user control and the hosting control must receive the button click event. You need to ensure that the user control responsd to the button click event before hosting control responds to the event. What should you do ?（）A、Use a bubbling routed event. In the button click event handler, set the Handled property to TrueB、Use a bubbling routed event. In the button click event handler, set the Handled property to FalseC、Use a standard Microsoft .NET event. Set Handled property to true.D、Use a tunneling routed event. Set the handled property to false.
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.
Your organization has Exchange Server 2010.You need to ensure that users in the organization are notified before they send e-mail messages to external recipients. Which cmdlet should you run？（）A、set-MailboxB、set-OrganizationConfigC、set-TransportAgentD、set-TransportConfig
You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication. You decide to make use of Microsoft ASP.NET 3.5 in order to create the application. The followingmarkup is present on the page： " ="" selectcommand="GetUsers" selectcommandtype="StoredProcedure" filterexpression="Active=1 AND Name LIKE ’{0}%’"> The page is used to retrieve the Users from a company database. However， only the active usersare displayed. The TextBox control allows you to also filter users by status. You do not specify astatus when you click the Filter button. You notice that the page does not filter by active users andshows all the users that are retrieved from the database. You need to make the necessary settingsto ensure that only the active users are being displayed on the page when a status is notspecified. What should you do？（）A、You should ensure that a default value for the Status property of the ControlParameter controlis set.B、You should ensure that the PropertyName property of the ControlParameter control is set toText.C、You should ensure that the ControlParameter control’s ConvertEmptyStringToNull property isset to false.D、You should ensure that the {0} placeholder in the FilterExpression property is replaced with the（？） symbol.
单选题A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）AExecute the query and view Active Session History (ASH) for information about the query.BEnable SQL trace for the query.CCreate a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.DUse the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
单选题The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）Aset DB_FLASHBACK_RETENTION_TARGET=10800 Bcreate a new scheduler window for the time period of 24 hours and use the optimizer statistics Cmodify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings Dspecify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
多选题You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）Aset SQL_TRACE=TrueBset UNDO_RETENTION=14400Cset FAST_START_MTTR_TARGET=240Dset LOG_CHECKPOINT_INTERVAL=240Eset DB_FLASHBACK_RETENTION_TARGET=14400Fset the RETENTION GUARANTEE clause for the undo tablespace
单选题You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication. You decide to make use of Microsoft ASP.NET 3.5 in order to create the application. The followingmarkup is present on the page： " SelectCommand="GetUsers" SelectCommandType="StoredProcedure" FilterExpression="Active=1 AND Name LIKE ’{0}%’" The page is used to retrieve the Users from a company database. However， only the active usersare displayed. The TextBox control allows you to also filter users by status. You do not specify astatus when you click the Filter button. You notice that the page does not filter by active users andshows all the users that are retrieved from the database. You need to make the necessary settingsto ensure that only the active users are being displayed on the page when a status is notspecified. What should you do？（）AYou should ensure that a default value for the Status property of the ControlParameter controlis set.BYou should ensure that the PropertyName property of the ControlParameter control is set toText.CYou should ensure that the ControlParameter control’s ConvertEmptyStringToNull property isset to false.DYou should ensure that the {0} placeholder in the FilterExpression property is replaced with the（？） symbol.