Before a Flashback Table operation,you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
A Because row IDs may change during the flashback operation
B Because the object number changes after the flashback operation
C Because the rows are retrieved from the recycle bin during the flashback operation
D Because the table is moved forward and back to a temporary during the flashback opertion
正确答案
答案解析
相似试题
(单选题)
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?()
(单选题)
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
(单选题)
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
(单选题)
Examine the following RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?()
(单选题)
A user is running a long update batch file. Many tables are updated and all the statements are in one transaction. Before the process is finished, the user machine lost power. When the user calls you, what should you do as DBA?()
(单选题)
You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan?()
(单选题)
You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema. Which process writes the before images of the physical database blocks to the flashback database logs?()
(单选题)
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time, the maintenance window closes before the statistics are gatheredfor all objects. Which statement is true in this scenario()
(单选题)
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time, the maintenance window closes before the statisticsare gathered for all objects. Which statement is true in this scenario()