网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）
A
Mysqlaccess
B
Mysqldump
C
Mysqlshow
D
Mysqlslow
E
Mysqldumpslow
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）A MysqlaccessB MysqldumpC MysqlshowD MysqlslowE Mysqldumpslow” 相关考题
考题
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?()
A.MysqlaccessB.MysqldumpC.MysqlshowD.MysqlslowE.Mysqldumpslow
考题
When a process is in control, what do you want to do with the process?（）.A.The process should not be adjustedB.The process may be adjusted for continuous improvementC.The process should be always adjusted for continuous qualityD.The process should be regularly adjusted
考题
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. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
考题
which one of the following should cathy use to sort a list?（）A、 @sortB、 @sortlistC、 @datasortD、 @listorder
考题
You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen. Which parameter of the DBVERIFY utility will you use？（）A、 FILEB、 PARFILEC、 LOGFILED、 FEEDBACK
考题
You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB、 Use the ANALYZE utility.C、 Use the DBVERIFY utility.D、 Use the DBMS_REPAIR package.
考题
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）A、MysqlaccessB、MysqldumpC、MysqlshowD、MysqlslowE、Mysqldumpslow
考题
You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）A、Ensure that the source database is Microsoft SQL Server.B、Ensure that the destination database is Microsoft SQL Server.C、Ensure that the column names in the source table match the column names in the destination table.D、Ensure that the bulk copy program (bcp) utility is installed on the destination server.
考题
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. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（） A、You should run the bulk copy program utility along with an output file and no format fileB、You should run the SQLCmd utility and save the output to a fileC、You should run the SQL Import and Export Data Wizard and save the output to a file.D、You should run the bulk copy program utility along with a format file and an output file.
考题
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 is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（） A、You should implement Differential backup B、You should implement Database snapshotsC、You should implement Primary filegroup backup D、You should implement Transaction log backup
考题
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 runs a custom application. Users report that the performance of Server1 has decreased significantly during the last 30 minutes. You need to identify the current processor and memory usage for each process running on Server1. Which tool should you use? （）A、Event ViewerB、Task ManagerC、Query ProcessD、System Configuration Utility
考题
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 is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules. What process should you implement？（） A、You should create a cached data collectionB、You should create an on-demand non-cached data collection C、You should create a scheduled non-cached data collection D、You should create two different SQL Agent jobs that are scheduled stimultaneously
考题
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 is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A、You should create a job which is assigned to the Database Maintenance categoryB、You should create an Alert which will run another to delete the maintenance job.C、You should create a job. You schedule the job to run only once.D、You should create a job. The job uses the Automatically delete job option
考题
You are a desktop administrator for your company. You need to deploy a new application. The application is packaged in an .msi file. The application will be used by only a small number of users. You plan to install the application by using the Msiexec.exe program. You need to ensure that the installation process does not display a user interface. What should you do?（）A、Manually perform a passive installation of the application.B、Manually perform a quiet installation of the application.C、Use a logon script to run the Msiexec.exe program.D、Use the Runas utility to run the Msiexec.exe program.
考题
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance should be managed. It is reported by the customers that the server performance degraded due to a newly implemented process. Dynamic Management Views is utilized to confirm that no long running queries exist. The operating system performance data should be correlated with the actual query execution trace, and the least administrative effort should be utilized. Which action will you perform to finish the task?（）A、To finish the task, Data Collector should be utilized.B、To finish the task, the SQLdiag.exe utility should be utilized.C、To finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.D、To finish the task, SQL Server Profiler and System Monitor should be utilized.
考题
多选题You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）AShell＞ mysqladmin –u root –p shutdownBShell＞ nmc mysql shutdownCMysql＞ STOP PROCESS mysqldDShell＞ /etc/init.d/mysql stopEShell＞ service mysql safe_exitFShell＞ pkill –u mysql mysqld_safeGShell＞ net stop mysql
考题
单选题You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance should be managed. It is reported by the customers that the server performance degraded due to a newly implemented process. Dynamic Management Views is utilized to confirm that no long running queries exist. The operating system performance data should be correlated with the actual query execution trace, and the least administrative effort should be utilized. Which action will you perform to finish the task?（）A
To finish the task, Data Collector should be utilized.B
To finish the task, the SQLdiag.exe utility should be utilized.C
To finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.D
To finish the task, SQL Server Profiler and System Monitor should be utilized.
考题
单选题A technician has fixed a reported issue with a heavily used software program and users have verified that the program is working correctly. Which of the following should the technician do NEXT？（）A
Document the process and update the baseline.B
Test the theory of probable cause and verify with the software vendor.C
Establish a plan of action to be included in the business impact analysis.D
Implement the software manufacturer workaround.
考题
单选题You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen. Which parameter of the DBVERIFY utility will you use？（）A
FILEB
PARFILEC
LOGFILED
FEEDBACK
考题
单选题You use Microsof t Application Virtualization (App - V). You need to automate the process of sequencing applications . Which command should you run?（）A
SFTMIME ADD APP:ApplicationName /OSD PathToOSD /CONSOLEB
SFTMIME configure package: PackageName / OverrideURL FIL E: PathToSFT C
SFTSequencer / I:PathToMSI / P:PathToPackageRoot / O:PathToDestinationSPRJ D
SFTSequencer / UPGRADE: P ath ToS ourceSPRJ / INSTALLPACKAGE: PathT oUpgradeInstaller / DECODEPATH: P ath T o Decode F older / OUTPUTFILE: P a th T o D estinationSPRJ
考题
单选题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 is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（）A
You should implement Differential backup B
You should implement Database snapshotsC
You should implement Primary filegroup backup D
You should implement Transaction log backup
考题
单选题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 is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules. What process should you implement？（）A
You should create a cached data collectionB
You should create an on-demand non-cached data collection C
You should create a scheduled non-cached data collection D
You should create two different SQL Agent jobs that are scheduled stimultaneously
考题
单选题You use Microsoft Application Virtualization (App-V). You need to automate the process of sequencing applications . Which command should you run?（）A
SFTMIME ADD APP:ApplicationName /OSD PathToOSD /CONSOLEB
SFTMIME configure package: PackageName / OverrideURL FILE: PathToSFT C
SFTSequencer / I:PathToMSI / P:PathToPackageRoot / O:PathToDestinationSPRJ D
SFTSequencer / UPGRADE: P ath ToS ourceSPRJ / INSTALLPACKAGE: PathT oUpgradeInstaller / DECODEPATH: P ath T o Decode F older / OUTPUTFILE: P ath T o D estinationSPRJ
考题
单选题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 is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A
You should create a job which is assigned to the Database Maintenance categoryB
You should create an Alert which will run another to delete the maintenance job.C
You should create a job. You schedule the job to run only once.D
You should create a job. The job uses the Automatically delete job option
考题
单选题You need to ensure that when you insert a blank DVD into the DVD drive, Windows Explorer opensautomatically and enables you to select files to burn to DVD. What should you do?（）A
From Default Programs， modify the AutoPlay settings.B
From Default Programs， modify the default program settings.C
From Device Manager， modify the properties of the DVD drive.D
From System Configuration Utility， modify the Startup settings.
考题
单选题You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）A
Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB
Use the ANALYZE utility.C
Use the DBVERIFY utility.D
Use the DBMS_REPAIR package.
考题
单选题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. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）A
You should run the bulk copy program utility along with an output file and no format fileB
You should run the SQLCmd utility and save the output to a fileC
You should run the SQL Import and Export Data Wizard and save the output to a file.D
You should run the bulk copy program utility along with a format file and an output file.
热门标签
最新试卷
