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

第1题：

第2题：

Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）

• A、MQT
• B、Trigger
• C、Read Only Cursor
• D、Stored Procedure

第3题：

第4题：

Which two statements are true regarding the ORDER BY clause? （）

• A、The sort is in ascending by order by default.
• B、The sort is in descending order by default.
• C、The ORDER BY clause must precede the WHERE clause.
• D、The ORDER BY clause is executed on the client side.
• E、The ORDER BY clause comes last in the SELECT statement.
• F、The ORDER BY clause is executed first in the query execution.

第5题：

You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）

• A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
• D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
• E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

第6题：

第7题：

Which statement is true regarding the INTERSECT operator?（）

• A、It ignores NULL values 
• B、Reversing the order of the intersected tables alters the result 
• C、The names of columns in all SELECT statements must be identical 
• D、The number of columns and data types must be identical for all SELECT statements in the query 

第8题：

第9题：

Which three statements about dynamic filtering are true? （）

• A、Dynamic filtering creates a query statement.
• B、Dynamic filtering has an option to save query.
• C、Dynamic filtering can select any log field to filter.
• D、Dynamic filtering permanently removes other log entries.
• E、Dynamic filtering redraws the log when you select a variable link.

第10题：

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