单选题You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）AIt would return information regarding only the last committed transaction.BIt would ret

第1题：

To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）

• A、It contains only the plan for the SQL statement executed by the user.
• B、It contains the SQL text executed by the user and the bind variables used with it.
• C、It contains the plan and statistics associated with the SQL statement executed by the user.
• D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.

第2题：

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.

第3题：

第4题：

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

• A、It is executed first in the query execution 
• B、It must be the last clause in the SELECT statement 
• C、It cannot be used in a SELECT statement containing a HAVING clause
• D、You cannot specify a column name followed by an expression in this clause 
• E、You can specify a combination of numeric positions and column names in this clause

第5题：

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

• A、User process
• B、Server process
• C、System Monitor (SMON)
• D、Process Monitor (PMON)
• E、Checkpoint process (CKPT)

第6题：

Which of the following would contain information regarding network device alerts using SNMP?（）

• A、Syslog
• B、Audit log
• C、History log
• D、Ping sweep reports

第7题：

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.

第8题：

第9题：

You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

• A、 It would return information regarding only the last committed transaction.
• B、 It would return only the active transactions in all the undo segments in the database.
• C、 It would return only the committed transactions in all the undo segments in the database.
• D、 It would return both active and committed transactions in all the undo segments in the database.
• E、 It would return information regarding the transactions that began and were committed in the last 30 minutes.

第10题：

Which two statements are true regarding subqueries? （）

• A、A subquery can retrieve zero or more rows 
• B、Only two subqueries can be placed atone level 
• C、A subquery can be used only in SQL query statements 
• D、A subquery can appear on either side of a comparison operator 
• E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement