网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）
A
XID
B
VERSIONS_PK
C
VERSIONS_XID
D
VERSIONS_UNIQUE
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）A XIDB VERSIONS_PKC VERSIONS_XIDD VERSIONS_UNIQUE” 相关考题
考题
WhichpseudocolumncouldyouusetoidentifyauniquerowinaFlashbackVersionsQuery?()
A.XIDB.VERSIONS_PKC.VERSIONS_XIDD.VERSIONS_UNIQUE
考题
Which of the following statements best describes Flashback Versions Query？（） A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B、 Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D、 Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
考题
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）A、 Only the Flashback TableB、 Both the Flashback Transaction Query and the Flashback Version QueryC、 Only the Flashback DropD、 Only the Flashback Version
考题
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
考题
By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. A、 Flashback TableB、 Flashback DatabaseC、 Flashback Version QueryD、 The RMAN REPORT commandE、 The DBA_PENDING_TRANSACTIONS view
考题
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）A、RMAN onlyB、Flashback Table onlyC、Flashback Versions Query onlyD、Flashback Database and Flashback Transaction QueryE、Flashback Versions Query and Flashback Transaction Query
考题
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
考题
In which scenario do you use the Flashback Database feature？（）A、 when a table is dropped and you restore it from the Recycle BinB、 when a user’s schema is dropped and you recover the user’s schemaC、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
考题
In which scenario will you use the Flashback Transaction Query feature？（）A、 when you want to restore an important table that is dropped from the Recycle BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
考题
Which two statements are correct regarding the Flashback Versions Query feature？（）A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.B、 You can use this feature to identify the versions of V$ views.C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.D、 You can use this feature for a table only if row movement is enabled for the table.E、 You can use this feature to identify the versions of external and fixed tables.
考题
By using the transaction identifier provided by （） for a particular row change， you can use theFlashback Transaction Query to see the operation performed by the transaction. A、Flashback TableB、Flashback DatabaseC、Flashback Versions QueryD、the RMAN REPORT commandE、the DBA_PENDING_TRANSACTIONS view
考题
By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. A、Flashback TableB、Flashback DatabaseC、Flashback Versions QueryD、the RMAN REPORT commandE、the DBA_PENDING_TRANSACTIONS view
考题
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）A、 RMAN only.B、 Flashback Table only.C、 Flashback Version Query only.D、 Flashback Database and Flashback Transaction Query.E、 Flashback Version Query and Flashback Transaction Query.
考题
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）A、 XIDB、 VERSIONS_PKC、 VERSIONS_XIDD、 VERSIONS_UNIQUE
考题
单选题In which scenario will you use the Flashback Transaction Query feature？（）A
when you want to restore an important table that is dropped from the Recycle BinB
when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC
when you want to restore a dropped user’s schemaD
when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
考题
单选题In which scenario do you use the Flashback Database feature？（）A
when a table is dropped and you restore it from the Recycle BinB
when a user’s schema is dropped and you recover the user’s schemaC
when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD
when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
考题
单选题By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.A
Flashback TableB
Flashback DatabaseC
Flashback Version QueryD
The RMAN REPORT commandE
The DBA_PENDING_TRANSACTIONS view
考题
单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A
VERSIONS_STARTSCNB
VERSIONS_STARTTIMEC
VERSIONS_XIDD
VERSIONS_OPERATION
考题
单选题Which of the following statements best describes Flashback Versions Query？（）A
Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B
Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C
Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D
Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
考题
单选题You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）A
Only the Flashback TableB
Both the Flashback Transaction Query and the Flashback Version QueryC
Only the Flashback DropD
Only the Flashback Version
考题
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A
You must use automatic undo management in the database.B
You must configure OMF in your database.C
You must configure ASM for storing the datafiles.D
You must multiplex the online redo log file.
考题
单选题View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）A
The row movement is not enabled on the table.B
The first two updates were not explicitly committed.C
The Flashback Versions Query lists only the most recent update.D
The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.
考题
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）A
RMAN onlyB
Flashback Table onlyC
Flashback Versions Query onlyD
Flashback Database and Flashback Transaction QueryE
Flashback Versions Query and Flashback Transaction Query
考题
单选题In which scenario will you use the Flashback Version Query feature？（）A
when you want to restore a table that has been dropped from the Recycle BinB
when you want to identify the transaction ID of the transaction that deleted some important records from a tableC
when you want to recover the schema of a dropped userD
when you want to restore a dropped tablespace
考题
多选题Which two statements are correct regarding the Flashback Versions Query feature？（）AYou can use this feature to identify the committed versions of the rows， but not the uncommitted versions.BYou can use this feature to identify the versions of V$ views.CYou can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.DYou can use this feature for a table only if row movement is enabled for the table.EYou can use this feature to identify the versions of external and fixed tables.
考题
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）A
RMAN only.B
Flashback Table only.C
Flashback Version Query only.D
Flashback Database and Flashback Transaction Query.E
Flashback Version Query and Flashback Transaction Query.
考题
单选题By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.A
Flashback TableB
Flashback DatabaseC
Flashback Versions QueryD
the RMAN REPORT commandE
the DBA_PENDING_TRANSACTIONS view
考题
单选题Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）A
XIDB
VERSIONS_PKC
VERSIONS_XIDD
VERSIONS_UNIQUE
热门标签
最新试卷
