本文主要是介绍OCP-1Z0-053-V13.02-67题,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
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题的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!