违法和不良信息举报 联系客服
免费注册 登录

You executed the following query： SELECT operation， undo_sql

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

are you experienced with following machines or operation ?


正确答案：I am experienced with the unmanned (or unattended) engine room ,controllable pitch propeller ,twin engine with clutch ,and MK5 main engine overhaul ,main engine hearing and crankpin hearing overhaul ,boiler overhaul and safety equipment survey .

第2题：

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

第3题：

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 purged

B. Only the table with the oldest DROPSCN is purged

C. The command returns an error because multiple entries with the same name exist in the recycle bin

D. Only the table with the latest DROPSCN is purged


参考答案：B

第4题：

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

第5题：

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

第6题：

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

第7题：

At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）

  • A、 William used the Flashback Version Query feature.
  • B、 William issued the CROSSCHECK command at the RMAN prompt.
  • C、 William viewed the alert log file.
  • D、 William used the Flashback Table feature.

正确答案:A

第8题：

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 segment

B. Temporary segment

C. Data segment

D. Index segment


参考答案：B

第9题：

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

第10题：

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

更多相关问题
相关内容