From the V$SESSION_LONGOPS view， you find that some of the database users have longrunning 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？（） set the CPU time per call in the users profile。 set the CPU time per session in the users profiles。 set the CPU levels for the users’ group using Resource Manager。 set the TIMED_STATISTICS parameter to TRUE in the parameter file。
由某企业承建的某多功能现代化商务综合大厦，地上46层，地下3层，基础形式为桩基础，主体为全现浇钢筋混凝土框架一剪力墙结构.主体结构采用泵送混凝土等新技术。建筑物周边都十分接近规划红线，周边建筑及地下管线对因工程基坑开挖引起的地层变形移动十分敏感，且基坑北面临近地铁。在工程施工中发生如下事件：
事件一：该工程地下室基坑开挖深度较大，为确保基坑开挖安全编制了专项施工方案，并由安全总监签字确认后实施。考虑到现场的复杂性，施工单位在施工过程中加强了基坑监测。
事件二：根据施工情况，将混凝土墙体施工缝设置在地下室底板与墙体交接处。
事件三：在进行基础工程桩基验收时，发现部分桩有颈缩现象，个别桩身发生断裂，施工单位及时作了处理，经重新验收全部合格。事件三桩基础经处理后重新验收，给予验收合格的处理是否妥？当发现单位工程验收的内容及质量不符合要求时应如何处理？
You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（） Implement parameterized Transact-SQL queries in the application. 。 Implement Transact-SQL stored procedures in the database. 。 Implement CLR stored procedures in the database. 。 Implement distributed Web services.。
面对企业成长期的主要危机，小企业通常采取的策略有（）。 改革管理体制。 引进人才。 调整企业战略。 全面降低成本。 借鉴泰罗的科学管理方法。
Machine policy templates can be assigned based on certain attributes of a machine. A customer organizes their machines based on the following requirements： The machines are all placed in specific Organizational Units in the Active Directory. The customer has Citrix Servers， and they have a specific naming convention meant only for their Citrix Servers. The customer has DHCP enabled for all the client machines. The customer has made it clear that they should not need to change anything in the existing infrastructure. Given these requirements， which single assignment attribute would be chosen for assigning machine policy templates？（） Hostnames。 IP Addresses。 Machine Group Tag。 Active Directory Grou。
You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）
