單項(xiàng)選擇題

On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

A. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
B. You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
C. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
D. You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

你可能感興趣的試題

多項(xiàng)選擇題

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

A. log writer
B. archival
C. process monitor
D. system monitor
E. change tracking writer
F. database writer

單項(xiàng)選擇題

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

A. take data files from the read-only tablespace offline before performing a recovery
B. recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
C. drop the read-only tablespace and re-create the tablespace after recovery
D. perform a recovery； status of the tablespace in control file will be changed automatically

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

你可能感興趣的試題

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）