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

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

2.Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）A. Rollback segmentB. Temporary segmentC. Data segmentD. Index segment

3.are you experienced with following machines or operation ?

4.You define a multiple－row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? ()A. The main query executes with the first value returned by the subquery.B. The main query executes with the last value returned by the subquery.C. The main query executes with all the values returned by the subquery.D. The main query fails because the multiple-row subquery cannot be used with the comparison operator.E. You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

更多“You executed the following query：  SELECT operation， undo_sq”相关问题

  • 第1题：

    Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）

    A.A

    B.B

    C.C

    D.D

    E.E


    参考答案：A

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    Note the output of the following query；   SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table：   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE；   What is the outcome of this command？（）  

    • A、 The table uses the default Flashback Data Archive.
    • B、 The Flashback Data Archive Is created In the SYSAUX tablespace.
    • C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.
    • D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

    正确答案:A

  • 第5题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed， a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions， this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless， the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However， the application that executes the query should not be changed. In addition， the effect on end users should be cut to the least.  Which action should be performed to finish the task？（）

    • A、To finish the task， the index should be built by utilizing a FILLFACTOR of 10 percent.
    • B、To finish the task， the index should be recreated to have all of the columns in the table included.
    • C、To finish the task， an indexed view of the Orders table should be viewed.
    • D、To finish the task， the statistics should be updated on the index.

    正确答案:D

  • 第6题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第7题：

    单选题
    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
    A

    The EMPLOYEES table will be changed to read-only mode during the shrink operation.

    B

    The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

    C

    The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

    D

    Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.


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

  • 第8题：

    单选题
    After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance：   Select group_number， count（*） from v$asm_operation；   What is the implication if the query against V$ASM_OPERATION returns zero rows？（）
    A

     The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

    B

     The drop disk operation is complete and you can run the undrop disks command if needed.

    C

     The drop disk operation is complete and you cannot run the undrop disk command.

    D

     The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 

    E

     None of the above is true.


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

  • 第9题：

    单选题
    Examine the following command：   SQL> ALTER TABLE booking SHRINK SPACE COMPACT；   Which activity is performed when the preceding command is executed？（）
    A

     The shrink operation touches every block in the BOOKING table

    B

     The high-water mark （HWM） for the BOOKING table is shifted from its original position

    C

     The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

    D

     The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation


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

  • 第10题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

    back up the control file to trace

    B

    bring database to the MOUNT state

    C

    open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

    set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第11题：

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


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

  • 第12题：

    单选题
    EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）
    A

    Exhibit A

    B

    Exhibit B 

    C

    The query returns no rows 

    D

    The query fails because the outer query is retrieving more than one column

    E

    The query fails because both the inner and outer queries are retrieving data from the same table.


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

  • 第13题：

    You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）

    • A、guarantee undo retention
    • B、add one more redo log group
    • C、size the redo log files appropriately
    • D、size the UNDO tablespace appropriately
    • E、size the SYSTEM tablespace appropriately
    • F、configure an appropriate undo retention interval
    • G、change automatic undo management to manual

    正确答案:A,D,F

  • 第14题：

    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

  • 第15题：

    You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）

    • A、The main query executes with the first value returned by the subquery.
    • B、The main query executes with the last value returned by the subquery.
    • C、The main query executes with all the values returned by the subquery.
    • D、The main query fails because the multiple-row subquery cannot be used with the comparison operator.
    • E、You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

    正确答案:D

  • 第16题：

    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

  • 第17题：

    单选题
    Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
    A

    Because row IDs may change during the flashback operation

    B

    Because the object number changes after the flashback operation

    C

    Because the rows are retrieved from the recycle bin during the flashback operation

    D

    Because the table is moved forward and back to a temporary during the flashback opertion


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

  • 第18题：

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


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

  • 第19题：

    单选题
    Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）
    A

    The shrink operation touches every block in the BOOKING table

    B

    The high-water mark (HWM) for the BOOKING table is shifted from its original position

    C

    The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

    D

    The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation


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

  • 第20题：

    单选题
    Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
    A

    Because row IDs may change during the flashback operation

    B

    Because the object number changes after the flashback operation

    C

    Because the rows are retrieved from the recycle bin during the flashback operation

    D

    Because the table is moved forward and back to a temporary during the flashback operation


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    多选题
    You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error：  ORA-01555： snapshot too old  How would you prevent such an error in the future？（）
    A

    guarantee undo retention

    B

    add one more redo log group

    C

    size the redo log files appropriately

    D

    size the UNDO tablespace appropriately

    E

    size the SYSTEM tablespace appropriately

    F

    configure an appropriate undo retention interval

    G

    change automatic undo management to manual


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

  • 第23题：

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


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

  • 第24题：

    单选题
    You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server 2008 instance. Look at the following query: SELECT s.*, i.* FROM SensitiveTbl AS s INNER JOIN InsensitiveTbl AS iON i. OrganizationName = s.OrganizationName You use the above query to join two tables on a column named OrganizationName. The following error is returned when you execute the query. "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between 'SQL_Latin1_General_CP1_CS_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation." The ON clause of the query has to be modified so that it can perform a case-sensitive joinsuccessfully. What should you do? （）
    A

    ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)

    B

    ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName) 

    C

    ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS 

    D

    ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS 


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

相关内容