当前位置:1Z0-052题库

问题:

[单选]

View the Exhibit and examine the attributes of an undo tablespace. 

In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hourthat performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives thefollowing error: 
ORA-01555: snapshot too old 
What could be the reason for this error() 

A . The query is unable to get a read-consistent image.
B . There is not enough space in Flash Recovery Area.
C . There is not enough free space in the flashback archive.
D . The query is unable to place data blocks in undo tablespace

It is considered a best practice to use the Dead Peer Detection (DPD) feature with which VPN topologies?() IPSec。 IPSec with GRE。 DMVPN。 EZVPN。 all of the choice。 表演游戏 穆旦诗歌艺术的创新,主要体现在哪几个方面? 简述地价的特征有哪些? You work as a database administrator at Certkiller .com. In your production database, you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? ()  CPU usage。  degree of parallelism。  number of open cursors。  number of sorts performed。  idle time for blocking sessions。  number of disk I/O operations performed。  number of memory I/O operations performed。

View the Exhibit and examine the attributes of an undo tablespace. 

In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hourthat performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives thefollowing error: 
ORA-01555: snapshot too old 
What could be the reason for this error() 

参考答案:

  参考解析

快照太旧错误是因为没有足够的还原数据来实现读取一致性。所以选A。

在线 客服