当前位置:1Z0-053题库

问题:

[单选]

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

The customer has agreed that the SAN proposal is the best solution for their budget. Howeverthey are still unsure of using such leading edge technology. Which item below would help themfeel more comfortable?() TCO study 。 A demonstration at a BPIC 。 IBM customer references 。 IBM Redbook。 什么是唤醒调整(干预)如何让运动员放松或者紧张起来? You need to resolve the double counting of transactions issue in the existing reports. What should you do?() Apply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.。 Apply a Conditional Split transformation in the Transaction data in the SSIS package.。 Delete the AccountHolder table in the WoodgroveDW database.。 Apply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.。 Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation?() recover using Oracle Flashback Database technology。 restore the data files from backup and perform a complete recovery。 restore only the corrupted data file and perform tablespace recovery。 restore the data files from backup and perform cancel­based recovery。 restore the entire database from the most recent backup and start the instance and open the database。 混凝土结构失稳的加固方法有() 外粘钢板加固法。 内粘钢板加固法。 粘贴纤维复合材加固法。 压浆混凝土修补法。 环氧材料修补法。

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?()

参考答案:

  参考解析

本题暂无解析

在线 客服