搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals whil

A、You should use Dynamic Management Views 

B、You should use SQL Server Resource Governor 

C、You should use SQL Server Profiler 

D、You should use Windows System Monitor

查看正确答案
更多“ 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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals whil”相关的问题
第1题
[多选题] 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.  H、You are working on a database where control files and redo log files are not multiplexed.  

点击查看答案
第2题
[] You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this？（） You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this？（）

A、A.A  B、B.B  C、C.C  D、D.D  

点击查看答案
第3题
[单选题] You have a portable computer that runs Windows XP Professional. When the computer is disconnected from the network, you receive a message in the notification area that says you are working offline. The message reappears every hour. You need to prevent the message from appearing while you are working offline. What should you modify?（） 

A、Disk Quota settings  B、My Documents properties  C、Offline Files properties  D、Synchronization settings  

点击查看答案
第4题
[] You work as an application developer at Certkiller .com. You are required to retrieve and display the names of all processes that are currently running in memory. What should you do？（） You work as an application developer at Certkiller .com. You are required to retrieve and display the names of all processes that are currently running in memory. What should you do？（）

A、A.A  B、B.B  C、C.C  D、D.D  

点击查看答案
第5题
[] You are the DNS administrator for Adventure Works. Adventure Works is an Internet service provider （ISP） that hosts Web sites for many companies.  Each Adventure Works DNS server hosts multiple DNS zones for customers. Several Adventure Works administrators are allowed to add DNS zones. You want to produce a weekly report that will list all the zones that are hosted on each DNS server.  What should you do？（） You are the DNS administrator for Adventure Works. Adventure Works is an Internet service provider （ISP） that hosts Web sites for man

A、A.Use the dnslint utility to query each DNS server.  B、B.Use the dnscmd utility to query each DNS server.  C、C.Use the nslookup utility to query each DNS server.  D、D.Use the adsiedit utility to query Active Directory for a list of DNS zones.  

点击查看答案
第6题
[] You are the DNS administrator for Adventure Works.Adventure Works is an Internet service provider （ISP） that hosts Web sites for many companies.  Each Adventure Works DNS server hosts multiple DNS zones for customers. Several Adventure Works administrators are allowed to add DNS zones.You want to produce a weekly report that will list all the zones that are hosted on each DNS server. What should you do？（） You are the DNS administrator for Adventure Works.Adventure Works is an Internet service provider （ISP） that hosts Web sites for many companies. 

A、A.Use the dnslint utility to query each DNS server.  B、B.Use the dnscmd utility to query each DNS server.  C、C.Use the nslookup utility to query each DNS server.  D、D.Use the adsiedit utility to query Active Directory for a list of DNS zones.  

点击查看答案
第7题
[] 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. Now you get an order from your company CIO， you have to identify whether a database integrity check （DBCC CHECKDB） was run for a particular database.  Which log file should you examine？（） 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. Now you get an order from

A、A.log.trc   B、B.default.trc   C、C.ERRORLOG   D、D.SQLAGENT  

点击查看答案
第8题
[简答题] You are configuring your computer to use both Windows 2000 Professional and Windows 98. Yourcomputer has three 8 GB hard disks: Disk 0, Disk 1, and Disk 2. You want to configure each hard disk to have an 8 GB partition. You want to install Windows 98 on Disk 0 and Windows 2000 Professional on Disk 1. You want to store your work files on Disk 2. You want to implement file level security on Disk 1.  You want to be able to access your work file when using either operating system. What should you do?  To&e

点击查看答案
第9题
[] You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces， and dropped a couple of tablespaces. This morning， due to hardware failure， you lost all your control files.  How would you recover the database from this situation？（） You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces， and dropped a couple&ens

A、A.A  B、B.B  C、C.C  D、D.D  E、E.E  

点击查看答案
第10题
[] Your portable computer is in sleep mode. When you resume work on the portable computer， you are not prompted for a password.  You need to ensure that you are prompted for a password each time the portable computer recovers from sleep mode.  What should you do？（） Your portable computer is in sleep mode. When you resume work on the portable computer， you are not prompted for a password.  You need to ensure that you are prompted for a password each time the portable computer recovers from sleep mode.  What should you do？

A、A.Configure the computer to hibernate when not in use.  B、B.In the current power plan settings， configure the computer to require a password when recovering from sleep mode.  C、C.Configure the computer to use the High Performance power plan.  D、D.Configure the screen saver settings to require a password on resumption of work.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服