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

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

相似考题

1.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 processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)

2. 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.

3.Which of the following would contain information regarding network device alerts using SNMP?（）A、SyslogB、Audit logC、History logD、Ping sweep reports

4.Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged

更多“单选题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”相关问题

  • 第1题：

    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.

    正确答案:E

  • 第2题：

    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)

    正确答案:B

  • 第3题：

    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

    正确答案:B,E

  • 第4题：

    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time 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.

    正确答案:D

  • 第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

    正确答案:D

  • 第6题：

    多选题
    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.


    正确答案： A,D
    解析： 暂无解析

  • 第7题：

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


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


    正确答案： A
    解析： 暂无解析

  • 第9题：

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


    正确答案： E
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

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


    正确答案： E,C
    解析： 暂无解析

  • 第12题：

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


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:A,E

  • 第14题：

    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.

    正确答案:D

  • 第15题：

    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 

    正确答案:A,D

  • 第16题：

    Which statement is true regarding Flashback Version Query？ （）

    • A、 It returns versions of rows only within a transaction.
    • B、 It can be used in subqueries contained only in a SELECT statement.
    • C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
    • D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

    正确答案:D

  • 第17题：

    单选题
    Which statement is true regarding Flashback Version Query？（）
    A

     It returns versions of rows only within a transaction.

    B

     It can be used in subqueries contained only in a SELECT statement.

    C

     It will return an error if the undo retention time is less than the lower bound time or SCN specified.

    D

     It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.


    正确答案： C
    解析： 暂无解析

  • 第18题：

    多选题
    Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）
    A

    You can find information about only active transactions from the view

    B

    You can find information about read only transactions from the view

    C

    You require the SELECT ANY TRANSACTION system privilege to access the view

    D

    You can find information about both active and committed transactions from the view

    E

    You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view


    正确答案： C,E
    解析： 暂无解析

  • 第19题：

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


    正确答案： B
    解析： 暂无解析

  • 第20题：

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


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    A user named Arren is executing this query：   select table_name，operation，undo_sql  from  flashback_transaction_query t，  （select versions_xid as xid  from employees versions between scn minvalue and maxvalue  where employee_id = 123） e  where t.xid = e.xid；   When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem.  Which of the following SQL statements will correct this problem？（）
    A

     GRANT SELECT ANY TRANSACTION TO ARREN

    B

     GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN

    C

     GRANT SELECT_ANY_TRANSACTION TO ARREN

    D

     GRANT FLASHBACK TO ARREN

    E

     GRANT SELECT ANY VIEW TO ARREN


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time 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.


    正确答案： D
    解析： 暂无解析

  • 第23题：

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


    正确答案： C
    解析： 暂无解析

  • 第24题：

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


    正确答案： D
    解析： 暂无解析

相关内容