单选题

Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8:30 a.m. With reference to this scenario, what would you do to recover the database?()

Arestore all the data files from last Sunday’s backup, and then perform a time­based recovery

Brestore all the data files from last Sunday’s backup, and then perform a cancel­based recovery

Crestore all the data files from last Sunday’s backup, and then perform a change­based recovery

Drestore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery

正确答案

来源:www.examk.com

答案解析

相似试题
  • You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()

    单选题查看答案

  • You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()  

    单选题查看答案

  • Which are the prerequisites for performing flashback transactions on your database?()

    多选题查看答案

  • If you create your database using Oracle Managed Files (OMF), what is true?()

    单选题查看答案

  • 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?()

    单选题查看答案

  • If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()  

    单选题查看答案

  • Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()

    单选题查看答案

  • You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()

    单选题查看答案

  • Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()

    单选题查看答案

  • You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()

    多选题查看答案