OCP-1Z0-053-V13.02-67题
来源:互联网 发布:建立网络连接失败183 编辑:程序博客网 时间:2024/06/05 11:08
67.On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?
(Choose two.)
A. fixed tables
B. heap tables
C. external tables
D. temporary tables
E. Index-Organized Tables (IOTs)
Answer: BE
答案解析:
同489题:http://blog.csdn.net/rlhua/article/details/19175515
参考:http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_10002.htm#SQLRF55624
排除法,选择BE
Restrictions on Flashback Queries These queries are subject to the following restrictions:
You cannot specify a column expression or a subquery in the expression of the
AS
OF
clause.You cannot specify the
AS
OF
clause if you have specified thefor_update_clause
.You cannot use the
AS
OF
clause in the defining query of a materialized view.You cannot use the
VERSIONS
clause in flashback queries to temporary or external tables, or tables that are part of a cluster.You cannot use the
VERSIONS
clause in flashback queries to views. However, you can use theVERSIONS
syntax in the defining query of a view.You cannot specify the
flashback_query_clause
if you have specifiedquery_name
in thequery_table_expression
.
同489题
To research an erroneous change, you can use multiple Oracle Flashback queries to view row data at specific points in time. A more efficient approach would be to use Oracle Flashback Version Query to view all changes to a row over a period of time. With this feature, you append a VERSIONS
clause to a SELECT
statement that specifies a system change number (SCN) or timestamp range between which you want to view changes to row values. The query also can return associated metadata, such as the transaction responsible for the change.
- OCP-1Z0-053-V13.02-67题
- OCP-1Z0-053-V13.02-1题
- OCP-1Z0-053-V13.02-682题
- OCP-1Z0-053-V13.02-687题
- OCP-1Z0-053-V13.02-692题
- OCP-1Z0-053-V13.02-696题
- OCP-1Z0-053-V13.02-711题
- OCP-1Z0-053-V13.02-710题
- OCP-1Z0-053-V13.02-709题
- OCP-1Z0-053-V13.02-708题
- OCP-1Z0-053-V13.02-706题
- OCP-1Z0-053-V13.02-490题
- OCP-1Z0-053-V13.02-24题
- OCP-1Z0-053-V13.02-36题
- OCP-1Z0-053-V13.02-43题
- OCP-1Z0-053-V13.02-45题
- OCP-1Z0-053-V13.02-60题
- OCP-1Z0-053-V13.02-651题
- OCP-1Z0-053-V13.02-489题
- OCP-1Z0-053-200题-95题-489
- j2ee 权限-动态菜单设计
- VC/MFC / 数据库 MySQL
- 服务器见的心跳
- OCP-1Z0-053-V13.02-67题
- [读者]我始终相信努力奋斗的意义
- Ajax开发20个问题
- linux gcc 编译时头文件和库文件搜索路径
- SOM网络
- Unix/Linux下退出帐户/关闭终端之后继续运行相应的进程
- 网络编程(1)跨平台的Socket同步阻塞工作模式例子
- C++中extern “C”含义深层探索
- j2ee集成支付宝即时到账(Demo解析)