单选题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

第1题：

第2题：

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.

第3题：

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.

第4题：

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 file
• B、Query the V$FLASHBACK_DATABASE_LOG view
• C、Query the V$RECOVERY_FILE_DEST_SIZE view
• D、Query the V$FLASHBACK_DATABASE_STAT view
• E、Check the value assigned for the UNDO_RETENTION parameter

第5题：

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 performed
• B、the time when the first flashback operation in your database was performed
• C、a list of flashback operations performed in your database using SCN and time
• D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

第6题：

Which statement is true about the log-output variable?（）

• A、It is a static variable and can be set only at MySQL server startup
• B、It enables and starts the General Query Log
• C、It sets the target location for the binary logs generated by the MySQL sever
• D、It specifies output destinations for the slow and General Query logs

第7题：

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.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

关于mysql_db_query与mysql_query说法正确的是：（）

• A、mysql_db_query与mysql_query在执行sql语句后的返回值是一样的，成功返回资源号，失败返回FALSE
• B、不能用mysql_query函数临时在另一个数据库上执行sql语句，而mysql_db_query可以
• C、mysql_db_query不会切换回先前连接到的数据库
• D、mysql_query在功能上等于mysql_select_db（）+mysql_db_query（）

第14题：

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 Log
• B、The binary Log records more data than the General Query Log
• C、The Slow Query Log records more data than the General Query Log
• D、The General Query Log records more data than the Slow Query Log
• E、The Slow Query Log records more data than the Binary Log
• F、The Binary Log records more data than the Slow Query Log

第15题：

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

第16题：

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：   SQL>EXEC 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.

第17题：

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.

第18题：

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

第19题：

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

第20题：

第21题：

第22题：

第23题：

第24题：