单选题You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query: SELECT TABLE_SCHEMA, 'ENGINE', COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= 'BASE TABLE' GROUP BY TABLE_SCHEMA, 'ENGINE' ; Why is this query slow to execute?（）ACollecting information requires large numbers of locks on various INFORMATION_SCHEMA tablesBAggregating details from various storage engine caches for the final output is time consumingCCollecting information requires various disk-level operations and is time consumingDCounting and summarizing all table pages in the InnoDB shared tablespace is time consuming
单选题
You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query: SELECT TABLE_SCHEMA, 'ENGINE', COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= 'BASE TABLE' GROUP BY TABLE_SCHEMA, 'ENGINE' ; Why is this query slow to execute?（）
A
Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables
B
Aggregating details from various storage engine caches for the final output is time consuming
C
Collecting information requires various disk-level operations and is time consuming
D
Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming
参考解析
解析：
暂无解析
相关考题：
"__________ you know what you have to offer and what you want, you can start finding an employer to match." A. Much asB.OnceC. Only whenD. Even if
—() — In most cases, it is the total income received. A. What does taxable income refer to?B. Why do you want to know taxable income?C. When do you start to learn taxable income?
“__________ you know what you have to offer and what you want, you can start finding an employer to match.“ A. Only whenB. OnceC. Even ifD. Much as
（ ）contributes to monitoring and data collection by defining security monitoring and data collection requirements.A.information continuity managementB.information catalogue managementC.information security managementD.information distribution management
You install a SCSI adapter and a SCSI tape drive on your Windows 2000 Professional computer. You start the computer and Windows 2000 Professional detects and installs drivers for the new SCSI devices. Later the same day, you restart your computer. During the startup process, the computer stops loading Windows 2000 Professional. You then restart the computer and it stops again. You want to enable your Windows 2000 Professional computer to start successfully. What should you do?（）A、Start the computer in Safe Mode. Enable driver signing.B、Start the computer in Safe Mode. Use Device Manager to remove the SCSI tape device.C、Start the computer by using the Recovery Console. Repair the Master Boot Record by using the fixmbr command.D、Start the computer by using the Recovery Console. Disable the SCSI adapter device driver by using the disable command.
Your home computer runs Windows 2000 Professional. You have just installed a new application and restarted the computer. During the boot process you receive the following error message： "NTLDR is missing - Press any key to restart." You do not have an emergency repair disk. You want your computer to start properly. You want to do this with the least amount of administrative effort. What should you do？（）A、Reinstall the operating system.B、Start the computer by using the Windows 2000 Professional CD-ROM.C、Select Repair option and choose the option to verify system files.D、Start the recovery console and type Diskpart from the command prompt.E、Start the recovery console and enter Fixmbr from the command prompt.
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.
Which is the correct WebLogic Server distribution version to download if you want to install WebLogic Server 12c to run in 64 bit mode on a 64 bit Linux X86?（）A、Linux x86 with 64 bit JVMB、ZIP distribution for LinuxC、Linux x86 with 32 bit JVMD、Generic distributionE、Network installer
You are the network administrator for Company. Your computer is installed with Windows 2000 Professional. After installing a new application you restart the computer and receive the following error message: "NTLDR is missing - Press any key to restart." You want your computer to start properly. You want to do this with the least amount of administrative effort. What should you do?（）A、Reinstall the operating system.B、Start the computer by using the Windows 2000 Professional CD-ROM.C、Start the recovery Console and select the option to verify system files.D、Insert the Emergency Repair Disk.E、Copy Ntdetect.com from the /i386 folder on the CD-ROM to the root folder on the boot partition.
You are a network administrator for ExamSheet.net’s Windows 2000 network. Your computer has Windows 2000 Professional installed. Your office has a power utage while you are running the Windows 2000 disk defragmenter. When you restart your computer， you receive the following error message： "Bad or missing operating system". You want your computer to start properly. You want to do this with least amount of administrative effort. What should you do？（）A、Reinstall the operating systemB、Start the computer by using the Windows 2000 Professional CD-ROM.C、Use the Recovery Console to repair the Master Boot Record.D、Use the Emergency Repair Disk to repair the Master Boot Record.
You are a network administrator of your network. You want to install Windows 2000 professional on 100 computers from a central location. You want to copy a customized application with theinstallation process to all the 100 computers. What should you do to copy that application during the installation process to the computers.（）A、 It cannot be done.B、 Copy the application to the temp folder of the distribution server.C、 Create a folder named $OEM$ as a sub folder in the distribution folder of source files.D、 Create a folder named $COPYDIR$ as a sub folder in the distribution folder of source files.
You use Windows 2000 Professional on your desktop Computer. You schedule a task to run an MMC snap-in to perform configuration tasks on other computers. You notice that the task is not completing correctly. You manually start MMC. You add the snap-in. You are then able to successfully run the task. You verify that all of your other tasks are working correctly. You want to enable your tasks to complete successfully. What should you do？（）A、Use Scheduled Tasks to configure the task to run under the security context of your account.B、Configure the Task Scheduler service account to use a local Administrator account and password.C、Use Computer Management to start the Messenger service and to configure the Messenger service to start automatically. D、Use Computer Management to start the Task Scheduler service and to configure the Task Scheduler service to start automatically.
You are the network administrator for ExamSheet.net. Your computer has Windows 2000 Professional installed. You install an upgraded driver for your video card. When you restart the computer you receive the following message: **** Stop: 0x000000B4 - The video driver failed to initialize." The computer will not start in safe mode. You want your computer to start properly. What should you do?（）A、Start theRepairoption and select the option to locate and repair system files.B、Start the computer by enabling VGA mode.C、Use the Recovery Console and repair the Master Boot Record.D、Restart the computer in debug mode.
Your company has an Active Directory Domain Services （AD DS） domain that includes an AD security group named Monitoring. You are configuring a Windows Server 2008 R2 Hyper-V server that hosts several virtual machines （VMs）. You need to ensure that members of the Monitoring group can only stop and start VMs on the host server. What should you do？（）A、Add the Monitoring group to the Server Operators AD security group.B、In Authorization Manager， add the Monitoring group to the Administrator role in the default scope.C、In Authorization Manager， create a task that includes the Stop Virtual Machine and Start Virtual Machine operations. Add the task to the Administrator role.D、In Authorization Manager， create a role in the default scope. Add the Stop Virtual Machine and Start Virtual Machine operations to the role. Assign the Monitoring group to the role.
多选题You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）Ause enterprise managerBuse DBMS_SQL packageCuse DBMS_AWR packageDuse PRVT_WORKLOAD packageEquery the AWR snapshot repository objectsFuse DBMS_WORKLOAD_REPOSITORY package
单选题You work as a database administrator for Certkiller .com. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）AIt would attempt to start the default listenerBIt would start the most recently created listener.CIt would display an error with a message asking for the listener name to be specified.DIt would show you a list of listeners and prompts for the listener name that you want to start.
单选题Which is the correct WebLogic Server distribution version to download if you want to install WebLogic Server 12c to run in 64 bit mode on a 64 bit Linux X86?（）ALinux x86 with 64 bit JVMBZIP distribution for LinuxCLinux x86 with 32 bit JVMDGeneric distributionENetwork installer
单选题Your IT manager has requested that you start providing weekly reports of CPU utilization on all network devices.Which monitoring function should be enabled on the MAG Series device?（）AAdmin loggingBSNMP loggingCSyslog server loggingDEvent logging
单选题You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query: SELECT TABLE_SCHEMA, 'ENGINE', COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= 'BASE TABLE' GROUP BY TABLE_SCHEMA, 'ENGINE' ; Why is this query slow to execute?（）ACollecting information requires large numbers of locks on various INFORMATION_SCHEMA tablesBAggregating details from various storage engine caches for the final output is time consumingCCollecting information requires various disk-level operations and is time consumingDCounting and summarizing all table pages in the InnoDB shared tablespace is time consuming
填空题If he farmer and the dog wait for you and start attacking you, you will probably want to try another different direction.____
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）A the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewB the column of the V$INSTANCE_RECOVERY viewC the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewD the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
单选题You are a network administrator of your network. You want to install Windows 2000 professional on 100 computers from a central location. You want to copy a customized application with theinstallation process to all the 100 computers. What should you do to copy that application during the installation process to the computers.（）A It cannot be done.B Copy the application to the temp folder of the distribution server.C Create a folder named $OEM$ as a sub folder in the distribution folder of source files.D Create a folder named $COPYDIR$ as a sub folder in the distribution folder of source files.
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）A Oracle Enterprise ManagerB The V$LOG viewC The V$LOGFILE viewD The V$FLASHBACK_DATABASE_LOGS view
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）Aenable index monitoring and query the DBA_OBJECTS viewBenable index monitoring and query the DBA_INDEXES viewCenable index monitoring and query the V$OBJECT_USAGE viewDenable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
单选题You work as an application developer at Certkiller .com. You have created a Windows service application for the purpose of monitoring the number of active service requests running on Certkiller .com’s server. You want to configure this Windows service application to produce a report every ten minutes. You start by placing the reporting logic in the GenerateReport method of this Windows service.You want to create a Timer object that invokes this method every ten minutes.What should you do？ （）A AB BC CD D
单选题—Tony, ______ are you in such a hurry?—The meeting will start soon. I don’t want to be late.AwhereBhowCwhenDwhy
单选题You are the network administrator and need to install Windows 2000 Professional on 35 computers. You need to install the recovery console the installations. You create a distribution folder on a server and copy Windows 2000 Professional Support folder to the distribution folder. You create a network boot floppy to install W2k Pro from the distribution folder. You need to make a batch file, which the network boot floppy will use to start the installation. Which command would you include in the batch file: （）AWinnt32 /cmd： z：/i386/winnt /aBWinnt32 /cmd： z：/support/tools/setup.exeCWinnt /e： z：/i386/winnt32 /cmdconsDWinnt /e： z：/support/tools/setup.exe
多选题You want to remove the logoff option from your start menu. Which of the following options will allow you to enforce this setting？ （）ALocal PolicyBGroup PolicyCRoaming ProfileDFrom the Display Applet in Control PanelEFrom the accessibility applet in Control PanelFOn the Advanced tab of the Taskbar/Start Menu dialog box， clear the Display logoff option.