Oracle认证考试
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（） A、It would return information regarding only the last committed transaction.B、It would re
题目
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
- A、It would return information regarding only the last committed transaction.
- B、It would return only the active transactions in all the undo segments in the database.
- C、It would return only the committed transactions in all the undo segments in the database.
- D、It would return both active and committed transactions in all the undo segments in the database.
- E、It would return information regarding the transactions that began and were committed in the last 30 minutes.
相似问题和答案
第1题：
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?（）
A. It must be executed from the Oracle Database 11g environment.
B. It must be executed only after the SYSAUX tablespace has been created.
C. It must be executed from the environment of the database that is being upgraded.
D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
第2题：
You executed the following procedure to collect statistics regarding an index： SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）
- A、 INDEX_STATS
- B、 DBA_INDEXES
- C、 DBA_IND_COLUMNS
- D、 V$OBJECT_USAGE
正确答案:A
第3题：
A、no least delay
B、least possible
C、least any
D、the least possible
第4题：
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）
- A、the time when the last flashback operation in your database was performed
- B、the time when the first flashback operation in your database was performed
- C、a list of flashback operations performed in your database using SCN and time
- D、the approximate time and the lowest system change number （SCN） to which you can flash back your database
正确答案:D
第5题：
You executed the following code： BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE （ NAME => ’JOB_A’， ATTRIBUTE => ’JOB_PRIORITY’， VALUE => 7）； END； / After analyzing the above code， what conclusion will you draw？（）
- A、 The code will be executed successfully.
- B、 The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
- C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
- D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
正确答案:C
第6题：
A.A
B.B
C.C
D.D
第7题：
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
- A、renaming the control files
- B、dropping a user in your database
- C、enabling or disabling redo log archiving
- D、dropping a tablespace in your database
- E、re-creating the control files， after you lost all the control files in your database
正确答案:C
第8题：
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
第9题：
In which scenario will you create a hash cluster？（）
- A、 when you want the data to be returned automatically in chronological order
- B、 if the application uses queries joining tables only occasionally
- C、 if the queries against the clustered table use the equality operator （=） to retrieve the desired row
- D、 if the full table scan is executed often on only one of the clustered tables
正确答案:C
第10题：
Which statement about using RMAN stored scripts is true?（）
- A、To create and execute an RMAN stored script, you must use a recovery catalog.
- B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
- C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
- D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
正确答案:A