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_TARG

第1题：

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.

第2题：

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 hours
• B、6 months
• C、until last year
• D、until last commit
• E、until the point when the undotablespacewas refreshed
• F、until the database is shut down and the memory erased

第3题：

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 performed
• B、the time when the first flashback operation in your database was performed
• C、a list of flashback operations performed in your database using SCN and time
• D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

第4题：

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.

第5题：

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 limit
• B、You should set cost threshold for parallelism
• C、You should set priority boost 
• D、You should set precompute rank

第6题：

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.

第7题：

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 10
• B、Set logMessageAtServiceLevel to true.
• C、Set maxMessagesToLog to 10.
• D、Set logMessageAtTransportLevel to true.

第8题：

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.

第9题：

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.

第10题：

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

第11题：

第12题：

第13题：

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 more
• D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
• E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

第14题：

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_GROUP
• B、create the pending area for the consumer group
• C、activate the provided SYSTEM_PLAN in Resource Manager
• D、set the TIMED_STATISTICS parameter to TRUE in the parameter file
• E、set the execution time limit for all users， except SYS and SYSTEM， in their profiles

第15题：

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 profile
• B、set the CPU time per session in the users profiles
• C、set the CPU levels for the users’ group using Resource Manager
• D、set the TIMED_STATISTICS parameter to TRUE in the parameter file

第16题：

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

第17题：

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.

第18题：

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.

第19题：

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.

第20题：

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 True
• B、 Use a bubbling routed event. In the button click event handler, set the Handled property to False
• C、 Use a standard Microsoft .NET event. Set Handled property to true.
• D、 Use a tunneling routed event. Set the handled property to false.

第21题：

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-Mailbox
• B、set-OrganizationConfig
• C、set-TransportAgent
• D、set-TransportConfig

第22题：

第23题：