CMS专题
单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）AThe time when the last flashback operation in your database was performed.B
题目
The time when the last flashback operation in your database was performed.
The time when the first flashback operation in your database was performed.
A list of flashback operations performed in your database using SCN and time.
The approximate time and the lowest system change number （SCN） to which you can flash back your database.
相似问题和答案
第1题：
Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
第2题：
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？（）
- A、 You must use automatic undo management in the database.
- B、 You must configure OMF in your database.
- C、 You must configure ASM for storing the datafiles.
- D、 You must multiplex the online redo log file.
正确答案:A
第3题：
Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
第4题：
Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）
- A、The table is moved to the SYSAUX tablespace.
- B、The table is moved to the SYSTEM tablespace.
- C、The table is removed from the database permanently.
- D、The table is renamed and remains in the TBSFD tablespace.
正确答案:D
第5题：
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
第6题：
You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）
- A、You performed rollback after commit.
- B、If a log switch occurs in your database.
- C、Thearchiverfails to generate an archived log file.
- D、Instance recovery fails to find one of the redo log files.
- E、A long-running query is unable to get read-consistent image.
- F、If you perform manual undo management operations in auto mode.
正确答案:E
第7题：
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）
- A、You obtain the results retrieved from the public synonym HR created by the database administrator.
- B、You obtain the results retrieved from the HR table that belongs to your schema.
- C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
- D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
- E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
正确答案:B
第8题：
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)
第9题：
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time 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
第10题：
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