單項(xiàng)選擇題

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.

你可能感興趣的試題

多項(xiàng)選擇題

In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？（）

A. The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B. The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C. The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D. If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.
E. Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

單項(xiàng)選擇題

Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

A. The redo log file should belong to an active group.
B. The redo log file should belong to an inactive group.
C. The redo log file should belong to the current group.
D. The redo log file can be dropped only if all the transactions are stopped.
E. Before a redo log file is dropped， it should be deleted from the operating system （OS）.

你可能感興趣的試題

In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）

Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？（）

Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）