You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?() Use a flashback query to retrieve the rows that were deleted。 Useconventialincremental export and then import the affected object。 Shutdown the database inNORMALmode and restart the database instance。 Use DBMS_META package to reconstruct the object using undo segments。 UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data。 Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.。
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?() It would return information regarding only the last committed transaction.。 It would return only the active transactions in all the undo segments in the database.。 It would return only the committed transactions in all the undo segments in the database.。 It would return both active and committed transactions in all the undo segments in the database.。 It would return information regarding the transactions that began and were committed in the last 30 minutes.。
影响细菌生长繁殖的主要因素有哪些?
在非常情况下,监理机构可以先通过电话或口头传递工程文件内容要点,并在随后的()内补传书面正式文件。 A.4小时 。 B.8小时 。 C.24小时 。 D.72小时。
Which statement about Automatic Memory Management with Oracle 11g is true?() You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.。 Oracle can reallocate memory between the SGA and PGA automatically as needed.。 To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.。 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.。
What is true about the WITH GRANT OPTION clause?()