单选题Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）AMysqlaccessBMysqldumpCMysqlshowDMysqlslowEMysqldumpslow
单选题
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
参考解析
解析：
暂无解析
相关考题：
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter
A general purpose MySQL instance is configured with the following options:—log-slow-queries—long-query-time=,0001—log-slow-admin-queries—general-log—log-bin—binlog-format=STATEMENT—innodb-flush-log-at-trx-commit=1Which three statements are true（）。A.The General Query Log records more data than the Binary LogB.The binary Log records more data than the General Query LogC.The Slow Query Log records more data than the General Query LogD.The General Query Log records more data than the Slow Query LogE.The Slow Query Log records more data than the Binary LogF.The Binary Log records more data than the Slow Query Log
Which statement is true about the log－output variable?() A.It is a static variable and can be set only at MySQL server startupB.It enables and starts the General Query LogC.It sets the target location for the binary logs generated by the MySQL severD.It specifies output destinations for the slow and General Query logs
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
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
关于mysql_db_query与mysql_query说法正确的是：（）A、mysql_db_query与mysql_query在执行sql语句后的返回值是一样的，成功返回资源号，失败返回FALSEB、不能用mysql_query函数临时在另一个数据库上执行sql语句，而mysql_db_query可以C、mysql_db_query不会切换回先前连接到的数据库D、mysql_query在功能上等于mysql_select_db（）+mysql_db_query（）
Which of the following statements best describes Flashback Versions Query？（） A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B、 Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D、 Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true（）。A、The General Query Log records more data than the Binary LogB、The binary Log records more data than the General Query LogC、The Slow Query Log records more data than the General Query LogD、The General Query Log records more data than the Slow Query LogE、The Slow Query Log records more data than the Binary LogF、The Binary Log records more data than the Slow Query Log
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）A、Execute the query and view Active Session History (ASH) for information about the query.B、Enable SQL trace for the query.C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
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 tablesB、Aggregating details from various storage engine caches for the final output is time consumingC、Collecting information requires various disk-level operations and is time consumingD、Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A、Check the alert log fileB、Query the V$FLASHBACK_DATABASE_LOG viewC、Query the V$RECOVERY_FILE_DEST_SIZE viewD、Query the V$FLASHBACK_DATABASE_STAT viewE、Check the value assigned for the UNDO_RETENTION parameter
You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE （PLAN = ’SALES_PLAN’， GROUP_OR_SUBPLAN = ’MANAGERS’， CPU_P1 = 100， CPU_P2 =0， SWITCH_GROUP = ’CLERKS’， SWITCH_TIME_IN_CALL = 600）； A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（） A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.
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 performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
Which is an example of a dynamic SELECT statement? （）A、A query whose object names change during its execution. B、A query whose object names are not known until run time. C、A query whose bind variables values change during execution. D、A query whose bind variable values are not known until run time.
Which statement is true about the log-output variable?（）A、It is a static variable and can be set only at MySQL server startupB、It enables and starts the General Query LogC、It sets the target location for the binary logs generated by the MySQL severD、It specifies output destinations for the slow and General Query logs
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 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？（）A、Use the dnslint utility to query each DNS server.B、Use the dnscmd utility to query each DNS server.C、Use the nslookup utility to query each DNS server.D、Use the adsiedit utility to query Active Directory for a list of DNS zones.
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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? （） A、You should use the Database Engine Tuning Advisor tool B、You should use the Windows System Monitor tool C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
单选题You want a record of all queries that are not using indexes. How would you achieve this?（）ABy enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyBBy enabling the Error Log because not using indexes is an errorCBy enabling the Slow Query Log and using the – log-queries-not-using-indexes optionDBy enabling the Error Log and using the – log-queries-not-using-indexes option
单选题A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）AExecute the query and view Active Session History (ASH) for information about the query.BEnable SQL trace for the query.CCreate a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.DUse the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
单选题Which of the following statements best describes Flashback Versions Query？（）A Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
单选题You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE （PLAN = ’SALES_PLAN’， GROUP_OR_SUBPLAN = ’MANAGERS’， CPU_P1 = 100， CPU_P2 =0， SWITCH_GROUP = ’CLERKS’， SWITCH_TIME_IN_CALL = 600）； A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）A The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.B The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.D The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.
单选题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 executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number （SCN） to which you can flash back your database
单选题Which statement is true about the log-output variable?（）AIt is a static variable and can be set only at MySQL server startupBIt enables and starts the General Query LogCIt sets the target location for the binary logs generated by the MySQL severDIt specifies output destinations for the slow and General Query logs
单选题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？（）AUse the dnslint utility to query each DNS server.BUse the dnscmd utility to query each DNS server.CUse the nslookup utility to query each DNS server.DUse the adsiedit utility to query Active Directory for a list of DNS zones.
单选题Which is an example of a dynamic SELECT statement? （）AA query whose object names change during its execution. BA query whose object names are not known until run time. CA query whose bind variables values change during execution. DA query whose bind variable values are not known until run time.