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?()
Which statements are true regarding the Query Result Cache?()
In order to perform Flashback Transaction Query operations, which of these steps are required?()
You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?()
You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?()
At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group populated?()
You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. IAsyncResult ar = cmd.BeginExecuteReader( ); You need to execute a method named DoWork( ) that takes one second to run while the SQL query is executing.DoWork( ) must run as many times as possible while the SQL query is executing. Which code segment should you use?()
View the Exhibit and examine the output of the query. What do you infer from this()
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()